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

History

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