DB2CCDAILY SAP (List of TS/IXS needing utility treatment (DSNACCOR Daily)) Table details

Dictionary Type: Table
Description: List of TS/IXS needing utility treatment (DSNACCOR Daily)




ABAP Code to SELECT data from DB2CCDAILY
Related tables to DB2CCDAILY
Access table DB2CCDAILY




Table field list including key, data, relationships and ABAP select examples

DB2CCDAILY is a standard SAP Table which is used to store List of TS/IXS needing utility treatment (DSNACCOR Daily) data and is available within R/3 SAP systems depending on the version and release level.

The DB2CCDAILY table consists of various fields, each holding specific information or linking keys about List of TS/IXS needing utility treatment (DSNACCOR 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 empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP DB2CCDAILY 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_ANADate of the last check DB2BCKDATEDATS8DATUM
TIME_ANATime of the last check DB2BCKTIMETIMS6TIME
DBNAMDatabase name DB2DBNAMECHAR8D2DBNAME
TSNAMName of the tablespace DB2TSNAMECHAR8CHAR8
TSPARTPartition number DB2PARTNRSINT25DB2SINT
CREATORDB2 creator name DB2CREATORCHAR8CHAR8
IXNAMEName of a DB2 for OS/390 index DB2IDXNAMECHAR18CHAR18
DBNAMEDatabase name DB2DBNAMECHAR8D2DBNAME
TSNAMEName of the tablespace DB2TSNAMECHAR8CHAR8
PARTIData set number or partition number DB2CCPARTINT25DB2PART
OBJTYPEDB2 object type: TS for tablespace, IX for indexspace DB2CCOBJTCHAR2CHAR2
OBJSTATUSDB2 object status: NULL, restricted states or orphaned DB2CCOBJSCHAR36CHAR36
COPYRECCOPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both) DB2CCCPYRCHAR3CHAR3
RUNSTRECRUNSTATS Recommendation: YES or NO DB2CCSRECCHAR3CHAR3
EXTENTSExtentlimit was exceeded: YES or NO DB2CCEXTLCHAR3CHAR3
REORGRECREORG Recommendation: YES or NO DB2CCORECCHAR3CHAR3
EXCTABLEDefined in exceptiontable: YES, NO, QUERY or NULL(no exctab) DB2CCEXCLCHAR40CHAR40
ASSOCTSAssociated tablespace for indexspace DB2CCASSTSCHAR8DB2TSNAME
COPYTIMETimestamp of last full image COPY DB2CCCTIMECHAR26DB2TMSTMP
LOADREPLTITimestamp of last LOAD REPLACE DB2CCLTIMECHAR26DB2TMSTMP
REBUILDTIMTimestamp of last REBUILD INDEX DB2CCRTIMECHAR26DB2TMSTMP
FCUPDPGSFull/Inc. Copy: Updated pages in percent of preformatted pag DB2CCUPDPGINT410
FCCHGPCTFull/Inc. Copy: Changed rows in percent DB2CCCCHGSINT410
FCDAYSCOPYFull Copy: Number of days since last COPY DB2CCCDAYSINT410
FCINDEXSIZFull Copy: Minimum size of index in pages (NACTIVE) DB2CCISIZEINT410
REORGTIMETimestamp of last REORG DB2CCOTIMECHAR26DB2TMSTMP
RTINSDELUPREORG TS/IX: Changed rows in percent DB2CCRCHGSINT410
RTUNCLUSTREORG TS: Unclustered inserts in percent DB2CCUNCLUINT410
RTLOBPCTREORG TS: Disorganized LOBs in percent DB2CCLOBINT410
RTMASSDELREORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) DB2CCRMASSINT410
RTINDREFREORG TS: Indirect references (overflow records) in percent DB2CCINDINT410
RIINSDELREORG TS/IX: Changed rows in percent DB2CCRCHGSINT410
RIAPPINSREORG Index: Appended rows (with greater key) in percent DB2CCAPPINT410
RIPSEUDODEREORG Index: Pseudo deletes in percent DB2CCPSEUDINT410
RIMASSDELREORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) DB2CCRMASSINT410
RILEAFLIMREORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent DB2CCLEAFINT410
RINUMLEVELREORG Index: Change to number of index tree levels absolute DB2CCLEVELINT410
RUNSTATSTITimestamp of last RUNSTATS DB2CCSTIMECHAR26DB2TMSTMP
STINSDELPRUNSTATS TS/IX: Changed rows in percent DB2CCSCHGSINT410
STINSDELARUN.:Changed rows (insert, delete or update) absolute number DB2CCCHGAFLTP16(16) FLTP
STMASSDELRUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) DB2CCSMASSINT410
SIINSDELPRUNSTATS TS/IX: Changed rows in percent DB2CCSCHGSINT410
SIINSDELARUN.:Changed rows (insert, delete or update) absolute number DB2CCCHGAFLTP16(16) FLTP
SIMASSDELRUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) DB2CCSMASSINT410
EXTENT_NONumber of physical extents in TS, IS or partition DB2CCEXTNOINT25INT2
RTINSDELUPABSREO.:Changed rows (insert, delete or update) absolute number DB2CCRCHGAINT410
RTACTIVEPAGESREORG TS/IX: Number of active pages DB2CCRROWSINT410

Key field Non-key field



How do I retrieve data from SAP table DB2CCDAILY using ABAP code

The following ABAP code Example will allow you to do a basic selection on DB2CCDAILY to SELECT all data from the table
DATA: WA_DB2CCDAILY TYPE DB2CCDAILY.

SELECT SINGLE *
FROM DB2CCDAILY
INTO CORRESPONDING FIELDS OF WA_DB2CCDAILY
WHERE...

How to access SAP table DB2CCDAILY

Within an ECC or HANA version of SAP you can also view further information about DB2CCDAILY and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!