17.10 - 例: SHOWWHEREおよびSPOOL CLASS出力のファイル システム情報テーブルの挿入('M'オプション) - 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','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