SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

DB2CCDAILY Table in SAP | List of TS/IXS needing utility treatment (DSNACCOR Daily) Table & Fields List

DB2CCDAILY is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DB2CCDAILY in SAP.

  • Table description : List of TS/IXS needing utility treatment (DSNACCOR Daily)
  • Module : BC-DB-DB2
  • Parent Module : BC
  • Package : STU2
  • Software Component : SAP_BASIS
DB2CCDAILY table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

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 DB2CCDAILY Table Fields structure

FieldNoteData ElementDomain
DATE_ANADate of the last checkDB2BCKDATEDATUM
TIME_ANATime of the last checkDB2BCKTIMETIME
DBNAMDatabase nameDB2DBNAMED2DBNAME
TSNAMName of the tablespaceDB2TSNAMECHAR8
TSPARTPartition numberDB2PARTNRSDB2SINT
CREATORDB2 creator nameDB2CREATORCHAR8
IXNAMEName of a DB2 for OS/390 indexDB2IDXNAMECHAR18
.INCLUDEOutput List of Table-/Indexspace of DB2 SP DSNACCOR    
DBNAMEDatabase nameDB2DBNAMED2DBNAME
TSNAMEName of the tablespaceDB2TSNAMECHAR8
PARTIData set number or partition numberDB2CCPARTDB2PART
OBJTYPEDB2 object type: TS for tablespace, IX for indexspaceDB2CCOBJTCHAR2
OBJSTATUSDB2 object status: NULL, restricted states or orphanedDB2CCOBJSCHAR36
COPYRECCOPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both)DB2CCCPYRCHAR3
RUNSTRECRUNSTATS Recommendation: YES or NODB2CCSRECCHAR3
EXTENTSExtentlimit was exceeded: YES or NODB2CCEXTLCHAR3
REORGRECREORG Recommendation: YES or NODB2CCORECCHAR3
EXCTABLEDefined in exceptiontable: YES, NO, QUERY or NULL(no exctab)DB2CCEXCLCHAR40
ASSOCTSAssociated tablespace for indexspaceDB2CCASSTSDB2TSNAME
COPYTIMETimestamp of last full image COPYDB2CCCTIMEDB2TMSTMP
LOADREPLTITimestamp of last LOAD REPLACEDB2CCLTIMEDB2TMSTMP
REBUILDTIMTimestamp of last REBUILD INDEXDB2CCRTIMEDB2TMSTMP
FCUPDPGSFull/Inc. Copy: Updated pages in percent of preformatted pagDB2CCUPDPG  
FCCHGPCTFull/Inc. Copy: Changed rows in percentDB2CCCCHGS  
FCDAYSCOPYFull Copy: Number of days since last COPYDB2CCCDAYS  
FCINDEXSIZFull Copy: Minimum size of index in pages (NACTIVE)DB2CCISIZE  
REORGTIMETimestamp of last REORGDB2CCOTIMEDB2TMSTMP
RTINSDELUPREORG TS/IX: Changed rows in percentDB2CCRCHGS  
RTUNCLUSTREORG TS: Unclustered inserts in percentDB2CCUNCLU  
RTLOBPCTREORG TS: Disorganized LOBs in percentDB2CCLOB  
RTMASSDELREORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)DB2CCRMASS  
RTINDREFREORG TS: Indirect references (overflow records) in percentDB2CCIND  
RIINSDELREORG TS/IX: Changed rows in percentDB2CCRCHGS  
RIAPPINSREORG Index: Appended rows (with greater key) in percentDB2CCAPP  
RIPSEUDODEREORG Index: Pseudo deletes in percentDB2CCPSEUD  
RIMASSDELREORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)DB2CCRMASS  
RILEAFLIMREORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percentDB2CCLEAF  
RINUMLEVELREORG Index: Change to number of index tree levels absoluteDB2CCLEVEL  
RUNSTATSTITimestamp of last RUNSTATSDB2CCSTIMEDB2TMSTMP
STINSDELPRUNSTATS TS/IX: Changed rows in percentDB2CCSCHGS  
STINSDELARUN.:Changed rows (insert, delete or update) absolute numberDB2CCCHGAFLTP
STMASSDELRUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.)DB2CCSMASS  
SIINSDELPRUNSTATS TS/IX: Changed rows in percentDB2CCSCHGS  
SIINSDELARUN.:Changed rows (insert, delete or update) absolute numberDB2CCCHGAFLTP
SIMASSDELRUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.)DB2CCSMASS  
EXTENT_NONumber of physical extents in TS, IS or partitionDB2CCEXTNOINT2
RTINSDELUPABSREO.:Changed rows (insert, delete or update) absolute numberDB2CCRCHGA  
RTACTIVEPAGESREORG TS/IX: Number of active pagesDB2CCRROWS  

DB2CCDAILY related tables

TableNote
DB2CCDAILYList of TS/IXS needing utility treatment (DSNACCOR Daily)
DB2CCHOURList of TS/IXS needing utility treatment (DSNACCOR Hourly)
DB2CCDAILYXList of TS/IXS needing utility treatment (DSNACCOX Daily)
DB2CCACCORParameters of Control Center stored procedure DSNACCOR
SPROXXSLQQueue with objects needing generation of stylesheets
BGPROTDB utility log
DB2CCMO_OBJERRDSNACCMO: History of failed utility executions
DBAMLJob / Job Step Utility View
DSWP_SYSTEM_REPLUtility Table for Analysis Method Error Analysis
EKONGFranchise Contributions by Customer/Utility Co.
ESALES_PRODUCTTUtility Product Texts
ESALES_UTILPRODUtility products
ISU_CUSTESERVICEControl Parameter for Utility Customer E-Services
SLS_UTILPAW - utility table
TE187Utility Company
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com