dev .wb
SAP Developer Workbench
The best resource for SAP and ABAP Knowhow

SAP Table DB2IXBACK

List of indexes that need a backup

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

The table DB2IXBACK (List of indexes that need a backup) is a standard table in SAP ERP. It belongs to the package STU2.

Technical Information

Table DB2IXBACK
Short Text List of indexes that need a backup
Package STU2
Table Type Transparent Table

Fields for Table DB2IXBACK

Field Name Key Description Data Element Type Length Check Table
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
PIECEIZE Maximum size of a data set storage piece in KBytes DB2PIECEI4 INT4 10
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
LEAFDIST 100 * avg number of leaf pages between successive leaf pages DB2LEAFDIS INT4 10
EXTENTS Number of extents of a tablespace DB2EXTENT INT4 10
REASON Reason running utility is recommended DB2REASON CHAR 18