DB2CCACCOX - Parameters stored procedure DSNACCOX
Parameters stored procedure DSNACCOX information is stored in SAP table DB2CCACCOX.
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 DB2CCACCOX
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 Copy: Updated pages in percent | DEC | 5 | |||
| FCUPDPGSABS | Full Copy: Updated pages absolut | INT4 | 4 | |||
| FCCHGPCT | Full Copy: Changed rows in percent | DEC | 5 | |||
| FCDAYSCOPY | Full Copy: Number of days since last COPY | DB2CCCDAYS | INT4 | 4 | ||
| ICUPDPGS | Inc. Copy: Updated pages in percent | DEC | 5 | |||
| ICUPDPGSABS | Inc. Copy: Updated pages absolut | INT4 | 4 | |||
| ICCHGPCT | Inc. Copy: Changed rows in percent | DEC | 5 | |||
| FCINDEXSIZ | Full Copy: Minimum size of index in pages (NACTIVE) | DB2CCISIZE | INT4 | 4 | ||
| RTINSPCT | REORG TS: Inserted rows in percent | DEC | 5 | |||
| RTINSABS | REORG TS: Inserted rows absolut | INT4 | 4 | |||
| RTDELPCT | REORG TS:Deleted rows in percent | DEC | 5 | |||
| RTDELABS | REORG TS:Deleted rows absolut | INT4 | 4 | |||
| RTUNCLUST | REORG TS: Unclustered inserts in percent | DEC | 5 | |||
| RTLOBPCT | REORG TS: Disorganized LOBs in percent | DEC | 5 | |||
| RTDATASPRAT | REORG TS: Ration between RTS SPACE and RTS DATASIZE | DEC | 5 | |||
| RTMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCRMASS | INT4 | 4 | ||
| RTINDREF | REORG TS: Indirect references (overflow records) in percent | DEC | 5 | |||
| RIINSPCT | REORG IX: Inserted rows in percent | DEC | 5 | |||
| RIINSABS | REORG IX: Inserted rows absolut | INT4 | 4 | |||
| RIDELPCT | REORG IX: Deleted rows in percent | DEC | 5 | |||
| RIDELABS | REORG IX: Deleted rows absolut | INT4 | 4 | |||
| RIAPPINS | REORG IX: Appended rows (with greater key) in percent | DEC | 5 | |||
| RIPSEUDODE | REORG IX: Pseudo deletes in percent | DEC | 5 | |||
| RIMASSDEL | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCRMASS | INT4 | 4 | ||
| RILEAFLIM | REORG IX: Pages phys. far away (INDEXPART.LEAFFAR) percent | DEC | 5 | |||
| RINUMLEVEL | REORG Index: Change to number of index tree levels absolute | DB2CCLEVEL | INT4 | 4 | ||
| STINSDELP | RUNSTATS TS: Changed rows in percent | DEC | 5 | |||
| STINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | INT4 | 4 | |||
| STMASSDEL | RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCSMASS | INT4 | 4 | ||
| SIINSDELP | RUNSTATS IX: Changed rows in percent | DEC | 5 | |||
| SIINSDELA | RUN.:Changed rows (insert, delete or update) absolute number | INT4 | 4 | |||
| SIMASSDEL | RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | DB2CCSMASS | INT4 | 4 | ||
| EXTENTS | Number of allowable dataset extents | DB2CCEXT | INT4 | 4 | ||
| CHKLVL | Specifies the types of checking that DSNACCOX performs | INT4 | 4 |