17.10 - Example: Populate a File System Information Table for SHOWWHERE and SPOOL CLASS Output, 'M' Option - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1210-171K
Language
English (United States)

Create target table and populate data into the table for medium display output. Several columns on the right side of the output are not included because of space contraint.

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

Display data for medium display with output to the screen. Several columns on the right side of the output are not included because of space contraint.

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