DB2IXBACK

List of indexes that need a backup | #transactional | Component: DB2 for z/OS
Column Name Description
DATE_ANA Date of the last check
TIME_ANA Time of the last check
IXCREA DB2 creator name
IXNAM Name of a DB2 for OS/390 index
IXPART Partition number
Column Name Description
Column Name Description
Column Name Description
DATE_ANA Date of the last check
TIME_ANA Time of the last check
Column Name Description
UNIQUERULE Whether the index is unique Show values
INDEXTYPE Index type Show values
CLUSTERING Whether CLUSTER was specified when the index was created Show values
PGSIZE DB2 for OS/390 page size in KBytes Show values
Column Name Description Domain name
CREATOR DB2 creator name CHAR8
NAME Index name CHAR18
TBCREATOR Authorization id of the owner of the table DB2TBCREAT
TBNAME Name of the table on which the index is defined CHAR18
INDEXSPACE Name of the indexspace that contains the index CHAR8
ERASERULE Datasets are to be erased when dropped DB2ERULE
CLOSERULE Data sets for closure when limit of open data sets reached DB2CRULE
COLCOUNT Number of columns in the table or view DB2SINT
DBID DBID INT2
DBNAME Database name D2DBNAME
BPOOL DB2/390: Buffer pool DB2BUFPOOL
DSETPASS The password for the datasets of the tablespace DB2DPASS
PIECEIZE Maximum size of a data set storage piece in KBytes
COPY Index can be copied CHAR1
PARTITIONS Number of partitions of the tablespace or indexspace DB2PART
PARTNR Partition number DB2SINT
OPERATION Date and time of last RUNSTATS DB2TMSTMP
NDAYS Number of days since last invocation DB2DAYS
LEAFDIST 100 * avg number of leaf pages between successive leaf pages
EXTENTS Number of extents of a tablespace DB2EXTENT
REASON Reason running utility is recommended DB2REASON