Following are sample report pages. For an example report header, see Sample Report Headers.
CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 REPORT TYPE=DATANE,TABLE=REO,DBID=1023,RECORDS=01000, NUMBER=0200 FUNCTION=REPORT DBID=01023 NUMBER=0200 RECORDS=00001000 TABLE=REO TYPE=DATANE
This page of the report shows the NUMBER=0200 parameter has been specified to limit the physical blocks scanned to determine the MRB value. The scan is only done when a table has compression. This page also shows the following:
The second page of the report is similar to what you have seen earlier in this section. However, note the following specific differences.
TBL AREA KEY CMP USER COMPRESSION RECLN RECORDS BLKSIZE TRACKS TOT BLKS INUSE BLKS PART BLKS REO REO REOK1 Y 100 31,950 4,096 150 1,800 2 0 SCAN MAX ROWS/BLOCK 108 #ROWS READ 18,260
Indicates that this table is compressed. Because the USER COMPRESSION field is blank, we know that this table is compressed using CA Datacom/DB standard compression.
Indicates that a physical scan of the data blocks was used to determine the MRB value. The number of blocks scanned was specified in the NUMBER=0200 parameter. In scanning the first 200 data blocks, the MRB value was determined to be 108.
Indicates that, in scanning the first the 200 data blocks, the report encountered 18,260 data rows.
The third and following pages of the detail report provide the efficiency ratings for each group of records. At the end of the report, the FULL TABLE summary lines are generated.
*--- BLOCK --* PBC 9 MRB *---- MAX ROW/BLK EFFICIENCY RATES WITH BUFFERS ----* GROUP ROWS BLOCKS MAX MIN AVG BLOCK EFF 2 4 8 12 16 20 24 28 32 48 64 96 128 256 READ W/DATA ROWS ROWS ROWS CHANGES % % % % % % % % % % % % % % % 1 1,000 113 38 2 9 113 7 2 1,000 152 18 1 7 151 5 3 1,000 93 30 2 11 103 8 9 81 4 1,000 85 34 1 12 106 8 10 14 5 1,000 62 48 1 16 61 14 6 1,000 81 74 2 12 80 11 15 56 7 1,000 155 21 1 6 154 5 10 8 1,000 116 25 1 9 123 7 15 9 1,000 90 39 1 11 110 8 9 10 25 10 1,000 56 43 5 18 56 16 11 1,000 66 26 1 15 65 13 21 12 1,000 139 22 1 7 138 6 15 13 1,000 170 22 1 6 169 5 14 1,000 99 42 1 10 100 9 10 12 50 15 1,000 54 60 1 19 53 16 18 19 16 1,000 59 26 1 17 58 15 16 17 1,000 111 32 1 9 111 8 56 18 1,000 138 40 1 7 137 6 7 19 1,000 86 43 2 12 93 9 10 100 20 1,000 86 33 1 12 113 7 8 9 11 14 21 1,000 66 49 1 15 65 13 22 1,000 108 27 1 9 107 8 50 23 1,000 126 18 1 8 125 7 8 24 1,000 110 54 1 9 109 8 24 25 1,000 93 57 1 11 94 9 11 14 25 26 1,000 79 31 1 13 78 11 14 27 1,000 91 24 1 11 90 10 20 28 1,000 119 21 1 8 119 7 11 29 1,000 124 36 1 8 123 7 11 30 1,000 90 33 1 11 90 10 11 13 69 31 1,000 94 31 1 11 93 9 10 12 32 950 56 27 5 17 55 16 ________________________________________________________________________________________________________________________ FULL TABLE MRB 31,950 387 108 36 83 3,242 9 10 15 AMRB 31,950 387 108 36 83 3,242 11 12 13 20
Displays the PERFECT BLOCK CHANGE (PBC) count for the selected group of records (1000). The PBC is the number of block changes that would occur if a table was loaded with a group (1000) of rows in sequential order and all blocks had the maximum number of rows per block. A compressed table allows more rows to fit per block as evidenced by the increased MRB (from 36 to 108), which in turn lowers the PBC value.
The rest of the entries on the report were described in the previous samples.
|
Copyright © 2014 CA.
All rights reserved.
|
|