DB2CCDAILYX - List of TS/IXS needing utility treatment (DSNACCOX Daily)
List of TS/IXS needing utility treatment (DSNACCOX Daily) information is stored in SAP table DB2CCDAILYX.
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
Fields for table DB2CCDAILYX
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| DATE_ANA | Date of the last check | X | DB2BCKDATE | DATS | 8 | |
| TIME_ANA | Time of the last check | X | DB2BCKTIME | TIMS | 6 | |
| DBNAM | Database name | X | DB2DBNAME | CHAR | 8 | |
| TSNAM | Name of the tablespace | X | DB2TSNAME | CHAR | 8 | |
| TSPART | Partition number | X | DB2PARTNRS | INT2 | 2 | |
| CREATOR | DB2 creator name | DB2CREATOR | CHAR | 8 | ||
| IXNAME | DB2 long index name | DB2IDXNAML | CHAR | 128 | ||
| .INCLUDE | DB2CCOUTX | 0 | ||||
| DBNAME | Database name | DB2DBNAME | CHAR | 8 | ||
| TSNAME | Name of the tablespace | DB2TSNAME | CHAR | 8 | ||
| PARTI | Data set number or partition number | DB2CCPART | INT2 | 2 | ||
| INSTANCE | Indicates if the object is associated with a data set instan | INT2 | 2 | |||
| CLONE | 'Y' or 'N', 'Y' indicates a cloned object. | CHAR | 1 | |||
| OBJTYPE | DB2 object type: TS for tablespace, IX for indexspace | DB2CCOBJT | CHAR | 2 | ||
| INDEXSPACE | DB2 indexspace name | DB2ISNAME | CHAR | 8 | ||
| IDXCREATOR | DB2 creator name | DB2CREATOR | CHAR | 8 | ||
| OBJSTATUS | DB2 object status: NULL, restricted states or orphaned | DB2CCOBJS | CHAR | 36 | ||
| COPYREC | COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both) | DB2CCCPYR | CHAR | 3 | ||
| RUNSTREC | RUNSTATS Recommendation: YES or NO | DB2CCSREC | CHAR | 3 | ||
| EXTENTS | Extentlimit was exceeded: YES or NO | DB2CCEXTL | CHAR | 3 | ||
| REORGREC | REORG Recommendation: YES or NO | DB2CCOREC | CHAR | 3 | ||
| EXCTABLE | Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab) | DB2CCEXCL | CHAR | 40 | ||
| ASSOCTS | Associated tablespace for indexspace | DB2CCASSTS | CHAR | 8 | ||
| COPYTIME | Timestamp of last full image COPY | DB2CCCTIME | CHAR | 26 | ||
| LOADREPLTI | Timestamp of last LOAD REPLACE | DB2CCLTIME | CHAR | 26 | ||
| REBUILDTIM | Timestamp of last REBUILD INDEX | DB2CCRTIME | CHAR | 26 | ||
| FCUPDPGS | Full Copy: Updated pages in percent | FLTP | 8 | |||
| FCUPDPGSABS | Full Copy: Updated pages absolut | INT4 | 4 | |||
| FCCHGPCT | Full Copy: Changed rows in percent | FLTP | 8 | |||
| FCDAYSCOPY | Full Copy: Number of days since last COPY | DB2CCCDAYS | INT4 | 4 | ||
| FCINDEXSIZ | Full Copy: Minimum size of index in pages (NACTIVE) | DB2CCISIZE | INT4 | 4 | ||
| REORGTIME | Timestamp of last REORG | DB2CCOTIME | CHAR | 26 | ||
| RTINSPCT | REORG TS: Inserted rows in percent | FLTP | 8 | |||
| RTINSABS | REORG TS: Inserted rows absolut | INT4 | 4 | |||
| RTDELPCT | REORG TS:Deleted rows in percent | FLTP | 8 | |||
| RTDELABS | REORG TS:Deleted rows absolut | INT4 | 4 | |||
| RTUNCLUST | REORG TS: Unclustered inserts in percent | FLTP | 8 | |||
| RTLOBPCT | REORG TS: Disorganized LOBs in percent | FLTP | 8 | |||
| RTDATASPRAT | REORG TS: Ration between RTS SPACE and RTS DATASIZE | FLTP | 8 | |||
| RTMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCRMASS | INT4 | 4 | ||
| RTINDREF | REORG TS: Indirect references (overflow records) in percent | FLTP | 8 | |||
| RIINSPCT | REORG IX: Inserted rows in percent | FLTP | 8 | |||
| RIINSABS | REORG IX: Inserted rows absolut | INT4 | 4 | |||
| RIDELPCT | REORG IX: Deleted rows in percent | FLTP | 8 | |||
| RIDELABS | REORG IX: Deleted rows absolut | INT4 | 4 | |||
| RIAPPINS | REORG Index: Appended rows (with greater key) in percent | FLTP | 8 | |||
| RIPSEUDODE | REORG Index: Pseudo deletes in percent | FLTP | 8 | |||
| RIMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCRMASS | INT4 | 4 | ||
| RILEAFLIM | REORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent | FLTP | 8 | |||
| RINUMLEVEL | REORG Index: Change to number of index tree levels absolute | DB2CCLEVEL | INT4 | 4 | ||
| RUNSTATSTI | Timestamp of last RUNSTATS | DB2CCSTIME | CHAR | 26 | ||
| STINSDELP | RUNSTATS TS/IX: Changed rows in percent | FLTP | 8 | |||
| STINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | INT4 | 4 | |||
| STMASSDEL | RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCSMASS | INT4 | 4 | ||
| SIINSDELP | RUNSTATS TS/IX: Changed rows in percent | FLTP | 8 | |||
| SIINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | INT4 | 4 | |||
| SIMASSDEL | RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCSMASS | INT4 | 4 | ||
| EXTENT_NO | Number of physical extents in TS, IS or partition | DB2CCEXTNO | INT2 | 2 |