Menu

SAP Table DB2CCHOUR

List of TS/IXS needing utility treatment (DSNACCOR Hourly)

The table DB2CCHOUR (List of TS/IXS needing utility treatment (DSNACCOR Hourly)) is a standard table in SAP ERP. It belongs to the package STU2.

Technical Information

Table DB2CCHOUR
Short Text List of TS/IXS needing utility treatment (DSNACCOR Hourly)
Package STU2
Table Type Transparent Table

Fields for Table DB2CCHOUR

Field Name Key Description Data Element Type Length Check Table
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
FCUPDPGS Full/Inc. Copy: Updated pages in percent of preformatted pag DB2CCUPDPG INT4 10
FCCHGPCT Full/Inc. Copy: Changed rows in percent DB2CCCCHGS INT4 10
FCDAYSCOPY Full Copy: Number of days since last COPY DB2CCCDAYS INT4 10
FCINDEXSIZ Full Copy: Minimum size of index in pages (NACTIVE) DB2CCISIZE INT4 10
REORGTIME Timestamp of last REORG DB2CCOTIME CHAR 26
RTINSDELUP REORG TS/IX: Changed rows in percent DB2CCRCHGS INT4 10
RTUNCLUST REORG TS: Unclustered inserts in percent DB2CCUNCLU INT4 10
RTLOBPCT REORG TS: Disorganized LOBs in percent DB2CCLOB INT4 10
RTMASSDEL REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) DB2CCRMASS INT4 10
RTINDREF REORG TS: Indirect references (overflow records) in percent DB2CCIND INT4 10
RIINSDEL REORG TS/IX: Changed rows in percent DB2CCRCHGS INT4 10
RIAPPINS REORG Index: Appended rows (with greater key) in percent DB2CCAPP INT4 10
RIPSEUDODE REORG Index: Pseudo deletes in percent DB2CCPSEUD INT4 10
RIMASSDEL REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) DB2CCRMASS INT4 10
RILEAFLIM REORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent DB2CCLEAF INT4 10
RINUMLEVEL REORG Index: Change to number of index tree levels absolute DB2CCLEVEL INT4 10
RUNSTATSTI Timestamp of last RUNSTATS DB2CCSTIME CHAR 26
STINSDELP RUNSTATS TS/IX: Changed rows in percent DB2CCSCHGS INT4 10
STINSDELA RUN.:Changed rows (insert, delete or update) absolute number DB2CCCHGA FLTP 16
STMASSDEL RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) DB2CCSMASS INT4 10
SIINSDELP RUNSTATS TS/IX: Changed rows in percent DB2CCSCHGS INT4 10
SIINSDELA RUN.:Changed rows (insert, delete or update) absolute number DB2CCCHGA FLTP 16
SIMASSDEL RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) DB2CCSMASS INT4 10
EXTENT_NO Number of physical extents in TS, IS or partition DB2CCEXTNO INT2 5
RTINSDELUPABS REO.:Changed rows (insert, delete or update) absolute number DB2CCRCHGA INT4 10
RTACTIVEPAGES REORG TS/IX: Number of active pages DB2CCRROWS INT4 10