Table Report

Legend
NameDescription
CARDFTotal number of rows in the table.
COLCARDFEstimated number of distinct values in the column.
Cluster FactorThe data clustering factor of the index, represented as a ratio between 0 and 1. This value is -1 if the clustering factor is unavailable, or if the cluster ratio value is shown instead.
Cluster RatioDegree of data clustering of the index.
Column GroupColumn group.
Extent SizeNumber of pages of table data that will be written to a container before data will be written to the next container.
Index NameIndex name.
Key Column NameKey column name.
MCARDFEstimated number of distinct values for the multi-column group.
NLEAFNumber of active leaf pages in the table space.
NLEVELNumber of levels in the index tree.
NPAGESFTotal number of pages on which rows of the table appear.
Page SizeSize of a page in the table space in kilobytes.
Partition GroupDatabase partition group range.
Prefetch SizeNumber of pages to be read when prefetching is performed; set to -1 when automatic prefetch size is enabled.
Table NameTable name.
Table SpaceTable space name.
Unique RuleUnique Rule.



Table SpacePage SizeExtent SizePrefetch SizePartition Group      
USERSPACE18192 32-1IBMDEFAULTGROUP      
  Table NameCARDFNPAGESF      
  SARAVIND.EMPLOYEE421      
  Index NameCluster FactorUnique RuleNLEAFNLEVELCluster RatioKey Column NameCOLCARDFMCARDF
  SARAVIND.PK_EMPLOYEE-1.0P11100.0EMPNO4242
  SARAVIND.XEMP2-1.0D11100.0WORKDEPT88
  Column GroupMCARDF       
           
Table SpacePage SizeExtent SizePrefetch SizePartition Group      
USERSPACE18192 32-1IBMDEFAULTGROUP      
  Table NameCARDFNPAGESF      
  SARAVIND.DEPARTMENT141      
  Index NameCluster FactorUnique RuleNLEAFNLEVELCluster RatioKey Column NameCOLCARDFMCARDF
  DB2ADMIN.IDX904022138360000-1.0D-1-1-1.0LOCATION1-1
        DEPTNO14-1
  SARAVIND.PK_DEPARTMENT-1.0P11100.0DEPTNO1414
  SARAVIND.XDEPT2-1.0D11100.0MGRNO99
  SARAVIND.XDEPT3-1.0D11100.0ADMRDEPT33
  Column GroupMCARDF       
           
Table SpacePage SizeExtent SizePrefetch SizePartition Group      
USERSPACE18192 32-1IBMDEFAULTGROUP      
  Table NameCARDFNPAGESF      
  SARAVIND.PROJECT201      
  Index NameCluster FactorUnique RuleNLEAFNLEVELCluster RatioKey Column NameCOLCARDFMCARDF
  DB2ADMIN.IDX904022138410000-1.0D-1-1-1.0DEPTNO8-1
        RESPEMP17-1
        PROJNAME20-1
        PROJNO20-1
        MAJPROJ8-1
  SARAVIND.PK_PROJECT-1.0P11100.0PROJNO2020
  SARAVIND.XPROJ2-1.0D11100.0RESPEMP1717
  Column GroupMCARDF       
           
Table SpacePage SizeExtent SizePrefetch SizePartition Group      
SYSCATSPACE8192 4-1IBMCATGROUP      
  Table NameCARDFNPAGESF      
  SARAVIND.DEPT-1-1      
  Index NameCluster FactorUnique RuleNLEAFNLEVELCluster RatioKey Column NameCOLCARDFMCARDF
  Column GroupMCARDF