DB2IXBACK - List of indexes that need a backup
List of indexes that need a backup information is stored in SAP table DB2IXBACK.
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
Fields for table DB2IXBACK
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| DATE_ANA | Date of the last check | X | DB2BCKDATE | DATS | 8 | |
| TIME_ANA | Time of the last check | X | DB2BCKTIME | TIMS | 6 | |
| IXCREA | DB2 creator name | X | DB2CREATOR | CHAR | 8 | |
| IXNAM | Name of a DB2 for OS/390 index | X | DB2IDXNAME | CHAR | 18 | |
| IXPART | Partition number | X | DB2PARTNRS | INT2 | 2 | |
| .INCLUDE | DB2CCOUTIX | 0 | ||||
| CREATOR | DB2 creator name | DB2CREATOR | CHAR | 8 | ||
| NAME | Index name | DB2INXNAME | CHAR | 18 | ||
| TBCREATOR | Authorization id of the owner of the table | DB2TBCREAT | CHAR | 8 | ||
| TBNAME | Name of the table on which the index is defined | DB2TBNAME | CHAR | 18 | ||
| UNIQUERULE | Whether the index is unique | DB2UNIQUE | CHAR | 1 | ||
| INDEXTYPE | Index type | DB2IXTYPE | CHAR | 1 | ||
| INDEXSPACE | Name of the indexspace that contains the index | DB2IXSPACE | CHAR | 8 | ||
| CLUSTERING | Whether CLUSTER was specified when the index was created | DB2CLUSTER | CHAR | 1 | ||
| ERASERULE | Datasets are to be erased when dropped | DB2ERULE | CHAR | 1 | ||
| CLOSERULE | Data sets for closure when limit of open data sets reached | DB2CRULE | CHAR | 1 | ||
| COLCOUNT | Number of columns in the table or view | DB2COLCNT | INT2 | 2 | ||
| DBID | DBID | DB2DBID | INT2 | 2 | ||
| DBNAME | Database name | DB2DBNAME | CHAR | 8 | ||
| BPOOL | DB2/390: Buffer pool | DB2BUFPOOL | CHAR | 8 | ||
| PGSIZE | DB2 for OS/390 page size in KBytes | DB2PGSIZE | INT2 | 2 | ||
| DSETPASS | The password for the datasets of the tablespace | DB2DPASS | CHAR | 8 | ||
| PIECEIZE | Maximum size of a data set storage piece in KBytes | DB2PIECEI4 | INT4 | 4 | ||
| COPY | Index can be copied | DB2COPY | CHAR | 1 | ||
| PARTITIONS | Number of partitions of the tablespace or indexspace | DB2PART | INT2 | 2 | ||
| PARTNR | Partition number | DB2PARTNRS | INT2 | 2 | ||
| OPERATION | Date and time of last RUNSTATS | DB2STATSTM | CHAR | 26 | ||
| NDAYS | Number of days since last invocation | DB2DAYS | INT4 | 4 | ||
| LEAFDIST | 100 * avg number of leaf pages between successive leaf pages | DB2LEAFDIS | INT4 | 4 | ||
| EXTENTS | Number of extents of a tablespace | DB2EXTENT | INT4 | 4 | ||
| REASON | Reason running utility is recommended | DB2REASON | CHAR | 18 |