ターゲット テーブルを作成し、中程度の長さの表示出力用のデータをテーブルに挿入します。スペースの制約のため、出力の右側のいくつかの列は含まれていません。
exec dbc.createfsysinfotable('db','spools','perm','y','showwhere','m','td_map1');
exec dbc.populatefsysinfotable('dbc','classspool','showwhere','m','db','spoolm');
sel * from db.spoolm;
Date Time DB Name Tbl Name TID TID_TAI Vproc Drive Lrg Cyls Sml Cyls TableType Grade Grade(%)
-------- --------------- ------- --------------- ------------ ------- ----- ----- -------- -------- --------- ------ --------
21/01/13 05:20.19.000000 DBC CLASS SPOOL 000000000000 0 0 -1 0 0 SPOOL SLOW .00
21/01/13 05:20.19.000000 DBC CLASS SPOOL 000000000000 0 0 -1 342 0 SPOOL LOCAL .00
21/01/13 05:20.19.000000 DBC CLASS SPOOLPOOL 000000000000 0 0 -1 0 0 SPOOLPOOL MEDIUM .00
21/01/13 05:20.19.000000 DBC CLASS SPOOL 000000000000 0 1 -1 342 0 SPOOL LOCAL 100.00
21/01/13 05:20.19.000000 DBC CLASS SPOOLPOOL 000000000000 0 0 -1 0 0 SPOOLPOOL SLOW .00
21/01/13 05:20.19.000000 DBC CLASS SPOOL 000000000000 0 1 -1 0 0 SPOOL FAST .00
21/01/13 05:20.19.000000 DBC CLASS SPOOL 000000000000 0 1 -1 0 0 SPOOL SLOW .00
21/01/13 05:20.19.000000 DBC CLASS SPOOLPOOL 000000000000 0 1 -1 0 0 SPOOLPOOL FAST .00
21/01/13 05:20.19.000000 DBC CLASS SPOOLPOOL 000000000000 0 1 -1 0 0 SPOOLPOOL MEDIUM .00
21/01/13 05:20.19.000000 DBC CLASS SPOOLPOOL 000000000000 0 1 -1 0 0 SPOOLPOOL SLOW .00
21/01/13 05:20.19.000000 DBC CLASS SPOOL 000000000000 0 1 -1 0 0 SPOOL MEDIUM .00
21/01/13 05:20.19.000000 DBC CLASS SPOOLPOOL 000000000000 0 1 -1 0 0 SPOOLPOOL FAST .00
21/01/13 05:20.19.000000 DBC CLASS SPOOL 000000000000 0 1 -1 0 0 SPOOL MEDIUM .00
21/01/13 05:20.19.000000 DBC CLASS SPOOL 000000000000 0 1 -1 0 0 SPOOL FAST .00
画面に出力する中程度の長さの表示用のデータを表示します。スペースの制約のため、出力の右側のいくつかの列は含まれていません。
exec dbc.populatefsysinfotable('dbc','classspool','showwhere','m','','');
Date Time DB Name Tbl Name TID TID_TAI Vproc Drive Lrg Cyls Sml Cyls TableType Grade Grade(%)
-------- --------------- ------- --------------- ------------ ------- ----- ----- -------- -------- --------- ------ --------
21/01/13 02:04.44.000000 DBC CLASS SPOOL 000000000000 0 0 -1 SPOOL FAST
21/01/13 02:04.44.000000 DBC CLASS SPOOL 000000000000 0 0 -1 342 SPOOL LOCAL 100.00
21/01/13 02:04.44.000000 DBC CLASS SPOOL 000000000000 0 0 -1 SPOOL MEDIUM
21/01/13 02:04.44.000000 DBC CLASS SPOOL 000000000000 0 0 -1 SPOOL SLOW
21/01/13 02:04.44.000000 DBC CLASS SPOOL 000000000000 0 1 -1 SPOOL FAST
21/01/13 02:04.44.000000 DBC CLASS SPOOL 000000000000 0 1 -1 342 SPOOL LOCAL 100.00
21/01/13 02:04.44.000000 DBC CLASS SPOOL 000000000000 0 1 -1 SPOOL MEDIUM
21/01/13 02:04.44.000000 DBC CLASS SPOOL 000000000000 0 1 -1 SPOOL SLOW
21/01/13 02:04.44.000000 DBC CLASS SPOOLPOOL 000000000000 0 1 -1 SPOOLPOOL FAST
21/01/13 02:04.44.000000 DBC CLASS SPOOLPOOL 000000000000 0 1 -1 SPOOLPOOL MEDIUM
21/01/13 02:04.44.000000 DBC CLASS SPOOLPOOL 000000000000 0 1 -1 SPOOL SLOW
21/01/13 02:04.44.000000 DBC CLASS SPOOLPOOL 000000000000 0 1 -1 SPOOLPOOL FAST
21/01/13 02:04.44.000000 DBC CLASS SPOOLPOOL 000000000000 0 1 -1 SPOOLPOOL MEDIUM
21/01/13 02:04.44.000000 DBC CLASS SPOOLPOOL 000000000000 0 1 -1 SPOOLPOOL SLOW