DB2CCDAILYX SAP (List of TS/IXS needing utility treatment (DSNACCOX Daily)) Table details
Dictionary Type: Table
Description: List of TS/IXS needing utility treatment (DSNACCOX Daily)
Description: List of TS/IXS needing utility treatment (DSNACCOX Daily)
Table field list including key, data, relationships and ABAP select examples
DB2CCDAILYX is a standard SAP Table which is used to store List of TS/IXS needing utility treatment (DSNACCOX Daily) data and is available within R/3 SAP systems depending on the version and release level.
The DB2CCDAILYX table consists of various fields, each holding specific information or linking keys about List of TS/IXS needing utility treatment (DSNACCOX Daily) data available in SAP. These include TIME_ANA (Time of the last check), DBNAM (Database name), TSNAM (Name of the tablespace), TSPART (Partition number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP DB2CCDAILYX table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
DATE_ANA | Date of the last check | DB2BCKDATE | DATS | 8 | DATUM | ||||
TIME_ANA | Time of the last check | DB2BCKTIME | TIMS | 6 | TIME | ||||
DBNAM | Database name | DB2DBNAME | CHAR | 8 | D2DBNAME | ||||
TSNAM | Name of the tablespace | DB2TSNAME | CHAR | 8 | CHAR8 | ||||
TSPART | Partition number | DB2PARTNRS | INT2 | 5 | DB2SINT | ||||
CREATOR | DB2 creator name | DB2CREATOR | CHAR | 8 | CHAR8 | ||||
IXNAME | DB2 long index name | DB2IDXNAML | CHAR | 128 | |||||
DBNAME | Database name | DB2DBNAME | CHAR | 8 | D2DBNAME | ||||
TSNAME | Name of the tablespace | DB2TSNAME | CHAR | 8 | CHAR8 | ||||
PARTI | Data set number or partition number | DB2CCPART | INT2 | 5 | DB2PART | ||||
INSTANCE | Indicates if the object is associated with a data set instan | 0 | |||||||
CLONE | 'Y' or 'N', 'Y' indicates a cloned object. | 0 | |||||||
OBJTYPE | DB2 object type: TS for tablespace, IX for indexspace | DB2CCOBJT | CHAR | 2 | CHAR2 | ||||
INDEXSPACE | DB2 indexspace name | DB2ISNAME | CHAR | 8 | CHAR8 | ||||
IDXCREATOR | DB2 creator name | DB2CREATOR | CHAR | 8 | CHAR8 | ||||
OBJSTATUS | DB2 object status: NULL, restricted states or orphaned | DB2CCOBJS | CHAR | 36 | CHAR36 | ||||
COPYREC | COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both) | DB2CCCPYR | CHAR | 3 | CHAR3 | ||||
RUNSTREC | RUNSTATS Recommendation: YES or NO | DB2CCSREC | CHAR | 3 | CHAR3 | ||||
EXTENTS | Extentlimit was exceeded: YES or NO | DB2CCEXTL | CHAR | 3 | CHAR3 | ||||
REORGREC | REORG Recommendation: YES or NO | DB2CCOREC | CHAR | 3 | CHAR3 | ||||
EXCTABLE | Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab) | DB2CCEXCL | CHAR | 40 | CHAR40 | ||||
ASSOCTS | Associated tablespace for indexspace | DB2CCASSTS | CHAR | 8 | DB2TSNAME | ||||
COPYTIME | Timestamp of last full image COPY | DB2CCCTIME | CHAR | 26 | DB2TMSTMP | ||||
LOADREPLTI | Timestamp of last LOAD REPLACE | DB2CCLTIME | CHAR | 26 | DB2TMSTMP | ||||
REBUILDTIM | Timestamp of last REBUILD INDEX | DB2CCRTIME | CHAR | 26 | DB2TMSTMP | ||||
FCUPDPGS | Full Copy: Updated pages in percent | 0 | |||||||
FCUPDPGSABS | Full Copy: Updated pages absolut | 0 | |||||||
FCCHGPCT | Full Copy: Changed rows in percent | 0 | |||||||
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 | DB2TMSTMP | ||||
RTINSPCT | REORG TS: Inserted rows in percent | 0 | |||||||
RTINSABS | REORG TS: Inserted rows absolut | 0 | |||||||
RTDELPCT | REORG TS:Deleted rows in percent | 0 | |||||||
RTDELABS | REORG TS:Deleted rows absolut | 0 | |||||||
RTUNCLUST | REORG TS: Unclustered inserts in percent | 0 | |||||||
RTLOBPCT | REORG TS: Disorganized LOBs in percent | 0 | |||||||
RTDATASPRAT | REORG TS: Ration between RTS SPACE and RTS DATASIZE | 0 | |||||||
RTMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCRMASS | INT4 | 10 | |||||
RTINDREF | REORG TS: Indirect references (overflow records) in percent | 0 | |||||||
RIINSPCT | REORG IX: Inserted rows in percent | 0 | |||||||
RIINSABS | REORG IX: Inserted rows absolut | 0 | |||||||
RIDELPCT | REORG IX: Deleted rows in percent | 0 | |||||||
RIDELABS | REORG IX: Deleted rows absolut | 0 | |||||||
RIAPPINS | REORG Index: Appended rows (with greater key) in percent | 0 | |||||||
RIPSEUDODE | REORG Index: Pseudo deletes in percent | 0 | |||||||
RIMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCRMASS | INT4 | 10 | |||||
RILEAFLIM | REORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent | 0 | |||||||
RINUMLEVEL | REORG Index: Change to number of index tree levels absolute | DB2CCLEVEL | INT4 | 10 | |||||
RUNSTATSTI | Timestamp of last RUNSTATS | DB2CCSTIME | CHAR | 26 | DB2TMSTMP | ||||
STINSDELP | RUNSTATS TS/IX: Changed rows in percent | 0 | |||||||
STINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | 0 | |||||||
STMASSDEL | RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCSMASS | INT4 | 10 | |||||
SIINSDELP | RUNSTATS TS/IX: Changed rows in percent | 0 | |||||||
SIINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | 0 | |||||||
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 | INT2 |
Key field | Non-key field |
How do I retrieve data from SAP table DB2CCDAILYX using ABAP code
The following ABAP code Example will allow you to do a basic selection on DB2CCDAILYX to SELECT all data from the tableDATA: WA_DB2CCDAILYX TYPE DB2CCDAILYX.
SELECT SINGLE *
FROM DB2CCDAILYX
INTO CORRESPONDING FIELDS OF WA_DB2CCDAILYX
WHERE...
How to access SAP table DB2CCDAILYX
Within an ECC or HANA version of SAP you can also view further information about DB2CCDAILYX and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects