DSN1COMP output
The DSN1COMP utility generates a report that includes the estimated space savings that can be achieved by using compression.
Message DSN1941
If you receive this message, use a data set with more rows as input, or specify a larger value for ROWLIMIT.
Sample DSN1COMP report for a table space
The following output shows a sample of the table space report that is generated by DSN1COMP:
DSN1940I DSN1COMP COMPRESSION REPORT
301 KB WITHOUT COMPRESSION
224 KB WITH COMPRESSION
25 PERCENT OF THE BYTES WOULD BE SAVED
1,975 ROWS SCANNED TO BUILD DICTIONARY
4,665 ROWS SCANNED TO PROVIDE COMPRESSION ESTIMATE
4,096 DICTIONARY ENTRIES
81 BYTES FOR AVERAGE UNCOMPRESSED ROW LENGTH
52 BYTES FOR AVERAGE COMPRESSED ROW LENGTH
16 DICTIONARY PAGES REQUIRED
110 PAGES REQUIRED WITHOUT COMPRESSION
99 PAGES REQUIRED WITH COMPRESSION
10 PERCENT OF THE DB2 DATA PAGES WOULD BE SAVED
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
LOB table space statistics
---------------------------------------------------------
Number of LOBs 15 LOBs
Minimum LOB size 5 KB
Maximum LOB size 148 KB
Average LOB size 59 KB
LOB compression ratio
---------------------------------------------------------
Total LOB data compressed 656 KB
Total LOB data uncompressed 887 KB
Percentage of KB saved 27 %
Minimum System pages required 36 Pages
Data pages needed for compressed LOB table space 149 Pages
Data pages needed for uncompressed LOB table space 210 Pages
Percentage of Data pages saved 30 %
Current page size 4 KB
EVALUATION OF COMPRESSION WITH DIFFERENT PAGE SIZES
Note: System Pages may contain LOB data!
---------------------------------------------------------
4K page size:
Minimum System pages required 36 Pages
Additional Data pages needed for compressed LOBs 149 Pages
Additional Data pages needed for uncompressed LOBs 210 Pages
Data pages saved (not including system pages) 30 %
8K page size:
Minimum System pages required 36 Pages
Additional Data pages needed for compressed LOBs 81 Pages
Additional Data pages needed for uncompressed LOBs 102 Pages
Data pages saved (not including system pages) 21 %
16K page size:
Minimum System pages required 36 Pages
Additional Data pages needed for compressed LOBs 41 Pages
Additional Data pages needed for uncompressed LOBs 49 Pages
Data pages saved (not including system pages) 17 %
32K page size:
Minimum System pages required 36 Pages
Additional Data pages needed for compressed LOBs 20 Pages
Additional Data pages needed for uncompressed LOBs 20 Pages
Data pages saved (not including system pages) 0 %
DSN1994I DSN1COMP COMPLETED SUCCESSFULLY, 2,520 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
LOB table space statistics
---------------------------------------------------------
Number of LOBs 15 LOBs
Minimum LOB size 5 KB
Maximum LOB size 148 KB
Average LOB size 28 KB
Table space with compression (in KB)
---------------------------------------------------------
Total uncompressed data 0 KB
Total compressed data 241 KB
Total LOB data 241 KB
Table space if uncompressed (in KB)
---------------------------------------------------------
Total uncompressed data 428 KB
Total compressed data 0 KB
Total LOB data 428 KB
LOB compression ratio
---------------------------------------------------------
Total LOB data compressed 241 KB
Total LOB data uncompressed 428 KB
Percentage of KB saved 44 %
Minimum System pages required 36 Pages
Data pages needed for compressed LOB table space 47 Pages
Data pages needed for uncompressed LOB table space 95 Pages
Percentage of Data pages saved 51 %
Current page size 4 KB
EVALUATION OF COMPRESSION WITH DIFFERENT PAGE SIZES
Note: System Pages may contain LOB data!
---------------------------------------------------------
4K page size:
Minimum System pages required 36 Pages
Additional Data pages needed for compressed LOBs 47 Pages
Additional Data pages needed for uncompressed LOBs 95 Pages
Data pages saved (not including system pages) 51 %
8K page size:
Minimum System pages required 36 Pages
Additional Data pages needed for compressed LOBs 23 Pages
Additional Data pages needed for uncompressed LOBs 45 Pages
Data pages saved (not including system pages) 49 %
16K page size:
Minimum System pages required 36 Pages
Additional Data pages needed for compressed LOBs 7 Pages
Additional Data pages needed for uncompressed LOBs 18 Pages
Data pages saved (not including system pages) 62 %
32K page size:
Minimum System pages required 36 Pages
Additional Data pages needed for compressed LOBs 3 Pages
Additional Data pages needed for uncompressed LOBs 4 Pages
Data pages saved (not including system pages) 25 %
DSN1994I DSN1COMP COMPLETED SUCCESSFULLY, 2,520 PAGES PROCESSED
