SAP Table DB2CCOUT
Output List of Table-/Indexspace of DB2 SP DSNACCOR
DB2CCOUT (Output List of Table-/Indexspace of DB2 SP DSNACCOR) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link DB2CCOUT to other SAP tables.
Source: DB2CCOUT (Output List of Table-/Indexspace of DB2 SP DSNACCOR)
DB2CCOUT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| DBNAME | Database name | DB2DBNAME | CHAR | 8 | 0 | |||
| TSNAME | Name of the tablespace | DB2TSNAME | CHAR | 8 | 0 | |||
| PARTI | Data set number or partition number | DB2CCPART | INT2 | 5 | 0 | |||
| OBJTYPE | DB2 object type: TS for tablespace, IX for indexspace | DB2CCOBJT | CHAR | 2 | 0 | |||
| OBJSTATUS | DB2 object status: NULL, restricted states or orphaned | DB2CCOBJS | CHAR | 36 | 0 | |||
| COPYREC | COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both) | DB2CCCPYR | CHAR | 3 | 0 | |||
| RUNSTREC | RUNSTATS Recommendation: YES or NO | DB2CCSREC | CHAR | 3 | 0 | |||
| EXTENTS | Extentlimit was exceeded: YES or NO | DB2CCEXTL | CHAR | 3 | 0 | |||
| REORGREC | REORG Recommendation: YES or NO | DB2CCOREC | CHAR | 3 | 0 | |||
| EXCTABLE | Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab) | DB2CCEXCL | CHAR | 40 | 0 | |||
| ASSOCTS | Associated tablespace for indexspace | DB2CCASSTS | CHAR | 8 | 0 | |||
| COPYTIME | Timestamp of last full image COPY | DB2CCCTIME | CHAR | 26 | 0 | |||
| LOADREPLTI | Timestamp of last LOAD REPLACE | DB2CCLTIME | CHAR | 26 | 0 | |||
| REBUILDTIM | Timestamp of last REBUILD INDEX | DB2CCRTIME | CHAR | 26 | 0 | |||
| FCUPDPGS | Full/Inc. Copy: Updated pages in percent of preformatted pag | DB2CCUPDPG | INT4 | 10 | 0 | |||
| FCCHGPCT | Full/Inc. Copy: Changed rows in percent | DB2CCCCHGS | INT4 | 10 | 0 | |||
| FCDAYSCOPY | Full Copy: Number of days since last COPY | DB2CCCDAYS | INT4 | 10 | 0 | |||
| FCINDEXSIZ | Full Copy: Minimum size of index in pages (NACTIVE) | DB2CCISIZE | INT4 | 10 | 0 | |||
| REORGTIME | Timestamp of last REORG | DB2CCOTIME | CHAR | 26 | 0 | |||
| RTINSDELUP | REORG TS/IX: Changed rows in percent | DB2CCRCHGS | INT4 | 10 | 0 | |||
| RTUNCLUST | REORG TS: Unclustered inserts in percent | DB2CCUNCLU | INT4 | 10 | 0 | |||
| RTLOBPCT | REORG TS: Disorganized LOBs in percent | DB2CCLOB | INT4 | 10 | 0 | |||
| RTMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCRMASS | INT4 | 10 | 0 | |||
| RTINDREF | REORG TS: Indirect references (overflow records) in percent | DB2CCIND | INT4 | 10 | 0 | |||
| RIINSDEL | REORG TS/IX: Changed rows in percent | DB2CCRCHGS | INT4 | 10 | 0 | |||
| RIAPPINS | REORG Index: Appended rows (with greater key) in percent | DB2CCAPP | INT4 | 10 | 0 | |||
| RIPSEUDODE | REORG Index: Pseudo deletes in percent | DB2CCPSEUD | INT4 | 10 | 0 | |||
| RIMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCRMASS | INT4 | 10 | 0 | |||
| RILEAFLIM | REORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent | DB2CCLEAF | INT4 | 10 | 0 | |||
| RINUMLEVEL | REORG Index: Change to number of index tree levels absolute | DB2CCLEVEL | INT4 | 10 | 0 | |||
| RUNSTATSTI | Timestamp of last RUNSTATS | DB2CCSTIME | CHAR | 26 | 0 | |||
| STINSDELP | RUNSTATS TS/IX: Changed rows in percent | DB2CCSCHGS | INT4 | 10 | 0 | |||
| STINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | DB2CCCHGA | FLTP | 16 | 16 | |||
| STMASSDEL | RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCSMASS | INT4 | 10 | 0 | |||
| SIINSDELP | RUNSTATS TS/IX: Changed rows in percent | DB2CCSCHGS | INT4 | 10 | 0 | |||
| SIINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | DB2CCCHGA | FLTP | 16 | 16 | |||
| SIMASSDEL | RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCSMASS | INT4 | 10 | 0 | |||
| EXTENT_NO | Number of physical extents in TS, IS or partition | DB2CCEXTNO | INT2 | 5 | 0 | |||
