DSN1COMP output
The DSN1COMP utility generates a report that includes the estimated space savings that can be achieved by using compression.
The first part of the report lists the input parameters in message DSN1944I. For table spaces, this message also reports whether the input data set was compressed and if so, the type of compression used. For example:
INPUT DATA SET CONTAINS COMPRESSED DATA
USING HUFFMAN COMPRESSION TYPE
If a compression dictionary exists, this message also reports whether the existing dictionary was
built by an insert operation or by a utility. For
example:
INPUT DICTIONARY WAS BUILT BY INSERTMessage DSN1940I then lists the requested compression estimates. For table spaces, this message also reports whether the hardware required for Huffman compression (IBM z14® or later) is available.
For table space reports, the following fields contain the indicated values:
- DATA PAGES NEEDED
- The number of pages that are needed for data. For the columns that report compression information, this value is calculated based on the percent of savings from the estimated total uncompressed data.
- DICTIONARY PAGES REQUIRED
- The estimated number of pages required to build dictionary pages. For segmented (non-UTS) table spaces or universal table spaces (UTS), these pages are calculated based on the segment boundary. The entire segment is allocated for the dictionary pages and the SEGSIZE value contributes to the number of pages that are reserved for the dictionary pages. DICTIONARY PAGES REQUIRED does not reflect the actual number of pages used for the dictionary.
- TOTAL PAGES
- The total number of pages. For the columns that report compression information, this value is calculated based on the percent of savings from the estimated total uncompressed data.
Message DSN1994I reports the number of physical pages that are processed from the input file.
Tip: If you receive message DSN1941I, use a data set with
more rows as input, or specify a larger value for ROWLIMIT.
Sample DSN1COMP reports for a table space
The following four sample reports show the DSN1COMP output for a table space based on the type of compression estimate (COMPTYPE) requested where the input data set is uncompressed.
COMPTYPE not specified: The following sample report shows the output when COMPTYPE is not specified. In this case, DSN1COMP was run on IBM z14 or later hardware. (If DSN1COMP is run on earlier hardware, the report omits the Huffman compression estimate.)
DSN1999I START OF DSN1COMP FOR JOB DSN1CMP COMPTS4
DSN1998I INPUT DSNAME = DSNC000.DSNDBC.EMPDB.EMPSPACE.I0001.A001 , VSAM
DSN1944I DSN1COMP INPUT PARAMETERS
INPUT DATA SET CONTAINS NON-COMPRESSED DATA
4,096 DICTIONARY SIZE USED
0 FREEPAGE VALUE USED
5 PCTFREE VALUE USED
COMPTYPE NOT SPECIFIED
NO ROWLIMIT WAS REQUESTED
ESTIMATE BASED ON DB2 LOAD METHOD
255 MAXROWS VALUE USED
DSN1940I DSN1COMP COMPRESSION REPORT
HARDWARE SUPPORT FOR HUFFMAN COMPRESSION IS AVAILABLE
+-----------------------------------+------------------+------------------+------------------+
| | | Estimated state | Estimated state |
| | UNCOMPRESSED | Compressed | Compressed |
| | | FIXED | HUFFMAN |
+-----------------------------------+------------------+------------------+------------------+
| DATA (IN KB) | 224 | 178 | 173 |
| PERCENT SAVINGS | | 20%| 22%|
| | | | |
| AVERAGE BYTES PER ROW | 48 | 39 | 38 |
| PERCENT SAVINGS | | 18%| 20%|
| | | | |
| DATA PAGES NEEDED | 63 | 68 | 70 |
| PERCENT DATA PAGES SAVED | | 7%| 11%|
| | | | |
| DICTIONARY PAGES REQUIRED | 0 | 16 | 20 |
| ROWS SCANNED TO BUILD DICTIONARY | | 1,969 | 1,969 |
| ROWS SCANNED TO PROVIDE ESTIMATE | | 5,000 | 5,000 |
| DICTIONARY ENTRIES | | 4,096 | 4,080 |
| | | | |
| TOTAL PAGES (DICTIONARY + DATA) | 63 | 84 | 90 |
| PERCENT SAVINGS | | 33%| 42%|
+-----------------------------------+------------------+------------------+------------------+
DSN1994I DSN1COMP COMPLETED SUCCESSFULLY, 63 PAGES PROCESSEDCOMPTYPE(ALL) The following sample report shows the output for a table space when COMPTYPE(ALL) is specified. It includes the estimated space savings for both fixed-length and Huffman compression.
DSN1999I START OF DSN1COMP FOR JOB DSN1CMP STEP2
DSN1998I INPUT DSNAME = DSNC000.DSNDBC.DB1.TS1.I0001.A001 , VSAM
DSN1944I DSN1COMP INPUT PARAMETERS
INPUT DATA SET CONTAINS NON-COMPRESSED DATA
4,096 DICTIONARY SIZE USED
0 FREEPAGE VALUE USED
5 PCTFREE VALUE USED
NO ROWLIMIT WAS REQUESTED
ESTIMATE BASED ON DB2 LOAD METHOD
255 MAXROWS VALUE USED
DSN1940I DSN1COMP COMPRESSION REPORT
Hardware support for Huffman compression is available
+-----------------------------------+------------------+------------------+------------------+
| | | Estimated state | Estimated state |
| | UNCOMPRESSED | Compressed | Compressed |
| | | FIXED | HUFFMAN |
+-----------------------------------+------------------+------------------+------------------+
| Data (in KB) | 1,758 | 1,232 | 1,278 |
| Percent savings | | 29%| 27%|
| | | | |
| Average Bytes per row | 38 | 28 | 29 |
| Percent savings | | 26%| 23%|
| | | | |
| Data Pages needed | 496 | 381 | 398 |
| Percent Data pages saved | | 23%| 19%|
| | | | |
| Dictionary pages required | 0 | 16 | 19 |
| Rows scanned to build dictionary | | 5,311 | 5,311 |
| Rows scanned to provide estimate | | 50,000 | 50,000 |
| Dictionary Entries | | 4,096 | 4,080 |
| | | | |
| Total Pages (Dictionary + Data) | 496 | 397 | 417 |
| Percent savings | | 19%| 15%|
+-----------------------------------+------------------+------------------+------------------+
DSN1994I DSN1COMP COMPLETED SUCCESSFULLY, 475 PAGES PROCESSED
COMPTYPE(FIXED) The following sample report shows the output for a table space when COMPTYPE(FIXED) is specified. It includes the estimated space savings for only fixed-length compression.
DSN1999I START OF DSN1COMP FOR JOB DSN1CMP STEP2
DSN1998I INPUT DSNAME = DSNC000.DSNDBC.DB1.TS1.I0001.A001 , VSAM
DSN1944I DSN1COMP INPUT PARAMETERS
INPUT DATA SET CONTAINS NON-COMPRESSED DATA
4,096 DICTIONARY SIZE USED
0 FREEPAGE VALUE USED
5 PCTFREE VALUE USED
NO ROWLIMIT WAS REQUESTED
ESTIMATE BASED ON DB2 LOAD METHOD
255 MAXROWS VALUE USED
DSN1940I DSN1COMP COMPRESSION REPORT
Hardware support for Huffman compression is available
+-----------------------------------+------------------+------------------+
| | | Estimated state |
| | UNCOMPRESSED | Compressed |
| | | FIXED |
+-----------------------------------+------------------+------------------+
| Data (in KB) | 1,758 | 1,232 |
| Percent savings | | 29%|
| | | |
| Average Bytes per row | 38 | 28 |
| Percent savings | | 26%|
| | | |
| Data Pages needed | 496 | 381 |
| Percent Data pages saved | | 23%|
| | | |
| Dictionary pages required | 0 | 16 |
| Rows scanned to build dictionary | | 5,311 |
| Rows scanned to provide estimate | | 50,000 |
| Dictionary Entries | | 4,096 |
| | | |
| Total Pages (Dictionary + Data) | 496 | 397 |
| Percent savings | | 19%|
+-----------------------------------+------------------+------------------+
DSN1994I DSN1COMP COMPLETED SUCCESSFULLY, 475 PAGES PROCESSEDCOMPTYPE(HUFFMAN) The following sample report shows the output for a table space when COMPTYPE(HUFFMAN) is specified. It includes the estimated space savings for only Huffman compression.
DSN1999I START OF DSN1COMP FOR JOB DSN1CMP STEP2
DSN1998I INPUT DSNAME = DSNC000.DSNDBC.DB1.TS1.I0001.A001 , VSAM
DSN1944I DSN1COMP INPUT PARAMETERS
INPUT DATA SET CONTAINS NON-COMPRESSED DATA
4,096 DICTIONARY SIZE USED
0 FREEPAGE VALUE USED
5 PCTFREE VALUE USED
NO ROWLIMIT WAS REQUESTED
ESTIMATE BASED ON DB2 LOAD METHOD
255 MAXROWS VALUE USED
DSN1940I DSN1COMP COMPRESSION REPORT
Hardware support for Huffman compression is available
+-----------------------------------+------------------+------------------+
| | | Estimated state |
| | UNCOMPRESSED | Compressed |
| | | HUFFMAN |
+-----------------------------------+------------------+------------------+
| Data (in KB) | 1,758 | 1,278 |
| Percent savings | | 27%|
| | | |
| Average Bytes per row | 38 | 29 |
| Percent savings | | 23%|
| | | |
| Data Pages needed | 496 | 398 |
| Percent Data pages saved | | 19%|
| | | |
| Dictionary pages required | 0 | 19 |
| Rows scanned to build dictionary | | 5,311 |
| Rows scanned to provide estimate | | 50,000 |
| Dictionary Entries | | 4,080 |
| | | |
| Total Pages (Dictionary + Data) | 496 | 417 |
| Percent savings | | 15%|
+-----------------------------------+------------------+------------------+
DSN1994I DSN1COMP COMPLETED SUCCESSFULLY, 475 PAGES PROCESSEDCompressed input: The following sample report shows the output for a table space when the input data set is compressed. The output includes an extra column with information from the input compression dictionary.
DSN1999I START OF DSN1COMP FOR JOB DSN1CMP STEP2
DSN1998I INPUT DSNAME = DB2DUMP.DSNDBD.DBPBR2.TSPBR2.I0001.A001 , SEQ
DSN1944I DSN1COMP INPUT PARAMETERS
INPUT DATA SET CONTAINS COMPRESSED DATA
USING FIXED-LENGTH COMPRESSION TYPE
INPUT DICTIONARY WAS BUILT BY INSERT
4,096 DICTIONARYSIZE USED
0 FREEPAGE VALUE USED
5 PCTFREE VALUE USED
COMPTYPE NOT SPECIFIED
NO ROWLIMIT WAS REQUESTED
ESTIMATE BASED ON DB2 LOAD METHOD
255 MAXROWS VALUE USED
DSN1940I DSN1COMP COMPRESSION REPORT
HARDWARE SUPPORT FOR HUFFMAN COMPRESSION IS AVAILABLE
+-----------------------------------+------------------+------------------+------------------+------------------+
| | | Estimated state | Estimated state | Calculated |
| | UNCOMPRESSED | Compressed | Compressed | Compressed from |
| | | FIXED | HUFFMAN | INPUT DICTIONARY |
+-----------------------------------+------------------+------------------+------------------+------------------+
| DATA (IN KB) | 1,659,179 | 434,603 | 222,697 | 436,780 |
| PERCENT SAVINGS | | 73%| 86%| 73%|
| | | | | |
| AVERAGE BYTES PER ROW | 1,701 | 448 | 231 | 450 |
| PERCENT SAVINGS | | 73%| 86%| 73%|
| | | | | |
| DATA PAGES NEEDED | 500,000 | 125,000 | 62,500 | 125,000 |
| PERCENT DATA PAGES SAVED | | 75%| 87%| 75%|
| | | | | |
| DICTIONARY PAGES REQUIRED | 0 | 64 | 64 | 64 |
| ROWS SCANNED TO BUILD DICTIONARY | | 81 | 81 | N/A |
| ROWS SCANNED TO PROVIDE ESTIMATE | | 1,000,000 | 1,000,000 | N/A |
| DICTIONARY ENTRIES | | 4,096 | 4,080 | 4,096 |
| | | | | |
| TOTAL PAGES (DICTIONARY + DATA) | 500,000 | 125,064 | 62,564 | 125,064 |
| PERCENT SAVINGS | | 74%| 87%| 74%|
+-----------------------------------+------------------+------------------+------------------+------------------+
DSN1994I DSN1COMP COMPLETED SUCCESSFULLY, 118,475 PAGES PROCESSED Sample DSN1COMP report for an index
When you run DSN1COMP on an index, the generated report includes the estimated reduction in leaf page space, as shown in the following sample report:
DSN1999I START OF DSN1COMP FOR JOB DSN1COMP STEP2
DSN1998I INPUT DSNAME = TESTCAT.DSNDBD.DB1COMPR.I1.I0001.A001 , VSAM
DSN1944I DSN1COMP INPUT PARAMETERS
PROCESSING PARMS FOR INDEX DATASET:
NO LEAFLIM WAS REQUESTED
DSN1940I DSN1COMP COMPRESSION REPORT
38 Index Leaf Pages Processed
3,000 Keys Processed
3,000 Rids Processed
401 KB of Key Data Processed
106 KB of Compressed Keys Produced
EVALUATION OF COMPRESSION WITH DIFFERENT INDEX PAGE SIZES:
----------------------------------------------
8 K Page Buffer Size yields a
51 % Reduction in Index Leaf Page Space
The Resulting Index would have approximately
49 % of the original index's Leaf Page Space
No Bufferpool Space would be unused
----------------------------------------------
----------------------------------------------
16 K Page Buffer Size yields a
74 % Reduction in Index Leaf Page Space
The Resulting Index would have approximately
26 % of the original index's Leaf Page Space
3 % of Bufferpool Space would be unused to
ensure keys fit into compressed buffers
----------------------------------------------
DSN1994I DSN1COMP COMPLETED SUCCESSFULLY, 38 PAGES PROCESSED
Sample DSN1COMP report for an uncompressed LOB table space
When you run DSN1COMP on an uncompressed LOB table space, the generated report includes the estimated data pages saved for each page size, as shown in the following sample report:
DSN1944I DSN1COMP INPUT PARAMETERS
PROCESSING PARMS FOR LOB DATASET:
LOB
DSN1940I DSN1COMP COMPRESSION REPORT
DSN1COMP run on uncompressed LOB table space
NOTE:
- LOB sizes do not include inline portion of the LOB data
- System pages include Space Map pages and LOB Map Pages
- System pages are not candidates for compression
- LOB Map pages may contain LOB data
- Only LOB data pages can be saved due to compression
LOB table space statistics
--------------------------------------------------------------------------------------
Current page size 4 KB
Number of LOBs 4,909 LOBs
Number of de-allocated LOBs 75 LOBs
Number of de-allocated pages 204 Pages
Minimum LOB size 490 Bytes
Maximum LOB size 63 KB
Average LOB size 10 KB
Histogram of LOB sizes (uncompressed) Count Percent
--------------------------------------------------------------------------------------
< 500b 1,210 25 %
--------------------------------------------------------------------------------------
500b to 1k 0 0 %
1k to 2k 0 0 %
2k to 3k 0 0 %
3k to 4k 1,203 25 %
--------------------------------------------------------------------------------------
4k to 5k 0 0 %
5k to 6k 1,215 25 %
6k to 7k 0 0 %
7k to 8k 0 0 %
--------------------------------------------------------------------------------------
8k to 10k 0 0 %
10k to 12k 0 0 %
12k to 14k 0 0 %
14k to 16k 0 0 %
--------------------------------------------------------------------------------------
16k to 20k 0 0 %
20k to 24k 0 0 %
24k to 28k 0 0 %
28k to 32k 1,231 25 %
--------------------------------------------------------------------------------------
> 32k 50 1 %
Uncompressed Table space from input
--------------------------------------------------------------------------------------
System Pages 4,994 Pages
Space Map pages 84 Pages
LOB Map pages 4,909 Pages
Data pages 9,351 Pages
De-allocated pages 204 Pages
Total pages 14,549 Pages
LOB compression ratio
--------------------------------------------------------------------------------------
Total LOB data compressed 14,314 KB
Total LOB data uncompressed 49,527 KB
Percentage of KB saved 72 %
Data pages needed for compressed LOB table space 1,384 Pages
Data pages needed for uncompressed LOB table space 9,351 Pages
Percentage of Data pages saved 86 %
Total pages needed for compressed LOB table space 6,346 Pages
Total pages needed for uncompressed LOB table space 14,345 Pages
Percentage of total pages saved 56 %
EVALUATION OF COMPRESSION WITH DIFFERENT PAGE SIZES
NOTE: SYSTEM pages include Header, Space Maps, and LOB Map pages. LOB Map pages may contain LOB data
+----------+--------------------------------------------------+--------------------------------------------------+-------------+
| | Uncompressed LOB table space | Compressed LOB table space | Savings |
+----------+--------------------------------------------------+--------------------------------------------------+-------------+
|page size | System pages | Data pages | Total pages | System pages | Data pages | Total pages | Total pages |
+----------+--------------------------------------------------+--------------------------------------------------+-------------+
| 4k | 4,994 | 9,351 | 14,345 | 4,962 | 1,384 | 6,346 | 56 % |
| 8k | 4,946 | 4,043 | 8,989 | 4,930 | 53 | 4,983 | 45 % |
| 16k | 4,930 | 1,381 | 6,311 | 4,930 | 0 | 4,930 | 22 % |
| 32k | 4,930 | 50 | 4,980 | 4,930 | 0 | 4,930 | 2 % |
+----------+--------------------------------------------------+--------------------------------------------------+-------------+
+----------+----------------------------+----------------------------+-------------+
| |Uncompressed LOB table space|Compressed LOB table space | Savings |
+----------+----------------------------+----------------------------+-------------+
|page size | Storage required (KB) | Storage required (KB) | Storage |
+----------+----------------------------+----------------------------+-------------+
| 4k | 58,757 | 25,993 | 56 % |
| 8k | 73,637 | 40,820 | 45 % |
| 16k | 103,399 | 80,773 | 22 % |
| 32k | 163,184 | 161,546 | 2 % |
+----------+----------------------------+----------------------------+-------------+
DSN1994I DSN1COMP COMPLETED SUCCESSFULLY, 16,380 PAGES PROCESSED
Sample DSN1COMP report for a compressed LOB table space
When you run DSN1COMP on a compressed LOB table space, the generated report includes the estimated data pages saved for each page size, as shown in the following sample report:
DSN1944I DSN1COMP INPUT PARAMETERS
PROCESSING PARMS FOR LOB DATASET:
LOB
DSN1940I DSN1COMP COMPRESSION REPORT
DSN1COMP run on compressed LOB table space
NOTE:
- LOB sizes do not include inline portion of the LOB data
- System pages include Space Map pages and LOB Map Pages
- System pages are not candidates for compression
- LOB Map pages may contain LOB data
- Only LOB data pages can be saved due to compression
LOB table space statistics
--------------------------------------------------------------------------------------
Current page size 4 KB
Number of LOBs 4,909 LOBs
Number of de-allocated LOBs 0 LOBs
Number of de-allocated pages 0 Pages
Minimum LOB size 490 Bytes
Maximum LOB size 63 KB
Average LOB size 10 KB
Histogram of LOB sizes (uncompressed) Count Percent
--------------------------------------------------------------------------------------
< 500b 1,191 24 %
--------------------------------------------------------------------------------------
500b to 1k 0 0 %
1k to 2k 0 0 %
2k to 3k 0 0 %
3k to 4k 1,228 25 %
--------------------------------------------------------------------------------------
4k to 5k 0 0 %
5k to 6k 1,221 25 %
6k to 7k 0 0 %
7k to 8k 0 0 %
--------------------------------------------------------------------------------------
8k to 10k 0 0 %
10k to 12k 0 0 %
12k to 14k 0 0 %
14k to 16k 0 0 %
--------------------------------------------------------------------------------------
16k to 20k 0 0 %
20k to 24k 0 0 %
24k to 28k 0 0 %
28k to 32k 1,219 25 %
--------------------------------------------------------------------------------------
> 32k 50 1 %
Compressed Table space from input
--------------------------------------------------------------------------------------
System Pages 4,962 Pages
Space Map pages 52 Pages
LOB Map pages 4,909 Pages
Data pages 1,369 Pages
De-allocated pages 0 Pages
Total pages 6,331 Pages
Table space with compression (in KB)
--------------------------------------------------------------------------------------
Number of uncompressed LOBs 2,419 LOBs
Number of compressed LOBs 2,490 LOBs
Total uncompressed data 5,241 KB
Total compressed data 9,392 KB
Total LOB data 14,634 KB
Table space if uncompressed (in KB)
--------------------------------------------------------------------------------------
Number of LOBs 4,909 LOBs
Total uncompressed data 49,309 KB
Total compressed data 0 KB
Total LOB data 49,309 KB
LOB compression ratio
--------------------------------------------------------------------------------------
Total LOB data compressed 14,634 KB
Total LOB data uncompressed 49,309 KB
Percentage of KB saved 71 %
Data pages needed for compressed LOB table space 1,369 Pages
Data pages needed for uncompressed LOB table space 9,285 Pages
Percentage of Data pages saved 86 %
Total pages needed for compressed LOB table space 6,331 Pages
Total pages needed for uncompressed LOB table space 14,279 Pages
Percentage of total pages saved 56 %
EVALUATION OF COMPRESSION WITH DIFFERENT PAGE SIZES
NOTE: SYSTEM pages include Header, Space Maps, and LOB Map pages. LOB Map pages may contain LOB data
+----------+--------------------------------------------------+--------------------------------------------------+-------------+
| | Uncompressed LOB table space | Compressed LOB table space | Savings |
+----------+--------------------------------------------------+--------------------------------------------------+-------------+
|page size | System pages | Data pages | Total pages | System pages | Data pages | Total pages | Total pages |
+----------+--------------------------------------------------+--------------------------------------------------+-------------+
| 4k | 4,994 | 9,285 | 14,279 | 4,962 | 1,369 | 6,331 | 56 % |
| 8k | 4,946 | 4,007 | 8,953 | 4,930 | 50 | 4,980 | 45 % |
| 16k | 4,930 | 1,369 | 6,299 | 4,930 | 0 | 4,930 | 22 % |
| 32k | 4,930 | 50 | 4,980 | 4,930 | 0 | 4,930 | 2 % |
+----------+--------------------------------------------------+--------------------------------------------------+-------------+
+----------+----------------------------+----------------------------+-------------+
| |Uncompressed LOB table space| Compressed LOB table space | Savings |
+----------+----------------------------+----------------------------+-------------+
|page size | Storage required (KB) | Storage required (KB) | Storage |
+----------+----------------------------+----------------------------+-------------+
| 4k | 58,486 | 25,931 | 56 % |
| 8k | 73,342 | 40,796 | 45 % |
| 16k | 103,202 | 80,773 | 22 % |
| 32k | 163,184 | 161,546 | 2 % |
+----------+----------------------------+----------------------------+-------------+
DSN1994I DSN1COMP COMPLETED SUCCESSFULLY, 6,331 PAGES PROCESSEDSample DSN1COMP report when zEDC compression is unavailable
If the LOB option is specified, DSN1COMP attempts to rendezvous with the zEDC API. If this rendezvous fails, DSN1COMP still produces a report with statistics for the LOB table space but omits compression estimates. The return code and reason code for the zEDC error are also reported. For more information about these return codes and reason codes, see z System authorized compression services.
DSN1944I DSN1COMP INPUT PARAMETERS
PROCESSING PARMS FOR LOB DATASET:
LOB
zEDC COMPRESSION IS UNAVAILABLE FPZ4RZV RC= 4 REASON= 102
DSN1940I DSN1COMP COMPRESSION REPORT
DSN1COMP run on uncompressed LOB table space
NOTE:
- LOB sizes do not include inline portion of the LOB data
- System pages include Space Map pages and LOB Map Pages
- System pages are not candidates for compression
- LOB Map pages may contain LOB data
- Only LOB data pages can be saved due to compression
LOB table space statistics
--------------------------------------------------------------------------------------
Current page size 4 KB
Number of LOBs 196 LOBs
Number of de-allocated LOBs 3 LOBs
Number of de-allocated pages 4 Pages
Minimum LOB size 490 Bytes
Maximum LOB size 63 KB
Average LOB size 10 KB
Histogram of LOB sizes (uncompressed) Count Percent
--------------------------------------------------------------------------------------
< 500b 42 21 %
--------------------------------------------------------------------------------------
500b to 1k 0 0 %
1k to 2k 0 0 %
2k to 3k 0 0 %
3k to 4k 56 29 %
--------------------------------------------------------------------------------------
4k to 5k 0 0 %
5k to 6k 40 20 %
6k to 7k 0 0 %
7k to 8k 0 0 %
--------------------------------------------------------------------------------------
8k to 10k 0 0 %
10k to 12k 0 0 %
12k to 14k 0 0 %
14k to 16k 0 0 %
--------------------------------------------------------------------------------------
16k to 20k 0 0 %
20k to 24k 0 0 %
24k to 28k 0 0 %
28k to 32k 56 29 %
--------------------------------------------------------------------------------------
> 32k 2 1 %
Uncompressed Table space from input
--------------------------------------------------------------------------------------
System Pages 217 Pages
Space Map pages 20 Pages
LOB Map pages 196 Pages
Data pages 406 Pages
De-allocated pages 4 Pages
Total pages 627 Pages
DSN1994I DSN1COMP COMPLETED SUCCESSFULLY, 2,520 PAGES PROCESSEDExternal compression dictionaries
External compression dictionaries are generated if all of the following conditions are true:
- The DSN1COMP options EXTNDICT (for an external fixed compression dictionary), EXTHDICT (for an external Huffman compression dictionary), or both are specified.
- The requested external dictionary type (fixed or Huffman) is generated by DSN1COMP. Either the type is specified in the COMPTYPE option or is the default value.
- The corresponding DD statement (DSN1DICT or DSN2DICT) is specified.
For example, if COMPTYPE (FIXED) or COMPTYPE(HUFFMAN) is specified, but both external dictionaries are requested (both EXTNDICT and EXTHDICT are specified), only the generated dictionary (the one requested in the COMPTYPE option) is externalized. Similarly, if COMPTYPE(ALL) is specified with only one external dictionary request (either EXTNDICT or EXTHDICT is specified), only the requested dictionary is externalized.
Message DSN1937I reports that an external dictionary was
generated:
DSN1937I DSN1COMP TXT-DECK (name) built 1,173 RECORDS WRITTEN
One DSN1937I message is generated for each DD statement (DSN1DICT or DSN2DICT) that was specified. If you specify a DSN1DICT or DSN2DICT DD statement, but the corresponding dictionary was not generated by DSN1COMP, this message indicates that 0 records were written to the output.
If the generated dictionary type does not match the requested external dictionary type, an error occurs. For example, if COMPTYPE(FIXED) is specified with EXTHDICT only or COMPTYPE(HUFFMAN) is specified with EXTNDICT only, message DSN1936I is returned with return code 8.