SAP ABAP Table DB2CCOUT (Output List of Table-/Indexspace of DB2 SP DSNACCOR)

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

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	OBJTYPE	☐	DB2CCOBJT	CHAR2	CHAR	2	0	DB2 object type: TS for tablespace, IX for indexspace
5	OBJSTATUS	☐	DB2CCOBJS	CHAR36	CHAR	36	0	DB2 object status: NULL, restricted states or orphaned
6	COPYREC	☐	DB2CCCPYR	CHAR3	CHAR	3	0	COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both)
7	RUNSTREC	☐	DB2CCSREC	CHAR3	CHAR	3	0	RUNSTATS Recommendation: YES or NO
8	EXTENTS	☐	DB2CCEXTL	CHAR3	CHAR	3	0	Extentlimit was exceeded: YES or NO
9	REORGREC	☐	DB2CCOREC	CHAR3	CHAR	3	0	REORG Recommendation: YES or NO
10	EXCTABLE	☐	DB2CCEXCL	CHAR40	CHAR	40	0	Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab)
11	ASSOCTS	☐	DB2CCASSTS	DB2TSNAME	CHAR	8	0	Associated tablespace for indexspace
12	COPYTIME	☐	DB2CCCTIME	DB2TMSTMP	CHAR	26	0	Timestamp of last full image COPY
13	LOADREPLTI	☐	DB2CCLTIME	DB2TMSTMP	CHAR	26	0	Timestamp of last LOAD REPLACE
14	REBUILDTIM	☐	DB2CCRTIME	DB2TMSTMP	CHAR	26	0	Timestamp of last REBUILD INDEX
15	FCUPDPGS	☐	DB2CCUPDPG		INT4	10	0	Full/Inc. Copy: Updated pages in percent of preformatted pag
16	FCCHGPCT	☐	DB2CCCCHGS		INT4	10	0	Full/Inc. Copy: Changed rows in percent
17	FCDAYSCOPY	☐	DB2CCCDAYS		INT4	10	0	Full Copy: Number of days since last COPY
18	FCINDEXSIZ	☐	DB2CCISIZE		INT4	10	0	Full Copy: Minimum size of index in pages (NACTIVE)
19	REORGTIME	☐	DB2CCOTIME	DB2TMSTMP	CHAR	26	0	Timestamp of last REORG
20	RTINSDELUP	☐	DB2CCRCHGS		INT4	10	0	REORG TS/IX: Changed rows in percent
21	RTUNCLUST	☐	DB2CCUNCLU		INT4	10	0	REORG TS: Unclustered inserts in percent
22	RTLOBPCT	☐	DB2CCLOB		INT4	10	0	REORG TS: Disorganized LOBs in percent
23	RTMASSDEL	☐	DB2CCRMASS		INT4	10	0	REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
24	RTINDREF	☐	DB2CCIND		INT4	10	0	REORG TS: Indirect references (overflow records) in percent
25	RIINSDEL	☐	DB2CCRCHGS		INT4	10	0	REORG TS/IX: Changed rows in percent
26	RIAPPINS	☐	DB2CCAPP		INT4	10	0	REORG Index: Appended rows (with greater key) in percent
27	RIPSEUDODE	☐	DB2CCPSEUD		INT4	10	0	REORG Index: Pseudo deletes in percent
28	RIMASSDEL	☐	DB2CCRMASS		INT4	10	0	REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
29	RILEAFLIM	☐	DB2CCLEAF		INT4	10	0	REORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent
30	RINUMLEVEL	☐	DB2CCLEVEL		INT4	10	0	REORG Index: Change to number of index tree levels absolute
31	RUNSTATSTI	☐	DB2CCSTIME	DB2TMSTMP	CHAR	26	0	Timestamp of last RUNSTATS
32	STINSDELP	☐	DB2CCSCHGS		INT4	10	0	RUNSTATS TS/IX: Changed rows in percent
33	STINSDELA	☐	DB2CCCHGA	FLTP	FLTP	16	16	RUN.:Changed rows (insert, delete or update) absolute number
34	STMASSDEL	☐	DB2CCSMASS		INT4	10	0	RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
35	SIINSDELP	☐	DB2CCSCHGS		INT4	10	0	RUNSTATS TS/IX: Changed rows in percent
36	SIINSDELA	☐	DB2CCCHGA	FLTP	FLTP	16	16	RUN.:Changed rows (insert, delete or update) absolute number
37	SIMASSDEL	☐	DB2CCSMASS		INT4	10	0	RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
38	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	620