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)