The DB2CCHOUR table in SAP ERP or S/4HANA stores List of TS/IXS needing utility treatment (DSNACCOR Hourly) data. There are total 26 fields in DB2CCHOUR table. The List of TS/IXS needing utility treatment (DSNACCOR Hourly) table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DB2CCHOUR table. It is in CCMS for DB2 for OS/390 (STU2) ABAP package and is part of the DB2 for z/OS (BC-DB-DB2) module.
SAP DB2CCHOUR Table Fields
Following is the list of fields that are available in SAP DB2CCHOUR table. The primary key fields of List of TS/IXS needing utility treatment (DSNACCOR Hourly) table in SAP are DATE_ANA (Date of the last check), TIME_ANA (Time of the last check), DBNAM (Database name), TSNAM (Name of the tablespace), TSPART (Partition number), CREATOR (DB2 creator name).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| DATE_ANA | Date of the last check | DB2BCKDATE | DATS (8) | |
| TIME_ANA | Time of the last check | DB2BCKTIME | TIMS (6) | |
| DBNAM | Database name | DB2DBNAME | CHAR (8) | |
| TSNAM | Name of the tablespace | DB2TSNAME | CHAR (8) | |
| TSPART | Partition number | DB2PARTNRS | INT2 (5) | |
| CREATOR | DB2 creator name | DB2CREATOR | CHAR (8) | |
| IXNAME | Name of a DB2 for OS/390 index | DB2IDXNAME | CHAR (18) | |
| DBNAME | Database name | DB2DBNAME | CHAR (8) | |
| TSNAME | Name of the tablespace | DB2TSNAME | CHAR (8) | |
| PARTI | Data set number or partition number | DB2CCPART | INT2 (5) | |
| 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) | |
| REORGTIME | Timestamp of last REORG | DB2CCOTIME | CHAR (26) | |
| RUNSTATSTI | Timestamp of last RUNSTATS | DB2CCSTIME | CHAR (26) | |
| STINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | DB2CCCHGA | FLTP (16) | |
| SIINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | DB2CCCHGA | FLTP (16) | |
| EXTENT_NO | Number of physical extents in TS, IS or partition | DB2CCEXTNO | INT2 (5) |
