Hierarchy
⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
⤷ STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Data Element | DB2PGSAVE |
Short Description | Percentage of pages saved in the TS because of compression |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | DB2SINT | |
Data Type | INT2 | 2-byte integer, only for length field before LCHR or LRAW |
Length | 5 | |
Decimal Places | 0 | |
Output Length | 5 | |
Value Table |
Further Characteristics
Search Help: Name | ||
Search Help: Parameters | ||
Parameter ID | ||
Default Component name | ||
Change document | ||
No Input History | ||
Basic direction is set to LTR | ||
No BIDI Filtering |
Field Label
Length | Field Label | |
Short | 8 | PageSave |
Medium | 8 | PageSave |
Long | 8 | PageSave |
Heading | 8 | PageSave |
Documentation
Definition
Percentage of pages saved in the tablespace or partition as a result of defining the tablespace with COMPRESS YES or other compression routines. For example, a value of 25 indicates a savings of 25 percent, so that the pages required are only 75 percent of what would be required without data compression. The calculation includes overhead bytes for each row, the bytes required for dictionary, and the bytes required for the current FREEPAGE and PCTFREE specification for the tablespace or partition. This calculation is based on the average row length, and the result varies depending on the actual lengths of the rows. The value is 0 if there are no savings from using data compression or if statistics have not been gathered. The value can be negative, if for example, data compression causes an increase in the number of pages in the dataset.
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in | 700 |