DB2CCDAILYX is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DB2CCDAILYX in SAP.
- Table description : List of TS/IXS needing utility treatment (DSNACCOX Daily)
- Module : BC-DB-DB2
- Parent Module : BC
- Package : STU2
- Software Component : SAP_BASIS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP DB2CCDAILYX Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| DATE_ANA | Date of the last check | DB2BCKDATE | DATUM |
| TIME_ANA | Time of the last check | DB2BCKTIME | TIME |
| DBNAM | Database name | DB2DBNAME | D2DBNAME |
| TSNAM | Name of the tablespace | DB2TSNAME | CHAR8 |
| TSPART | Partition number | DB2PARTNRS | DB2SINT |
| CREATOR | DB2 creator name | DB2CREATOR | CHAR8 |
| IXNAME | DB2 long index name | DB2IDXNAML | |
| .INCLUDE | Output List of Table-/Indexspace of DB2 SP DSNACCOX | ||
| DBNAME | Database name | DB2DBNAME | D2DBNAME |
| TSNAME | Name of the tablespace | DB2TSNAME | CHAR8 |
| PARTI | Data set number or partition number | DB2CCPART | DB2PART |
| INSTANCE | |||
| CLONE | |||
| OBJTYPE | DB2 object type: TS for tablespace, IX for indexspace | DB2CCOBJT | CHAR2 |
| INDEXSPACE | DB2 indexspace name | DB2ISNAME | CHAR8 |
| IDXCREATOR | DB2 creator name | DB2CREATOR | CHAR8 |
| OBJSTATUS | DB2 object status: NULL, restricted states or orphaned | DB2CCOBJS | CHAR36 |
| COPYREC | COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both) | DB2CCCPYR | CHAR3 |
| RUNSTREC | RUNSTATS Recommendation: YES or NO | DB2CCSREC | CHAR3 |
| EXTENTS | Extentlimit was exceeded: YES or NO | DB2CCEXTL | CHAR3 |
| REORGREC | REORG Recommendation: YES or NO | DB2CCOREC | CHAR3 |
| EXCTABLE | Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab) | DB2CCEXCL | CHAR40 |
| ASSOCTS | Associated tablespace for indexspace | DB2CCASSTS | DB2TSNAME |
| COPYTIME | Timestamp of last full image COPY | DB2CCCTIME | DB2TMSTMP |
| LOADREPLTI | Timestamp of last LOAD REPLACE | DB2CCLTIME | DB2TMSTMP |
| REBUILDTIM | Timestamp of last REBUILD INDEX | DB2CCRTIME | DB2TMSTMP |
| FCUPDPGS | |||
| FCUPDPGSABS | |||
| FCCHGPCT | |||
| FCDAYSCOPY | Full Copy: Number of days since last COPY | DB2CCCDAYS | |
| FCINDEXSIZ | Full Copy: Minimum size of index in pages (NACTIVE) | DB2CCISIZE | |
| REORGTIME | Timestamp of last REORG | DB2CCOTIME | DB2TMSTMP |
| RTINSPCT | |||
| RTINSABS | |||
| RTDELPCT | |||
| RTDELABS | |||
| RTUNCLUST | |||
| RTLOBPCT | |||
| RTDATASPRAT | |||
| RTMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCRMASS | |
| RTINDREF | |||
| RIINSPCT | |||
| RIINSABS | |||
| RIDELPCT | |||
| RIDELABS | |||
| RIAPPINS | |||
| RIPSEUDODE | |||
| RIMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCRMASS | |
| RILEAFLIM | |||
| RINUMLEVEL | REORG Index: Change to number of index tree levels absolute | DB2CCLEVEL | |
| RUNSTATSTI | Timestamp of last RUNSTATS | DB2CCSTIME | DB2TMSTMP |
| STINSDELP | |||
| STINSDELA | |||
| STMASSDEL | RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCSMASS | |
| SIINSDELP | |||
| SIINSDELA | |||
| SIMASSDEL | RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCSMASS | |
| EXTENT_NO | Number of physical extents in TS, IS or partition | DB2CCEXTNO | INT2 |
DB2CCDAILYX related tables
| Table | Note |
|---|---|
| DB2CCDAILYX | List of TS/IXS needing utility treatment (DSNACCOX Daily) |
| DB2CCDAILY | List of TS/IXS needing utility treatment (DSNACCOR Daily) |
| DB2CCHOUR | List of TS/IXS needing utility treatment (DSNACCOR Hourly) |
| DB2CCACCOX | Parameters stored procedure DSNACCOX |
| SPROXXSLQ | Queue with objects needing generation of stylesheets |
| BGPROT | DB utility log |
| DB2CCMO_OBJERR | DSNACCMO: History of failed utility executions |
| DBAML | Job / Job Step Utility View |
| DSWP_SYSTEM_REPL | Utility Table for Analysis Method Error Analysis |
| EKONG | Franchise Contributions by Customer/Utility Co. |
| ESALES_PRODUCTT | Utility Product Texts |
| ESALES_UTILPROD | Utility products |
| ISU_CUSTESERVICE | Control Parameter for Utility Customer E-Services |
| SLS_UTIL | PAW - utility table |
| TE187 | Utility Company |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP