ターゲット テーブルを作成し、短い表示出力用のデータをテーブルに挿入します。スペースの制約のため、出力の右側のいくつかの列は含まれていません。
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