Data Element list used by SAP ABAP Table DB2CCDAILY (List of TS/IXS needing utility treatment (DSNACCOR Daily))
SAP ABAP Table DB2CCDAILY (List of TS/IXS needing utility treatment (DSNACCOR Daily)) is using
# Object Type Object Name Object Description Note
     
1 Data Element  DB2BCKDATE Date of the last check
2 Data Element  DB2BCKTIME Time of the last check
3 Data Element  DB2CCAPP REORG Index: Appended rows (with greater key) in percent
4 Data Element  DB2CCASSTS Associated tablespace for indexspace
5 Data Element  DB2CCCCHGS Full/Inc. Copy: Changed rows in percent
6 Data Element  DB2CCCDAYS Full Copy: Number of days since last COPY
7 Data Element  DB2CCCHGA RUN.:Changed rows (insert, delete or update) absolute number
8 Data Element  DB2CCCHGA RUN.:Changed rows (insert, delete or update) absolute number
9 Data Element  DB2CCCPYR COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both)
10 Data Element  DB2CCCTIME Timestamp of last full image COPY
11 Data Element  DB2CCEXCL Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab)
12 Data Element  DB2CCEXTL Extentlimit was exceeded: YES or NO
13 Data Element  DB2CCEXTNO Number of physical extents in TS, IS or partition
14 Data Element  DB2CCIND REORG TS: Indirect references (overflow records) in percent
15 Data Element  DB2CCISIZE Full Copy: Minimum size of index in pages (NACTIVE)
16 Data Element  DB2CCLEAF REORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent
17 Data Element  DB2CCLEVEL REORG Index: Change to number of index tree levels absolute
18 Data Element  DB2CCLOB REORG TS: Disorganized LOBs in percent
19 Data Element  DB2CCLTIME Timestamp of last LOAD REPLACE
20 Data Element  DB2CCOBJS DB2 object status: NULL, restricted states or orphaned
21 Data Element  DB2CCOBJT DB2 object type: TS for tablespace, IX for indexspace
22 Data Element  DB2CCOREC REORG Recommendation: YES or NO
23 Data Element  DB2CCOTIME Timestamp of last REORG
24 Data Element  DB2CCPART Data set number or partition number
25 Data Element  DB2CCPSEUD REORG Index: Pseudo deletes in percent
26 Data Element  DB2CCRCHGA REO.:Changed rows (insert, delete or update) absolute number
27 Data Element  DB2CCRCHGS REORG TS/IX: Changed rows in percent
28 Data Element  DB2CCRCHGS REORG TS/IX: Changed rows in percent
29 Data Element  DB2CCRMASS REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
30 Data Element  DB2CCRMASS REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
31 Data Element  DB2CCRROWS REORG TS/IX: Number of active pages
32 Data Element  DB2CCRTIME Timestamp of last REBUILD INDEX
33 Data Element  DB2CCSCHGS RUNSTATS TS/IX: Changed rows in percent
34 Data Element  DB2CCSCHGS RUNSTATS TS/IX: Changed rows in percent
35 Data Element  DB2CCSMASS RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
36 Data Element  DB2CCSMASS RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.)
37 Data Element  DB2CCSREC RUNSTATS Recommendation: YES or NO
38 Data Element  DB2CCSTIME Timestamp of last RUNSTATS
39 Data Element  DB2CCUNCLU REORG TS: Unclustered inserts in percent
40 Data Element  DB2CCUPDPG Full/Inc. Copy: Updated pages in percent of preformatted pag
41 Data Element  DB2CREATOR DB2 creator name
42 Data Element  DB2DBNAME Database name
43 Data Element  DB2DBNAME Database name
44 Data Element  DB2IDXNAME Name of a DB2 for OS/390 index
45 Data Element  DB2PARTNRS Partition number
46 Data Element  DB2TSNAME Name of the tablespace
47 Data Element  DB2TSNAME Name of the tablespace