SAP ABAP Table DB2IXBACK (List of indexes that need a backup)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DB2IXBACK	Table Relationship Diagram
Short Description	List of indexes that need a backup

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DATE_ANA	☑	DB2BCKDATE	DATUM	DATS	8	0	Date of the last check
2	TIME_ANA	☑	DB2BCKTIME	TIME	TIMS	6	0	Time of the last check
3	IXCREA	☑	DB2CREATOR	CHAR8	CHAR	8	0	DB2 creator name
4	IXNAM	☑	DB2IDXNAME	CHAR18	CHAR	18	0	Name of a DB2 for OS/390 index
5	IXPART	☑	DB2PARTNRS	DB2SINT	INT2	5	0	Partition number
6	.INCLUDE	☐				0	0	Output List of index of CC/390 Stored Procedures
7	CREATOR	☐	DB2CREATOR	CHAR8	CHAR	8	0	DB2 creator name
8	NAME	☐	DB2INXNAME	CHAR18	CHAR	18	0	Index name
9	TBCREATOR	☐	DB2TBCREAT	DB2TBCREAT	CHAR	8	0	Authorization id of the owner of the table
10	TBNAME	☐	DB2TBNAME	CHAR18	CHAR	18	0	Name of the table on which the index is defined
11	UNIQUERULE	☐	DB2UNIQUE	DB2UNIQUE	CHAR	1	0	Whether the index is unique
12	INDEXTYPE	☐	DB2IXTYPE	DB2IXTYPE	CHAR	1	0	Index type
13	INDEXSPACE	☐	DB2IXSPACE	CHAR8	CHAR	8	0	Name of the indexspace that contains the index
14	CLUSTERING	☐	DB2CLUSTER	DB2YNFLAG	CHAR	1	0	Whether CLUSTER was specified when the index was created
15	ERASERULE	☐	DB2ERULE	DB2ERULE	CHAR	1	0	Datasets are to be erased when dropped
16	CLOSERULE	☐	DB2CRULE	DB2CRULE	CHAR	1	0	Data sets for closure when limit of open data sets reached
17	COLCOUNT	☐	DB2COLCNT	DB2SINT	INT2	5	0	Number of columns in the table or view
18	DBID	☐	DB2DBID	INT2	INT2	5	0	DBID
19	DBNAME	☐	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
20	BPOOL	☐	DB2BUFPOOL	DB2BUFPOOL	CHAR	8	0	DB2/390: Buffer pool
21	PGSIZE	☐	DB2PGSIZE	DB2PGSIZE	INT2	5	0	DB2 for OS/390 page size in KBytes
22	DSETPASS	☐	DB2DPASS	DB2DPASS	CHAR	8	0	The password for the datasets of the tablespace
23	PIECEIZE	☐	DB2PIECEI4		INT4	10	0	Maximum size of a data set storage piece in KBytes
24	COPY	☐	DB2COPY	CHAR1	CHAR	1	0	Index can be copied
25	PARTITIONS	☐	DB2PART	DB2PART	INT2	5	0	Number of partitions of the tablespace or indexspace
26	PARTNR	☐	DB2PARTNRS	DB2SINT	INT2	5	0	Partition number
27	OPERATION	☐	DB2STATSTM	DB2TMSTMP	CHAR	26	0	Date and time of last RUNSTATS
28	NDAYS	☐	DB2DAYS	DB2DAYS	INT4	10	0	Number of days since last invocation
29	LEAFDIST	☐	DB2LEAFDIS		INT4	10	0	100 * avg number of leaf pages between successive leaf pages
30	EXTENTS	☐	DB2EXTENT	DB2EXTENT	INT4	10	0	Number of extents of a tablespace
31	REASON	☐	DB2REASON	DB2REASON	CHAR	18	0	Reason running utility is recommended

History

Last changed by/on	SAP	20130604
SAP Release Created in	732