Print owner statistics (DISPLAY TABLE FOR OWNER)

---

DISPLAY [IN CSV [csv-filename]] TABLE STATISTICS FOR OWNER IN SET

{set-name-1[rsq-selection-1] ,... | *ALL[ EXCEPT set-name-1,...]}


---

IN CSV

BSTATUS also outputs the data in CSV format.

csv-filename
Name of the file to which the data is to be output in CSV format. The specification of csv-filename is mandatory in the first IN CSV statement of a BSTATUS run (e.g. DISPLAY IN CSV 'BSTATUS.CSV' ...).

For a detailed description of CSV format output, see the manual “Database Operation”, section “Outputting database information in a neutral format”.

set-name

Name of a set for whose owner statistics are output

rsq-selection

rsq-selection = { ALL RSQS | RSQ {rsq-1[ TO rsq-2]},... }

1 <= RSQ <= 2²⁴-2¹⁶- 1
For databases with a page length of 2048 bytes if the record type is an owner in a set.

1 <= RSQ <= 2³¹-1
For databases with a page length of 4000/8096 bytes.

*ALL      

Statistics are to be printed for all owner record types of the subschema

*ALL EXCEPT set-name-1,...

Statistics are to be printed for all sets other than set-name.

The DISPLAY TABLE FOR OWNER statement prints out statistics on the storage space occupied by the tables of the owner records of a set.

This output may be very large since, unlike the other statements, its scope does not depend only on the metadata population but also on the user data population.

Example

1. DISPLAY TABLE STATISTICS FOR OWNER IN SET P-ORD-SPEC RSQ 1 TO 5

    *-------------------*------------*-------------------------------------*
    |                   |            |          TABLE STATISTICS           |
    |                   |   MEMBER   *-----*---------------*-----*---------*
    |     OWNER DBK     |   OCCUR-   | COL | FILLING RATIO | LEV |         |
    |                   |   RENCE    |     *-------*-------*     |  REORG  |
    |                   |            | NR  | LEV=0 | LEV>0 | NR  |         |
    *-------------------*------------*-----*-------*-------*-----*---------*
    |     8:          1 |          7 |   1 |    47 |     0 |   0 |    -    |
    *-------------------*------------*-----*-------*-------*-----*---------*
    |     8:          2 |          6 |   1 |    41 |     0 |   0 |    -    |
    *-------------------*------------*-----*-------*-------*-----*---------*
    |     8:          3 |          2 |   1 |    14 |     0 |   0 |    -    |
    *-------------------*------------*-----*-------*-------*-----*---------*
    |     8:          4 |          2 |   1 |    14 |     0 |   0 |    -    |
    *-------------------*------------*-----*-------*-------*-----*---------*
    |     8:          5 |          2 |   1 |    14 |     0 |   0 |    -    |
    *-------------------*------------*-----*-------*-------*-----*---------* 

   BSTATUS prints a separate table for each set.

   OWNER DBK

   Database key of the owner record in the format: (recref: rsq)

   MEMBER OCCURRENCE

   Number of members of the set occurrence specified by OWNER DBK
   0: No member records stored; but table has been set up

   TABLE STATISTICS

   Information on all tables of the set occurrence
   (pointer array, list or sort key table and SEARCH key tables)

   COL NR
   Column number in the owner DBTT containing the address of the corresponding table

   FILLING RATIO
   Table occupancy level, expressed as a percentage of all bytes reserved for the table;

   LEV=0:

   Table occupancy level on index level 0 (main level):

   0: Tables have been set up, but no member records have been stored. For duplicates tables the occupancy level is always greater than 0, even in the case of empty set occurrences.

   LEV>0:

   Table occupancy level on all index levels (excluding main level)

   LEV NR
   Number of index levels (excluding main level)

   
   

   REORG

   Indicates whether the number of index levels can be reduced by reorganization.

   YES:    

   the number of index stages can be reduced with the aid of the statement 

   REORGANIZE SETNAME IS set-name FILLING IS 100 PERCENT

   in the BREORG utility

   NO:

   it is not possible to reduce the number of index stages

   -:

   the table has only one level (main level), so it is only possible to increase table occupancy

2. In case of a user specifying an owner RSQ or a range of RSQs, although these RSQs do not exist in the database, the user gets a message:

   DISPLAY TABLE FOR OWNER IN SET P-ORD-SPEC RSQ 2

   NO MATCHING RSQS: There is no record with RSQ 2 in the database.

    *-------------------*------------*-------------------------------------*
    |                   |            |          TABLE STATISTICS           |
    |                   |   MEMBER   *-----*---------------*-----*---------*
    |     OWNER DBK     |   OCCUR-   | COL | FILLING RATIO | LEV |         |
    |                   |   RENCE    |     *-------*-------*     |  REORG  |
    |                   |            | NR  | LEV=0 | LEV>0 | NR  |         |
    *-------------------*------------*-----*-------*-------*-----*---------*
    |                  ***** N O   M A T C H I N G   R S Q S *****         |
    *-------------------*------------*-----*-------*-------*-----*---------*