Free space in compression calculations on table space

The DSN1COMP utility considers the PCTFREE and FREEPAGE values when making compression estimates.

If you specify PCTFREE or FREEPAGE values for DSN1COMP that are different than the values that were specified in the SQL to create or alter the table space, you get a different value for noncmppages. DSN1COMP reports this value in message DSN1940I, as shown in the following example output:

DSN1999I START OF DSN1COMP FOR JOB TST512A  STEP1                      
DSN1998I INPUT DSNAME = FUFOU237.TSP32K                             , SEQ
DSN1944I DSN1COMP INPUT PARAMETERS                                      
             512  DICTIONARY SIZE USED                                  
              30  FREEPAGE VALUE USED                                   
              45  PCTFREE VALUE USED                                    
                  NO ROWLIMIT WAS REQUESTED                             
                  ESTIMATE BASED ON DB2 LOAD METHOD                     
                                                                        
DSN1940I DSN1COMP COMPRESSION REPORT                                    
           1,289  KB WITHOUT COMPRESSION                                
             717  KB WITH COMPRESSION                                   
              44  PERCENT OF THE BYTES WOULD BE SAVED                   
                                                                        
             176  ROWS SCANNED TO BUILD DICTIONARY                      
          20,000  ROWS SCANNED TO PROVIDE COMPRESSION ESTIMATE          
             512  DICTIONARY ENTRIES                                    
                                                                        
               1  DICTIONARY PAGES REQUIRED                             
             147  PAGES REQUIRED WITHOUT COMPRESSION                    
             148  PAGES REQUIRED WITH COMPRESSION                       
               0  PERCENT OF THE DB2 DATA PAGES WOULD BE SAVED          
                                                                        
   *** DETAIL REPORT OF FREQUENCIES AND AVERAGES ***                    
                                                                        
     1 CHILD CHARACTER WAS COMPARED                            566,764  TIMES 
     2 CHILD CHARACTERS WERE COMPARED                          182,026  TIMES 
     3 CHILD CHARACTERS WERE COMPARED                           10,300  TIMES 
     5 CHILD CHARACTERS WERE COMPARED                            1,129  TIMES 
     TOTAL ALPHABET NODE COMPARISONS                           528,139  TIMES 
                                                                        
                  967,361  CHILD COMPARISONS IN THE SIBLING LISTS       
                  760,219  SEARCHES IN THE SIBLING LISTS                
                      1.2  AVERAGE NUMBER OF COMPARISONS PER SEARCH     
              60  BYTES FOR AVERAGE UNCOMPRESSED ROW LENGTH             
              39  BYTES FOR AVERAGE COMPRESSED ROW LENGTH               
                                                                      
             263  IS THE DATABASE ID (DBID)                             
               2  IS THE PAGESET  ID (PSID)