SAP ABAP Table DB2CCOUTX (Output List of Table-/Indexspace of DB2 SP DSNACCOX)

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	DB2CCOUTX	Table Relationship Diagram
Short Description	Output List of Table-/Indexspace of DB2 SP DSNACCOX

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	DBNAME	☐	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
2	TSNAME	☐	DB2TSNAME	CHAR8	CHAR	8	0	Name of the tablespace
3	PARTI	☐	DB2CCPART	DB2PART	INT2	5	0	Data set number or partition number
4	INSTANCE	☐			INT2	5	0
5	CLONE	☐			CHAR	1	0
6	OBJTYPE	☐	DB2CCOBJT	CHAR2	CHAR	2	0	DB2 object type: TS for tablespace, IX for indexspace
7	INDEXSPACE	☐	DB2ISNAME	CHAR8	CHAR	8	0	DB2 indexspace name
8	IDXCREATOR	☐	DB2CREATOR	CHAR8	CHAR	8	0	DB2 creator name
9	OBJSTATUS	☐	DB2CCOBJS	CHAR36	CHAR	36	0	DB2 object status: NULL, restricted states or orphaned
10	COPYREC	☐	DB2CCCPYR	CHAR3	CHAR	3	0	COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both)
11	RUNSTREC	☐	DB2CCSREC	CHAR3	CHAR	3	0	RUNSTATS Recommendation: YES or NO
12	EXTENTS	☐	DB2CCEXTL	CHAR3	CHAR	3	0	Extentlimit was exceeded: YES or NO
13	REORGREC	☐	DB2CCOREC	CHAR3	CHAR	3	0	REORG Recommendation: YES or NO
14	EXCTABLE	☐	DB2CCEXCL	CHAR40	CHAR	40	0	Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab)
15	ASSOCTS	☐	DB2CCASSTS	DB2TSNAME	CHAR	8	0	Associated tablespace for indexspace
16	COPYTIME	☐	DB2CCCTIME	DB2TMSTMP	CHAR	26	0	Timestamp of last full image COPY
17	LOADREPLTI	☐	DB2CCLTIME	DB2TMSTMP	CHAR	26	0	Timestamp of last LOAD REPLACE
18	REBUILDTIM	☐	DB2CCRTIME	DB2TMSTMP	CHAR	26	0	Timestamp of last REBUILD INDEX
19	FCUPDPGS	☐			FLTP	16	16
20	FCUPDPGSABS	☐			INT4	10	0
21	FCCHGPCT	☐			FLTP	16	16
22	FCDAYSCOPY	☐	DB2CCCDAYS		INT4	10	0	Full Copy: Number of days since last COPY
23	FCINDEXSIZ	☐	DB2CCISIZE		INT4	10	0	Full Copy: Minimum size of index in pages (NACTIVE)
24	REORGTIME	☐	DB2CCOTIME	DB2TMSTMP	CHAR	26	0	Timestamp of last REORG
25	RTINSPCT	☐			FLTP	16	16
26	RTINSABS	☐			INT4	10	0
27	RTDELPCT	☐			FLTP	16	16
28	RTDELABS	☐			INT4	10	0
29	RTUNCLUST	☐			FLTP	16	16
30	RTLOBPCT	☐			FLTP	16	16
31	RTDATASPRAT	☐			FLTP	16	16
32	RTMASSDEL	☐	DB2CCRMASS		INT4	10	0	REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
33	RTINDREF	☐			FLTP	16	16
34	RIINSPCT	☐			FLTP	16	16
35	RIINSABS	☐			INT4	10	0
36	RIDELPCT	☐			FLTP	16	16
37	RIDELABS	☐			INT4	10	0
38	RIAPPINS	☐			FLTP	16	16
39	RIPSEUDODE	☐			FLTP	16	16
40	RIMASSDEL	☐	DB2CCRMASS		INT4	10	0	REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
41	RILEAFLIM	☐			FLTP	16	16
42	RINUMLEVEL	☐	DB2CCLEVEL		INT4	10	0	REORG Index: Change to number of index tree levels absolute
43	RUNSTATSTI	☐	DB2CCSTIME	DB2TMSTMP	CHAR	26	0	Timestamp of last RUNSTATS
44	STINSDELP	☐			FLTP	16	16
45	STINSDELA	☐			INT4	10	0
46	STMASSDEL	☐	DB2CCSMASS		INT4	10	0	RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
47	SIINSDELP	☐			FLTP	16	16
48	SIINSDELA	☐			INT4	10	0
49	SIMASSDEL	☐	DB2CCSMASS		INT4	10	0	RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
50	EXTENT_NO	☐	DB2CCEXTNO	INT2	INT2	5	0	Number of physical extents in TS, IS or partition

History

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