DB2CCACCOR - Parameters of Control Center stored procedure DSNACCOR

Parameters of Control Center stored procedure DSNACCOR information is stored in SAP table DB2CCACCOR.
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".

Fields for table DB2CCACCOR

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
PROFILEName of profile, so different configurations are supportableXCHAR8
FCUPDPGSFull/Inc. Copy: Updated pages in percent of preformatted pagDB2CCUPDPGINT44
FCCHGPCTFull/Inc. Copy: Changed rows in percentDB2CCCCHGSINT44
FCDAYSCOPYFull Copy: Number of days since last COPYDB2CCCDAYSINT44
ICUPDPGSFull/Inc. Copy: Updated pages in percent of preformatted pagDB2CCUPDPGINT44
ICCHGPCTFull/Inc. Copy: Changed rows in percentDB2CCCCHGSINT44
FCINDEXSIZFull Copy: Minimum size of index in pages (NACTIVE)DB2CCISIZEINT44
RTINSDELUPREORG TS/IX: Changed rows in percentDB2CCRCHGSINT44
RTUNCLUSTREORG TS: Unclustered inserts in percentDB2CCUNCLUINT44
RTLOBPCTREORG TS: Disorganized LOBs in percentDB2CCLOBINT44
RTMASSDELREORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)DB2CCRMASSINT44
RTINDREFREORG TS: Indirect references (overflow records) in percentDB2CCINDINT44
RIINSDELREORG TS/IX: Changed rows in percentDB2CCRCHGSINT44
RIAPPINSREORG Index: Appended rows (with greater key) in percentDB2CCAPPINT44
RIPSEUDODEREORG Index: Pseudo deletes in percentDB2CCPSEUDINT44
RIMASSDELREORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)DB2CCRMASSINT44
RILEAFLIMREORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percentDB2CCLEAFINT44
RINUMLEVELREORG Index: Change to number of index tree levels absoluteDB2CCLEVELINT44
STINSDELPRUNSTATS TS/IX: Changed rows in percentDB2CCSCHGSINT44
STINSDELARUN.:Changed rows (insert, delete or update) absolute numberDB2CCCHGAFLTP8
STMASSDELRUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.)DB2CCSMASSINT44
SIINSDELPRUNSTATS TS/IX: Changed rows in percentDB2CCSCHGSINT44
SIINSDELARUN.:Changed rows (insert, delete or update) absolute numberDB2CCCHGAFLTP8
SIMASSDELRUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.)DB2CCSMASSINT44
EXTENTSNumber of allowable dataset extentsDB2CCEXTINT44
RTINSDELUPABSREO.:Changed rows (insert, delete or update) absolute numberDB2CCRCHGAINT44
RTACTIVEPAGESREORG TS/IX: Number of active pagesDB2CCRROWSINT44
Privacy Policy