This report is similar to the type D report except that following the detail lines there is a first key value printed for each REFGROUP.
Date: mm/dd/ccyy ******************************************************************************** Page: 1 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** Directory: PRODCXX CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 Œ REPORT REFGROUP=2,DBID=2,TABLE=FLD,TYPE=K FUNCTION=REPORT DBID=00002 REFGROUP=00002 TABLE=FLD TYPE=K Ž
The command exactly as entered.
An analysis of keywords encountered and expected. Any errors found are flagged with a note in the left margin.
Any messages related to syntax processing.
Date: mm/dd/ccyy ******************************************************************************** Page: 2 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn Base: 2 ******************************************************************************** Directory: PRODCXX Table Block Usage Report by Reference Group ‘ ’ “ Hex Rows Ref 1 2 3 4 5 6 7 8 9 10+ 15+ 20+ 25+ 30+ 40+ 50+ Group Rows /Blk Blks Row Rows Rows Rows Rows Rows Rows Rows Rows Rows Rows Rows Rows Rows Rows Rows 1 55 27 2 . . . . . . . . . 1 . . . . 1 2 27 13 2 1 . . . . . . . . . . . 1 3 20 10 2 . 1 . . . . . . . . 1 4 20 10 2 1 . . . . . . . . . 1 5 6 3 2 . 1 . 1 6 23 11 2 1 . . . . . . . . . . 1 7 2 1 2 2 8 41 20 2 . . . . . . . . . 1 . . . 1 9 11 5 2 1 . . . . . . . . 1 A 79 39 2 . . . . . . . . . . . . . 1 1 B 42 21 2 . 1 . . . . . . . . . . . . 1 C 81 40 2 . . . . . . . . . . . . . . 2 D 15 7 2 1 . . . . . . . . 1 E 2 1 2 2 F 59 29 2 . . . . . . . . . . . 1 . 1 10 77 38 2 . . . . . . . . . . . . . 2 11 78 39 2 . . . . . . . . . . . . . 2 . . . AA743 36 18 2 . 1 . . . . . . . . . . . 1 AA744 38 19 2 . 1 . . . . . . . . . . . 1 AA745 35 17 2 1 . . . . . . . . . . . . 1 ” Groups------------------------------------------------Totals ---------------------------------------------------------- 698181 609,196 71,784 27,918 17,238 11,804 31,738 27,235 7,293 12,499,845 8 224,261 41,954 21,943 13,965 43,569 27,540 218,924 •
Hex Group is an ascending counter starting with 1 assigned to each REFRGOUP. It is a hexadecimal number.
Rows is the total number of rows in this REFGROUP.
Rows/Blk is the average rows per block for this REFGROUP.
Ref Blks shows the blocks in this REFGROUP. This is the same as the value coded for REFGROUP, except for the last REFGROUP.
1 Row through 50+ Rows has the same explanation as was provided in the TYPE=S REFGROUP report, except that the TYPE=D REFGROUP report is reported for each REFGROUP.
At the end of the TYPE=D REFGROUP report are the totals that summarize the report.
If a table is not defined with compression there is also a line below those shown in the example report. That line, "Maximum Possible Rows per Block," includes a number that can be used to help analyze the values printed for rows and to know how well ordered your data is by REFGROUP.
Date: mm/dd/ccyy ******************************************************************************** Page: 3 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn Base: 2 ******************************************************************************** Directory: PRODCXX Key Values by Reference Group Group First Key Value 1 FLDACCTS CDCCCCEE444444444444444444444444444000044444444444444444444 63413332000000000000000000000000000010000000000000000000000 2 FLDAGGREGATE AGR-REQRD CDCCCCDCCCEC44444444444444444444444000FCCD6DCDDC44444444444 63417795713500000000000000000000000062C17909589400000000000 3 FLDDATABASE DATABASE-USER CDCCCECCCEC4444444444444444444444440009CCECCCEC6EECD4444444 634413121250000000000000000000000000C1341312125042590000000 4 FLDDDMT3002 CDCCCDEFFFF444444444444444444444444000044444444444444444444 63444433002000000000000000000000000010A00000000000000000000 5 FLDDDMT5100 CDCCCDEFFFF444444444444444444444444000044444444444444444444 63444435100000000000000000000000000030000000000000000000000 6 FLDDIR_DATASET CDCCCD6CCECECE444444444444444444444000544444444444444444444 634499D4131253000000000000000000000010300000000000000000000 7 FLDFIELD CDCCCCDC444444444444444444444444444010D44444444444444444444 63469534000000000000000000000000000011C00000000000000000000 . . .
This last page of a TYPE=K report is where it differs from a TYPE=D REFGROUP report, in that following the detail lines there is a first key value printed for each REFGROUP. The hexadecimal group number is printed so that you can correlate this with the statistics for a particular REFGROUP. This can be useful if you later choose to run an OLREORG report against only part of the table using either FIRSTKEY or LASTKEY or both.
The actual key values print in character form. Optionally, if there is non-character data, two lines with the hexadecimal values for this key are printed. The key value printed is limited to 59 bytes and is then truncated. This matches the limitations on FIRSTKEY and LASTKEY.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|