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.

Related information:

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
Start of change

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              

End of change
Start of change

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      
End of change