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