The DB2IXBACK table in SAP ERP or S/4HANA stores List of indexes that need a backup data. There are total 28 fields in DB2IXBACK table. The List of indexes that need a backup table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DB2IXBACK table. It is in CCMS for DB2 for OS/390 (STU2) ABAP package and is part of the DB2 for z/OS (BC-DB-DB2) module.
SAP DB2IXBACK Table Fields
Following is the list of fields that are available in SAP DB2IXBACK table. The primary key fields of List of indexes that need a backup table in SAP are 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).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| DATE_ANA | Date of the last check | DB2BCKDATE | DATS (8) | |
| TIME_ANA | Time of the last check | DB2BCKTIME | TIMS (6) | |
| IXCREA | DB2 creator name | DB2CREATOR | CHAR (8) | |
| IXNAM | Name of a DB2 for OS/390 index | DB2IDXNAME | CHAR (18) | |
| IXPART | Partition number | DB2PARTNRS | INT2 (5) | |
| 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 (5) | |
| DBID | DBID | DB2DBID | INT2 (5) | |
| 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 (5) | |
| DSETPASS | The password for the datasets of the tablespace | DB2DPASS | CHAR (8) | |
| COPY | Index can be copied | DB2COPY | CHAR (1) | |
| PARTITIONS | Number of partitions of the tablespace or indexspace | DB2PART | INT2 (5) | |
| PARTNR | Partition number | DB2PARTNRS | INT2 (5) | |
| OPERATION | Date and time of last RUNSTATS | DB2STATSTM | CHAR (26) | |
| NDAYS | Number of days since last invocation | DB2DAYS | INT4 (10) | |
| EXTENTS | Number of extents of a tablespace | DB2EXTENT | INT4 (10) | |
| REASON | Reason running utility is recommended | DB2REASON | CHAR (18) |
