SAP ABAP Domain DB2TABCAT (Table category for buffer pool tuning)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB2 (Application Component) DB2 for z/OS
⤷
STU2 (Package) CCMS for DB2 for OS/390
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU2 (Package) CCMS for DB2 for OS/390
Basic Data
| Domain Name | DB2TABCAT |
| Short Description | Table category for buffer pool tuning |
Definition
| Data Type | CHAR | Character String |
| No. Characters | 2 | |
| Decimal Places | ||
| Output Length | 2 | |
| Conversion Routine | ||
| Sign | ||
| Lower Case |
Value Range
| # | Lower Limit | Upper Limit | Short Description |
|---|---|---|---|
| 1 | C1 | Access type = sequential, changes < 10% | |
| 2 | C2 | Access type = sequential, changes > 10% | |
| 3 | C3 | Access type = random, changes < 10%, size = small | |
| 4 | C4 | Access type = random, changes < 10%, size = large | |
| 5 | C5 | Access type = random, changes > 10%, size = small | |
| 6 | C6 | Access type = random, changes > 10%, size = large | |
| 7 | C7 | Insert and/or delete only | |
| 8 | C8 | Reserved for tables VBLOG, VBDATA, VBHDR, VBMOD | |
| 9 | CT | Catalog | |
| 10 | K2 | Category C2, C5-C8 32K-page tables | |
| 11 | K3 | Category C1, C3, and C4 32K-page tables | |
| 12 | L2 | Category C2, C5-C8 8K-page tables | |
| 13 | L3 | Category C1, C3, and C4 8K-page tables | |
| 14 | M2 | Category C2, C5-C8 16K-page tables | |
| 15 | M3 | Category C1, C3, and C4 16K-page tables | |
| 16 | N1 | Non-categorized 16K-page tables | |
| 17 | N3 | Non-categorized 32K-page tables | |
| 18 | N4 | Non-categorized 4K-page tables | |
| 19 | N8 | Non-categorized 8K-page tables | |
| 20 | NI | Indexes for non-categorized tables | |
| 21 | W3 | 32K-page workfiles | |
| 22 | W4 | 4K-page workfiles | |
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 700 |
