SAP ABAP Table DB2CCDAILYX (List of TS/IXS needing utility treatment (DSNACCOX Daily))

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	DB2CCDAILYX	Table Relationship Diagram
Short Description	List of TS/IXS needing utility treatment (DSNACCOX Daily)

Delivery and Maintenance

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