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