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=1022,RECORDS=01000 FUNCTION=REPORT DBID=01022 RECORDS=00001000 TABLE=REO TYPE=DATANE
This page of the report shows the following:
TBL AREA KEY CMP USER COMPRESSION RECLN RECORDS BLKSIZE TRACKS TOT BLKS INUSE BLKS PART BLKS REO REO REOK1 N 112 31,950 4,096 150 1,800 890 1 CALC MAX ROWS/BLOCK 36
This page of the report shows the following information about the table that is being processed:
Displays the heading for the columns containing information describing the selected data table.
Displays the maximum row per block (MRB) which was calculated by dividing the expanded row size plus RCE (record control element) into the data block size.
The next 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 27 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 122 17 1 8 122 23 2 1,000 178 16 1 6 177 16 3 1,000 266 17 1 4 272 10 16 17 4 1,000 256 19 1 4 261 11 12 13 20 5 1,000 293 14 1 3 292 9 10 11 6 1,000 193 26 1 5 192 15 16 19 42 7 1,000 185 13 1 5 184 15 17 8 1,000 194 36 1 5 193 15 9 1,000 138 36 1 7 137 21 35 10 1,000 241 15 1 4 263 11 12 16 11 1,000 209 16 1 5 252 11 16 12 1,000 204 10 1 5 203 14 18 13 1,000 214 36 1 5 213 13 14 1,000 47 36 4 21 46 63 15 1,000 267 19 1 4 307 9 10 14 16 1,000 221 15 1 5 243 11 12 13 17 1,000 304 14 1 3 304 9 13 18 1,000 190 11 1 5 189 15 19 1,000 299 8 1 3 299 9 20 1,000 226 16 1 4 241 12 21 1,000 165 15 1 6 174 16 18 22 1,000 240 25 1 4 293 9 10 11 13 23 1,000 188 12 1 5 187 15 16 24 1,000 101 28 1 10 173 16 17 29 37 25 1,000 243 20 1 4 245 11 12 26 1,000 232 17 1 4 240 12 27 1,000 230 34 1 4 251 11 14 28 1,000 231 13 1 4 231 12 29 1,000 137 24 1 7 178 16 18 24 30 1,000 154 16 1 6 159 18 19 100 31 1,000 282 13 1 4 288 10 11 32 950 122 32 1 8 122 22 ________________________________________________________________________________________________________________________ FULL TABLE MRB 31,950 888 36 18 36 6,931 13 14 16 AMRB 31,950 888 36 18 36 6,931 13 14 16
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.
The following lines display the detail line area of the report. Because RECORDS=1000 is specified, there is one line of output for each group of 1000 rows.
Displays the group number being processed. The group number begins at 1 and increments until it reaches 99,999 groups. If this number of groups is reached, the report continues with the next group number being with zero.
Note: Each group is processed autonomously from the other rows in the table. The goal is to establish efficiency for this group of rows. When a data block has 30 rows but only 15 rows are from this group, only those 15 rows are recognized and the rest of the rows in the block are ignored. This fact must be remembered when you are evaluating the statistical values in the columns. You cannot assume that the detail group line values add up to match the FULL TABLE summary values.
Displays the number of rows in the group.
Displays the number of data blocks that contained at least one data row for this group.
Displays an evaluation for each group. Identifies the high-level mark (MAX ROWS) and the low-level mark (MIN ROWS). The report also divides the total rows of the group by the blocks with data rows for the group to calculate the average rows (AVG. ROWS).
Displays the number of changes that would occur when the groups data rows were processed using the selected key sequence (chosen using KEYNAME=). A BLOCK CHANGE is counted each time the next row in the sequence is not within the same block as the current row.
The BLOCK CHANGES is the key factor in measuring sequential efficiency. When a table is in sequential order, all data rows are processed in a given data block before moving on to the next block. When rows are not in order, the sequential process bounces back and forth between data blocks to retrieve all data rows in the selected key sequence. This bouncing back and forth adds overhead and delays to any process that is reading the data in sequential order.
Indicates the MRB efficiency which is calculated by taking the ideal situation where all data blocks are only processed once as data rows are read sequentially in the group (PBC 27) and dividing that by the actual number of block changes that actually occurred.
Displays the calculated MRB efficiency with buffers. Because buffering can significantly reduce the physical I/O used to read a previously read data block back into storage, the MRB efficiency percentage is recalculated using two buffers, four buffers, and so on.
Summarizes the report. Two lines are created for the table. This information was described earlier in this section.
Note: The detail group lines treat each group autonomously and generate their statistical calculations based on that group. The total or summary lines look at the table as a whole and their statistical calculations are based on the whole table. You cannot assume that the detail group line values add up to match the FULL TABLE summary values.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|