DB2CCHOUR - List of TS/IXS needing utility treatment (DSNACCOR Hourly)
List of TS/IXS needing utility treatment (DSNACCOR Hourly) information is stored in SAP table DB2CCHOUR.
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 DB2CCHOUR
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 | X | DB2CREATOR | CHAR | 8 | |
| IXNAME | Name of a DB2 for OS/390 index | DB2IDXNAME | CHAR | 18 | ||
| .INCLUDE | DB2CCOUT | 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 | ||
| OBJTYPE | DB2 object type: TS for tablespace, IX for indexspace | DB2CCOBJT | CHAR | 2 | ||
| 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/Inc. Copy: Updated pages in percent of preformatted pag | DB2CCUPDPG | INT4 | 4 | ||
| FCCHGPCT | Full/Inc. Copy: Changed rows in percent | DB2CCCCHGS | INT4 | 4 | ||
| 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 | ||
| RTINSDELUP | REORG TS/IX: Changed rows in percent | DB2CCRCHGS | INT4 | 4 | ||
| RTUNCLUST | REORG TS: Unclustered inserts in percent | DB2CCUNCLU | INT4 | 4 | ||
| RTLOBPCT | REORG TS: Disorganized LOBs in percent | DB2CCLOB | INT4 | 4 | ||
| RTMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCRMASS | INT4 | 4 | ||
| RTINDREF | REORG TS: Indirect references (overflow records) in percent | DB2CCIND | INT4 | 4 | ||
| RIINSDEL | REORG TS/IX: Changed rows in percent | DB2CCRCHGS | INT4 | 4 | ||
| RIAPPINS | REORG Index: Appended rows (with greater key) in percent | DB2CCAPP | INT4 | 4 | ||
| RIPSEUDODE | REORG Index: Pseudo deletes in percent | DB2CCPSEUD | INT4 | 4 | ||
| RIMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCRMASS | INT4 | 4 | ||
| RILEAFLIM | REORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent | DB2CCLEAF | INT4 | 4 | ||
| 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 | DB2CCSCHGS | INT4 | 4 | ||
| STINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | DB2CCCHGA | FLTP | 8 | ||
| STMASSDEL | RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCSMASS | INT4 | 4 | ||
| SIINSDELP | RUNSTATS TS/IX: Changed rows in percent | DB2CCSCHGS | INT4 | 4 | ||
| SIINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | DB2CCCHGA | FLTP | 8 | ||
| 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 | ||
| RTINSDELUPABS | REO.:Changed rows (insert, delete or update) absolute number | DB2CCRCHGA | INT4 | 4 | ||
| RTACTIVEPAGES | REORG TS/IX: Number of active pages | DB2CCRROWS | INT4 | 4 |