SAP Table DB2IXBACK

List of indexes that need a backup

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