DSNU234I csect-name COMPRESSION REPORT FOR TABLE SPACE table-space-name
Explanation
The data in the table space was compressed. This message is issued at the end of the RELOAD phase for the LOAD and REORG utility. The statistics that follow apply only to the data that was loaded or reorganized. For example, RESUME(YES) reports statistics only on the additional rows that were loaded, not what was previously in the table space.
The compression statistics follow:
- noncmpbytes
- The total number of uncompressed KB (where KB = 1024 bytes) for the loaded or reorganized data rows (including the row prefix). This number was rounded to the nearest KB.
- cmpbytes
- The total number of compressed KB for the loaded or reorganized data rows (including the row prefix). This number was rounded to the nearest KB.
- percsave
- The percentage of bytes saved from the loaded or reorganized data rows as a result of compression.
The preceding values reflect only the number of bytes for the data row and the respective row
prefix (6 bytes). Db2 page and dictionary
page overhead is not included.
- pctrowcomp
- The percentage of the rows that were compressed within the total number of rows that were loaded or reorganized. The stored length and the external length of a row was compared to determine if the row was compressed. If an EDITPROC is involved, its effect on the length of the row is considered in the calculation.
- noncmppages
- The estimated number of Db2 pages required by the uncompressed data rows that were loaded or reorganized. Space required for PCTFREE and FREEPAGE is included. This number was rounded up to the next integer.
- cmppages
- The estimated number of Db2 pages required by the compressed data rows that were loaded or reorganized. Space required for PCTFREE and FREEPAGE is included. Dictionary pages are also included unless a LOAD RESUME(YES) was run. This number was rounded up to the next integer.
- auncmprowlen
- Average uncompressed row length.
- avgcmprowlen
- Average compressed row length.
- pagesave
- An estimate of the percentage of Db2 pages saved by compressing the loaded or reorganized data rows.
- dictionarytype
- The type of compression dictionary built. This value can be either FIXED-LENGTH or HUFFMAN.
System action
Processing continues.
Module
- noncmpbytes
- KB WITHOUT COMPRESSION
- cmpbytes
- KB WITH COMPRESSION
- percsave
- PERCENT OF THE BYTES SAVED FROM COMPRESSED DATA ROWS
- pctrowcomp
- PERCENT OF THE LOADED ROWS WERE COMPRESSED
- noncmppages
- PAGES REQUIRED WITHOUT COMPRESSION
- cmppages
- PAGES REQUIRED WITH COMPRESSION
- auncmprowlen
- BYTES FOR AVERAGE UNCOMPRESSED ROW LENGTH
- avgcmprowlen
- BYTES FOR AVERAGE COMPRESSED ROW LENGTH
- pagesave
- PERCENT OF THE Db2 DATA PAGES SAVED USING COMPRESSED DATA
- dictionarytype
- TYPE OF COMPRESSION DICTIONARY
Severity
0 (informational)