表スペースの圧縮計算におけるフリー・スペース
DSN1COMP ユーティリティーは圧縮見積もりを作成します。圧縮見積もりでは、PCTFREE オプションと FREEPAGE オプションが考慮されます。
入力表スペースの作成時の値と異なる値を PCTFREE または FREEPAGE に使用すると、 noncmppages は違う値になります。 DSN1COMP は、以下の図の出力例に示されているように、メッセージ DSN1940I でこの値を報告します。
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)