SAP ABAP Table DB2CCOUTIX (Output List of index of CC/390 Stored Procedures)

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	INTTAB	Structure
Structure	DB2CCOUTIX	Table Relationship Diagram
Short Description	Output List of index of CC/390 Stored Procedures

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

History

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