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".
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 |
---|---|---|---|---|---|---|
PROFILE | Name of profile, so different configurations are supportable | X | CHAR | 8 | ||
FCUPDPGS | Full/Inc. Copy: Updated pages in percent of preformatted pag | DB2CCUPDPG | INT4 | 4 | ||
FCCHGPCT | Full/Inc. Copy: Changed rows in percent | DB2CCCCHGS | INT4 | 4 | ||
FCDAYSCOPY | Full Copy: Number of days since last COPY | DB2CCCDAYS | INT4 | 4 | ||
ICUPDPGS | Full/Inc. Copy: Updated pages in percent of preformatted pag | DB2CCUPDPG | INT4 | 4 | ||
ICCHGPCT | Full/Inc. Copy: Changed rows in percent | DB2CCCCHGS | INT4 | 4 | ||
FCINDEXSIZ | Full Copy: Minimum size of index in pages (NACTIVE) | DB2CCISIZE | INT4 | 4 | ||
RTINSDELUP | REORG TS/IX: Changed rows in percent | DB2CCRCHGS | INT4 | 4 | ||
RTUNCLUST | REORG TS: Unclustered inserts in percent | DB2CCUNCLU | INT4 | 4 | ||
RTLOBPCT | REORG TS: Disorganized LOBs in percent | DB2CCLOB | INT4 | 4 | ||
RTMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCRMASS | INT4 | 4 | ||
RTINDREF | REORG TS: Indirect references (overflow records) in percent | DB2CCIND | INT4 | 4 | ||
RIINSDEL | REORG TS/IX: Changed rows in percent | DB2CCRCHGS | INT4 | 4 | ||
RIAPPINS | REORG Index: Appended rows (with greater key) in percent | DB2CCAPP | INT4 | 4 | ||
RIPSEUDODE | REORG Index: Pseudo deletes in percent | DB2CCPSEUD | INT4 | 4 | ||
RIMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCRMASS | INT4 | 4 | ||
RILEAFLIM | REORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent | DB2CCLEAF | INT4 | 4 | ||
RINUMLEVEL | REORG Index: Change to number of index tree levels absolute | DB2CCLEVEL | INT4 | 4 | ||
STINSDELP | RUNSTATS TS/IX: Changed rows in percent | DB2CCSCHGS | INT4 | 4 | ||
STINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | DB2CCCHGA | FLTP | 8 | ||
STMASSDEL | RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCSMASS | INT4 | 4 | ||
SIINSDELP | RUNSTATS TS/IX: Changed rows in percent | DB2CCSCHGS | INT4 | 4 | ||
SIINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | DB2CCCHGA | FLTP | 8 | ||
SIMASSDEL | RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCSMASS | INT4 | 4 | ||
EXTENTS | Number of allowable dataset extents | DB2CCEXT | INT4 | 4 | ||
RTINSDELUPABS | REO.:Changed rows (insert, delete or update) absolute number | DB2CCRCHGA | INT4 | 4 | ||
RTACTIVEPAGES | REORG TS/IX: Number of active pages | DB2CCRROWS | INT4 | 4 |