bdfu1m0zUtilities

ZRECP STA-Display Statistical Data

Use this command to display statistics for a file with a specified file ID (and file version number).

Requirements and Restrictions

None.

Format




fileid
is a 2-character alphanumeric or 4-character hexadecimal file ID. If you do not specify the ALL parameter, statistics for this file ID are displayed from the last recoup.

filever
is the file version of the file ID, which is a hexadecimal number from X'00' to X'FF'.

ALL
displays all the available statistics for the file ID.

VAL
displays, without any additional parameters, the criteria available to select statistics. With additional parameters, statistics meeting the conditions specified are displayed.

crit
is the criteria used to select recoup statistics. You can display a criteria list by entering ZRECP STA VAL without additional parameters.

condition
is specified by the following:

H
Higher (greater) than

E
Equal

L
Lower (less) than.

numval
is the numerical value specified to compare against the condition.

Additional Information

When you request statistics for files that are referenced with recoup chain-chasing indicator (RCI) IDs, the display will be different depending on whether there was a full recoup or a selective recoup done for those IDs.

Examples

The following example displays the statistics for a B+Tree data file (file ID FDED) and an associated B+Tree index file (file ID BBBB). The B+Tree file has 8000 data blocks and 421 nodes. File version 00 of FDED shows the statistics for the prime block. It shows one block (the prime block). File version 01 of FDED shows that 7999 overflow data blocks have been chain chased. File version 00 of BBBB shows the statistics for the node blocks.

Note:
The statistics for a B+Tree file may vary depending on how the database administrator defines chain chasing.
+--------------------------------------------------------------------------------+
|User:   ZRECP STA FDED                                                          |
|                                                                                |
|System: RECP0101I          ZRECP STATISTICS DISPLAY                             |
|        RECOUP  28MAY97  14.19.23  -  ID-FDED    TOTAL COUNT: 00000026          |
|        --------------------------------------------------------------          |
|         FDED 00 BLOCKS  P/00000001  F/00000001  E/00000000  X/00000000         |
|                 CHAINS  1/00000000  2/00000000  3/00000000  4/00000000         |
|                         5/00000000  6/00000000  7/00000000  8/00000000         |
|                         9/00000000  M/00000000  MAX/000000  A/00000000         |
|                 USAGE F 0/000000 25/000000 50/000000 75/000001 PCT/096         |
|                 USAGE N 0/000000 25/000000 50/000000 75/000000 PCT/000         |
|                 ITEMS   T/00000076 F/000076 B/000002 ITS/0001 PNB/0016         |
|                                                                                |
|         BBBB 00 BLOCKS  P/00000001  F/00000421  E/00000000  X/00000000         |
|                 CHAINS  1/00000000  2/00000000  3/00000000  4/00000000         |
|                         5/00000000  6/00000000  7/00000000  8/00000000         |
|                         9/00000000  M/00000001  MAX/000420  A/802B650B         |
|                 USAGE F 0/000000 25/000000 50/000000 75/000420 PCT/095         |
|                 USAGE N 0/000000 25/000000 50/000000 75/000001 PCT/095         |
|                 ITEMS   T/00008420 F/008420 B/000002 ITS/0001 PNB/0016         |
|                                                                                |
|         FDED 01 BLOCKS  P/00000001  F/00008000  E/00000000  X/00000000         |
|                 CHAINS  1/00000000  2/00000000  3/00000000  4/00000000         |
|                         5/00000000  6/00000000  7/00000000  8/00000000         |
|                         9/00000000  M/00000001  MAX/007999  A/80080330         |
|                 USAGE F 0/000000 25/000000 50/000000 75/007999 PCT/096         |
|                 USAGE N 0/000000 25/000000 50/000000 75/000001 PCT/096         |
|                 ITEMS   T/00608000 F/608000 B/000002 ITS/0001 PNB/0016         |
+--------------------------------------------------------------------------------+

The fields in the ZRECP STA fileid display provide the following information:

 BLOCKS 
Shows the following:

 P/ 
Number of prime blocks.

 F/ 
Total number of blocks (prime and overflow).

 E/ 
Error count (the number of prime blocks with broken chains).

 X/ 
Number of fixed errors.

 CHAINS 
Shows the following:

 1/ 
Prime blocks with one overflow block.

 2/ 
Prime blocks with two overflow blocks.

 3/ 
Prime blocks with three overflow blocks.

 4/ 
Prime blocks with four overflow blocks.

 5/ 
Prime blocks with five overflow blocks.

 6/ 
Prime blocks with six overflow blocks.

 7/ 
Prime blocks with seven overflow blocks.

 8/ 
Prime blocks with eight overflow blocks.

 9/ 
Prime blocks with nine overflow blocks.

 M/ 
Prime blocks with more than nine overflow blocks.

 MAX/ 
Number of overflow blocks in the longest chain.

 A/ 
The file address of the prime block that has the largest number of overflow blocks (specified by MAX/).

The following display is only generated for a TPFDF file:

 USAGE F 
Provides statistics about the use of all blocks (prime and overflow) that have an overflow block attached through the forward chain field.

 0/ 
Number of blocks 0 to 25% filled.

 25/ 
Number of blocks 25 to 50% filled.

 50/ 
Number of blocks 50 to 75% filled.

 75/ 
Number of blocks 75 to 100% filled.

 PCT/ 
The average use (in percentage) of all blocks associated with a file.

Note:
USAGE N provides the same type of information as USAGE F, except it applies to the last blocks in the overflow chains.

 ITEMS 
Provides information about the LRECs in a TPFDF file:

 T/ 
Total number of LRECs.

 F/ 
Average number of LRECs in a subfile (calculated as T/ divided by P/).

 B/ 
Average number of LRECs in each block (calculated as T/ divided by F/).

 ITS/ 
LREC size, as defined in the file's DSECT. A value of 1 indicates that the LREC is of variable length.

 PNB/ 
Position of next available byte (NAB) pointer.

The following example displays the keywords available to specify criteria for selecting recoup statistics:

+--------------------------------------------------------------------------------+
|User:   ZRECP STA VAL                                                           |
|                                                                                |
|System: RECP9010I          STATISTICS VALIDATION PARAMETERS                     |
|                                                                                |
|        P    NR OF PRIME BLOCKS         F    NR OF FOUND BLOCKS                 |
|        E    NUMBER OF ERRORS           X    FIX ERROR COUNT                    |
|        1    NR OF FILES WITH 1 CHAIN   2    NR OF FILES WITH 2 CHAINS          |
|        3    NR OF FILES WITH 3 CHAINS  4    NR OF FILES WITH 4 CHAINS          |
|        5    NR OF FILES WITH 5 CHAINS  6    NR OF FILES WITH 6 CHAINS          |
|        7    NR OF FILES WITH 7 CHAINS  8    NR OF FILES WITH 8 CHAINS          |
|        9    NR OF FILES WITH 9 CHAINS  M    NR OF FILES WITH MT 9 CH.          |
|        MAX  MAXIMUM NR OF CHAINS       A    MAX CHAIN FILE ADDRESS             |
|        F0   BLOCKUSAGE 0-25PCT FWCH    F25  BLOCKUSAGE 25-50PCT FWCH           |
|        F50  BLOCKUSAGE 50-75PCT FWCH   F75  BLOCKUSAGE 75-100PCT FWCH          |
|        N0   BLOCKUSAGE 0-25PCT NOFCH   N25  BLOCKUSAGE 25-50PCT NOFCH          |
|        N50  BLOCKUSAGE 50-75PCT NOFCH  N75  BLOCKUSAGE 75-100PCT NFCH          |
|        T    TOTAL NR OF LRECS          ITS  TPFDF LREC SIZE                    |
|        PNB  POSITION OF NAB            LB   NR OF LRECS PER BLOCK              |
|        LF   NR OF LRECS PER FILE       NPC  AVERAGE BLOCKUSAGE NOFCH           |
|        FPC  AVERAGE BLOCKUSAGE FCH                                             |
+--------------------------------------------------------------------------------+

The following example displays statistics for all recoup runs in the statistics file for version 0 of file B075.

+--------------------------------------------------------------------------------+
|User:   ZRECP STA ALL-B0750                                                     |
|                                                                                |
|System: RECOUP  29MAY97  17.30.57  -  ID-B075    TOTAL COUNT: 00000128          |
|        --------------------------------------------------------------          |
|                                                                                |
|        B075 00 BLOCKS  P/00000026  F/00000128  E/00000000  X/00000000          |
|                CHAINS  1/00000000  2/00000000  3/00000001  4/00000000          |
|                        5/00000000  6/00000000  7/00000000  8/00000000          |
|                        9/00000000  M/00000003  MAX/000033  A/F404F8D0          |
|                USAGE F 0/000000 25/000069 50/000000 75/000033 PCT/049          |
|                USAGE N 0/000025 25/000001 50/000000 75/000000 PCT/008          |
|                ITEMS   T/00000310 F/000011 B/000002 ITS/0001 PNB/0016          |
+--------------------------------------------------------------------------------+

The following example displays all files processed during TPFDF recoup that have more than four LRECs in the file.

+--------------------------------------------------------------------------------+
|User:   ZRECP STA VAL T-H-4                                                     |
|                                                                                |
|System: THESE RECOUP STATISTICS MATCH                                           |
|        TOTAL NR OF LRECS HIGHER THAN 4                                         |
|                                                                                |
|        ID   FVN         T    ID   FVN         T    ID   FVN         T          |
|        ---- ---  --------    ---- ---  --------    ---- ---  --------          |
|        B075  00       425    FDA5  00        25    FDA4  00        50          |
|        FDF3  00        35    FD03  00      1142    FDF5  00         4          |
|        FDF6  00        22    FD00  00        23                                |
+--------------------------------------------------------------------------------+

References