17.10 - 例: SHOWWHEREおよびSPOOL CLASS出力のファイル システム情報テーブルの挿入('L'オプション) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL演算子およびユーザー定義関数

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
2021年7月
Content Type
プログラミング リファレンス
管理
Publication ID
B035-1210-171K-JPN
Language
日本語 (日本)

ターゲット テーブルを作成し、大きな表示出力用のデータをテーブルに挿入します。スペースの制約のため、出力の右側のいくつかの列は含まれていません。

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