16.20 - 例: SHOWCOMPRESS出力のファイル システム情報テーブルの挿入(オプション'L') - Teradata Vantage NewSQL Engine

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

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
プログラミング リファレンス
管理
featnum
B035-1210-162K-JPN

テーブルの作成:

create multiset table Call_Logs.Daily_Log as dbc.tvm with data;

SHOWCOMPRESSデータを含むデータ テーブルの作成:

exec 
     createfsysinfotable('Call_Logs'
		   ,'showcTrgTableLong'
		   ,'perm'
		   ,'y'
		   ,'showcompress'
		   ,'l'
		   ,'TD_Map1');

ストアド プロシージャを使用してデータをターゲット テーブルに挿入する手順:

exec 
   populatefsysinfotable('Call_Logs'
     		,'Daily_Log'
     		,'showcompress'
     		,'l'
     		,'Call_Logs'
     		,'showcTrgTableLong');

*** Procedure has been executed. 

.foldlineおよび.sidetitles書式設定の修飾子でbteqを使用して長い表示出力のデータを表示する手順:

exec populatefsysinfotable('Call_Logs','Daily_Log','showcompress','l','','');

 *** Procedure has been executed. 
 *** Warning: 3212 The stored procedure returned one or more result sets.
 *** Total elapsed time was 2 seconds.

 *** ResultSet# 1 : 9 rows returned by "SYSLIB.POPULATEFSYSINFOTABLESP".

               Date  17/12/08
               Time  07:11:01
            DB Name  Call_Logs
           Tbl Name  Daily_log
                TID  0000BF270000
            TID_TAI      -1
     TLA BLC Option  DEFAULT
  System BLC Option  MANUAL
        TLA BLC ALG  DEFAULT
     System BLC ALG  ZLIB
      TLA BLC Level  DEFAULT
   System BLC Level  6
           Map Name  TD_MAP1
         Comp State  COMPRESSED
          Comp Algo  IPPZLIB
         Comp Level  6
Exact Comp Ratio(%)    85.38
Exact (%) of Blocks    91.17
  Exact (%) of Data    88.28
      Exact Used GB
      
               Date  17/12/08
               Time  07:11:01
            DB Name  Call_Logs
           Tbl Name  Daily_log
                TID  0000BF270000
            TID_TAI      -1
     TLA BLC Option  DEFAULT
  System BLC Option  MANUAL
        TLA BLC ALG  DEFAULT
     System BLC ALG  ZLIB
      TLA BLC Level  DEFAULT
   System BLC Level  6
           Map Name  TD_MAP1
         Comp State  UNCOMPRESSED
          Comp Algo  N/A
         Comp Level  N/A
Exact Comp Ratio(%)
Exact (%) of Blocks     8.82
  Exact (%) of Data    11.71
      Exact Used GB
      
               Date  17/12/08
               Time  07:11:01
            DB Name  Call_Logs
           Tbl Name  Daily_log
                TID  0000BF270000
            TID_TAI       0
     TLA BLC Option  DEFAULT
  System BLC Option  MANUAL
        TLA BLC ALG  DEFAULT
     System BLC ALG  ZLIB
      TLA BLC Level  DEFAULT
   System BLC Level  6
           Map Name  TD_MAP1
         Comp State  UNCOMPRESSED
          Comp Algo  N/A
         Comp Level  N/A
Exact Comp Ratio(%)
Exact (%) of Blocks   100.00
  Exact (%) of Data   100.00
      Exact Used GB
      
               Date  17/12/08
               Time  07:11:01
            DB Name  Call_Logs
           Tbl Name  Daily_log
                TID  0000BF270000
            TID_TAI    1024
     TLA BLC Option  DEFAULT
  System BLC Option  MANUAL
        TLA BLC ALG  DEFAULT
     System BLC ALG  ZLIB
      TLA BLC Level  DEFAULT
   System BLC Level  6
           Map Name  TD_MAP1
         Comp State  COMPRESSED
          Comp Algo  IPPZLIB
         Comp Level  6
Exact Comp Ratio(%)    87.31
Exact (%) of Blocks   100.00
  Exact (%) of Data   100.00
      Exact Used GB
      
               Date  17/12/08
               Time  07:11:01
            DB Name  Call_Logs
           Tbl Name  Daily_log
                TID  0000BF270000
            TID_TAI    1028
     TLA BLC Option  DEFAULT
  System BLC Option  MANUAL
        TLA BLC ALG  DEFAULT
     System BLC ALG  ZLIB
      TLA BLC Level  DEFAULT
   System BLC Level  6
           Map Name  TD_MAP1
         Comp State  UNCOMPRESSED
          Comp Algo  N/A
         Comp Level  N/A
Exact Comp Ratio(%)
Exact (%) of Blocks   100.00
  Exact (%) of Data   100.00
      Exact Used GB
      
               Date  17/12/08
               Time  07:11:01
            DB Name  Call_Logs
           Tbl Name  Daily_log
                TID  0000BF270000
            TID_TAI    1032
     TLA BLC Option  DEFAULT
  System BLC Option  MANUAL
        TLA BLC ALG  DEFAULT
     System BLC ALG  ZLIB
      TLA BLC Level  DEFAULT
   System BLC Level  6
           Map Name  TD_MAP1
         Comp State  UNCOMPRESSED
          Comp Algo  N/A
         Comp Level  N/A
Exact Comp Ratio(%)
Exact (%) of Blocks   100.00
  Exact (%) of Data   100.00
      Exact Used GB
      
               Date  17/12/08
               Time  07:11:01
            DB Name  Call_Logs
           Tbl Name  Daily_log
                TID  0000BF270000
            TID_TAI    2048
     TLA BLC Option  DEFAULT
  System BLC Option  MANUAL
        TLA BLC ALG  DEFAULT
     System BLC ALG  ZLIB
      TLA BLC Level  DEFAULT
   System BLC Level  6
           Map Name  TD_MAP1
         Comp State  COMPRESSED
          Comp Algo  IPPZLIB
         Comp Level  6
Exact Comp Ratio(%)    87.31
Exact (%) of Blocks   100.00
  Exact (%) of Data   100.00
      Exact Used GB
      
               Date  17/12/08
               Time  07:11:01
            DB Name  Call_Logs
           Tbl Name  Daily_log
                TID  0000BF270000
            TID_TAI    2052
     TLA BLC Option  DEFAULT
  System BLC Option  MANUAL
        TLA BLC ALG  DEFAULT
     System BLC ALG  ZLIB
      TLA BLC Level  DEFAULT
   System BLC Level  6
           Map Name  TD_MAP1
         Comp State  COMPRESSED
          Comp Algo  IPPZLIB
         Comp Level  6
Exact Comp Ratio(%)    54.00
Exact (%) of Blocks   100.00
  Exact (%) of Data   100.00
      Exact Used GB
      
               Date  17/12/08
               Time  07:11:01
            DB Name  Call_Logs
           Tbl Name  Daily_log
                TID  0000BF270000
            TID_TAI    2056
     TLA BLC Option  DEFAULT
  System BLC Option  MANUAL
        TLA BLC ALG  DEFAULT
     System BLC ALG  ZLIB
      TLA BLC Level  DEFAULT
   System BLC Level  6
           Map Name  TD_MAP1
         Comp State  COMPRESSED
          Comp Algo  IPPZLIB
         Comp Level  6
Exact Comp Ratio(%)    61.00
Exact (%) of Blocks   100.00
  Exact (%) of Data   100.00
      Exact Used GB