db2cat 命令

今天无意看到一个命令：db2cat(系统目录分析).

现把测试记录贴上来（在db2cmd下面）：

C:\Documents and Settings\Administrator>db2cat

      ____________________________________________________________________

              _____   DB2 Relational Data Services Tools   _____

                              I      B      M

                                   DB2CAT

          This tool is a utility designed to help in examining packed
          descriptor information stored in the system catalog tables.

      ____________________________________________________________________

DB2 Version 9.5, 5622-044 (c) Copyright IBM Corp. 2007
Licensed Material - Program Property of IBM
IBM DATABASE 2 Catalog Analysis and Repair Tool

Please use single quote for delimited name

Enter Database Name ==> SAMPLE
Connecting to the Database.
Connect to Database Successful.
Enter up to 128 character schema name ==> IES
Enter up to 128 character name ==> AAA
Enter outfile name. Default is to terminal ==> AAA
Output is in AAA.(输出文件)

Executing Connect Reset -- Connect Reset was Successful.

C:\Documents and Settings\Administrator>

 

下面把输出文件AAA贴出来：

DB2 Version 9.5, 5622-044 (c) Copyright IBM Corp. 2007
Licensed Material - Program Property of IBM
IBM DATABASE 2 Catalog Analysis and Repair Tool

Please use single quote for delimited name

*****************************************************************
Table: IES     .AAA   (TABLE)

-----------------------------------------------------------------
TABLE PACKED DESCRIPTOR:

       PACKED DESCRIPTOR HEADER
       ------------------------

 db2cat generated pd       : N
 Length                    : 2816
 Version                   : 0x C00
 Default schema length     : 8
 Default schema            : IES    
 No. of rows               : 148
 No. of pages for table    : 1
 No. of pages in the file  : 1
 No. of overflow records   : 0
 Offset to index info.     : 1248
 No. of indexes            : 0
 No. of xml indexes        : 0
 Total no. of columns      : 1
 Number of column desc     : 1
 Seq ID of identity column : 0

 Read only                 : 0
 Materialization           : 0
 Check Option              : 0
 Create time               : {2009-06-19-13.54.10.491001}
 Alter time                : {2009-06-19-13.54.10.491001}
 Invalidate time           : {2009-06-19-13.54.10.491001}
 Last regeneration time    : {2009-06-19-13.54.10.491001}
 Data Capture              : N
 Table Composite Codepage  : 1208
 Default collation name    : IDENTITY
 Default collation ID in hex: B'00 00 00 02 FF 00 FF FF
 Default order-by collation name: IDENTITY
 Default order-by collation ID in hex: B'00 00 00 02 FF 00 FF FF
 CCSID UNICODE in
      non-unicode database : N
 Table CCSID ASCII         : N
 Table CCSID UNICODE       : N
 Fid                       : 48
 Tid                       : 2
 Last statistic time       : {2009-06-19-16.39.43.624000}
 Last statistic fabrication time       : {0000-00-00-00.00.00.000000}

 Table space name          : USERSPACE1       
 Table space type          : F
 Table space pagesize      : 8192
 Table extent size         : 32
 Table prefetch size       : 32
 Table overhead            : 7.500000
 Table transfer rate       : 0.060000

 Index table space name    :                  

 Tablespace ID             : 2
 Index Tablespace ID       : 2
 Long Tablespace ID        : 2
 Alternate Collating Seq   : 0

 Log Index Build           : NULL
 Table not logged          : 0
 Partitioning type         : 
 Max free space search     : 999
 Offset to partition info  : 1248
 No. of unique constraints : 0
 Table Percent free space  : 0
 Row type id               : -2
 Column id of ref-self col : -2
 Row type schema length    : 0
 Row type schema           :
 Row type name length      : 0
 Row type name             :
 Specific PD offset        : 0
 Append mode               : N
 Delete / Insert counter   : 0
 Generic PD offset         : 0
 Datapart PD offset        : 1264
 Lock size                 : row
 View content properties   : 0000000000
 Volatile                  : 
 Inoperative               : 
 Full Constraint Enforced  : 0
 Query Optimization Option : 0
 Property of table (1)     : 0
 Property of table (2)     : 0
 Number of ADT columns     : 0

 Global Temporary table     : NO
 On commit delete rows
 On rollback delete rows
 MDC                        : NO

 DGTT options              : 0
 Avg Row Compression Ratio : 0.000000
 Percentage of rows compressed : 0.000000
 Avg length of compressed row  : 0
 Avg row size               : 33
 DataJoiner Pd offset      : 0
 Offset directory          : 0
 Dimension Info Offset     : 0
 Number of Column Groups   : 0
 Column Group Stats Offset : 0
 Latest_statsrun Offset    : 2696
 Stats Profile Offset      : 0
 Stats Type                : A

 Bufferpool id for Primary tablespace : 1

 Active Blocks             : 0
 Number of QTB (simulated AST only) : 0
 VALUE COMPRESSION           : NO
 ROW COMPRESSION             : NO

 Generated partition key column altered : NO
 detach source table schema length : 0
 detach source table schema        :
 detach source table length        : 0
 detach source table               :
 Records per page (0 = variable)   : 0
 Protection Granularity            : 
 Security Policy ID                : 0
 Audit Policy ID                   : 0

          COLUMN DESCRIPTION
          ------------------

            
 COLUMN NAME               : TABNAME
 Length of column name     : 7
 Column id                 : 0
 Col type {hex, type}      : 0x0101 ,  VARCHAR
 Col dist. type {hex, type}: 0x0038 ,  VARCHAR
 Column length             :    100
 Blob length               : 100
 Statistic offset          : 272
 Flags                     : 0x20000090
                             - SQLRG_MIXED
                             - SQLRG_NULLIND
 Codepage                  : 1208
 Collation name            : IDENTITY
 Collation ID in hex       : B'00 00 00 02 FF 00 FF FF
 Length of user default    : 0
 Logged                    : 0
 Compact                   : 0
 Datalink Features         : 000000
 Ref. row type desc. offset: 0
 No. unique values in col. : 77
 Average column length     : 23
 Expected Change Rate      : 0.520270
 High2key and Low2key len. : 66
 Avg column length in chars: 18
 Delimiter length          : -1
 Number of Subelements     : -1
 Number of nulls           : 0
 High2key                  : {V_XSDDMX_DL                      }
 High2key in Hex Format    : 565f585344444d585f444c20202020202020202020202020202020202020202020
 Low2key                   : {T_CGDDMX                         }
 Low2key in Hex Format     : 545f434744444d5820202020202020202020202020202020202020202020202020
 Statistic Descriptor      :
  colid                    : 0
  fd offset                : 16
  hd offset                : 416
  nmostfreq                : 10
  mtiles                   : 20
 Histogram Descriptor      : Count   Distcount   Value_len   Value  Hex(value)
                             ---------------------------------------------
                             1     0     18           {T_CGDD            }   545f43474444202020202020202020202020
                             9     0     18           {T_CKD             }   545f434b4420202020202020202020202020
                             17     0     18           {T_DDJHMX          }   545f44444a484d5820202020202020202020
                             24     0     18           {T_FP              }   545f46502020202020202020202020202020
                             32     0     18           {T_JHJG            }   545f4a484a47202020202020202020202020
                             40     0     18           {T_KCCLMXZ_WLXX    }   545f4b43434c4d585a5f574c585820202020
                             48     0     18           {T_RYXX            }   545f52595858202020202020202020202020
                             53     0     18           {T_WLDWXX          }   545f574c4457585820202020202020202020
                             68     0     18           {T_WLDWXX          }   545f574c4457585820202020202020202020
                             71     0     18           {T_WLXX            }   545f574c5858202020202020202020202020
                             79     0     18           {T_YWDJLX          }   545f5957444a4c5820202020202020202020
                             86     0     18           {V_CGJHMX          }   565f43474a484d5820202020202020202020
                             94     0     18           {V_CKDMX_DL        }   565f434b444d585f444c2020202020202020
                             102     0     18           {V_FP              }   565f46502020202020202020202020202020
                             110     0     18           {V_FPMX            }   565f46504d58202020202020202020202020
                             118     0     18           {V_JSD_BK          }   565f4a53445f424b20202020202020202020
                             126     0     18           {V_SBLPDMX         }   565f53424c50444d58202020202020202020
                             133     0     18           {V_WLXX            }   565f574c5858202020202020202020202020
                             141     0     18           {V_XSDDMX          }   565f585344444d5820202020202020202020
                             148     0     18           {V_XSJH            }   565f58534a48202020202020202020202020
 Frequency Descriptor      : Count   Value_len   Value  Hex(value)
                             ---------------------------------
                             15  18            {T_WLDWXX          }   545f574c4457585820202020202020202020
                             8  18            {V_FP              }   565f46502020202020202020202020202020
                             8  18            {V_FPMX            }   565f46504d58202020202020202020202020
                             7  18            {T_CKD             }   545f434b4420202020202020202020202020
                             5  18            {T_FP              }   545f46502020202020202020202020202020
                             5  18            {T_FP_CKD_RKD      }   545f46505f434b445f524b44202020202020
                             4  18            {V_XSDD            }   565f58534444202020202020202020202020
                             4  18            {V_XSDDMX          }   565f585344444d5820202020202020202020
                             4  18            {V_XSDDMX_DL       }   565f585344444d585f444c20202020202020
                             4  18            {V_WLDWXX          }   565f574c4457585820202020202020202020
 Security Label ID         : 0
 

          PARTITIONING KEY DESCRIPTION
          ----------------------------

 Multiple node(TRUE/FALSE) : FALSE
 Node number               : 0
 Partition map id          : 1
 No partition columns      : 0
 Column id's               :

          Data Partitioning DESCRIPTION
          -----------------------------

 Flags                     :
 Number partitions         : 1
 Number partitioning cols  : 0
 MAX Data Partition ID     : 1

 Partitions:
   [0] doid {2, 48} ridDepCount 0 datapartID 0 longTbsp 2 flags 0x0

 data partition ID map:

        0

          LATEST RAN STATISTIC PROFILE
          ----------------------------

            
 Length                                        : 120
 Number of columns to collect statistic        : 1
 Number of columns to collect dist. statistic  : 1
 Number of column group to collect statistic   : 0
 Number of index to collect statistic          : 0
 Sampling percentage                           : 0.000000
 Throttle level (util_impact_priority)         : 0
 Default number of frequent values             : 10
 Default number of quantiles                   : 20
 Single node option (TRUE/FALSE)               : TRUE
 Allow access option (TRUE/FALSE)              : TRUE
 Number of nodes                               : 1
 Offset to column list                         : 104
 Offset to column dist. list                   : 112
 Offset to column group list                   : 0
 Offset to index list                          : 0

 Distribution stats on all columns             : TRUE
 Sampled detailed index stats on all indexes   : TRUE

 Per node cardinality :
    Node number      Node card
     0                148

 Column List :
    Column Id        Like Stats (YES/NO)
     0                NO

 Column with distribution statistic list :
    Column Id        Num_Freqvalues      Num_Quantiles
     0                10                  20     

 

-----------------------------------------------------------------
VIEW PACKED DESCRIPTOR:

No view packed descriptor.
-----------------------------------------------------------------
CONSTRAINTS PACKED DESCRIPTOR:

No constraints packed descriptor.
-----------------------------------------------------------------
REFERENTIAL PACKED DESCRIPTOR:

No referential packed descriptor.
-----------------------------------------------------------------
TRIGGER PACKED DESCRIPTOR:

No trigger packed descriptor.
-----------------------------------------------------------------
SYSTABLES.REMOTE_DESC:

No remote packed descriptor.
-----------------------------------------------------------------
AST PACKED DESCRIPTOR:

No ast packed descriptor.
=====

 

注意：这个只能在server断执行。

个人感觉这个还是有点用的，尤其是想全面了解一个表的时候 。