DISPLAY
[IN CSV [csv-filename]] TABLE STATISTICS FOR SET
{
set-name-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 the set for which statistics are to be printed
*ALL
Statistics on all sets of the subschema are to be printed
*ALL EXCEPT set-name-1,...
Statistics are to be printed for all sets other than those named at set-name.
Example
DISPLAY TABLE STATISTICS FOR SET *ALL
*--------------------------------*-----------*-----------------------------------*-------------------------------------------------* | | | | TABLE STATISTICS | | | OWNER | MEMBER OCCURRENCE *-----*---------------*---------------*-----------* | SET IDENTIFICATION | OCCUR- | | COL | FILLING RATIO | LEVEL NR | NR OCCUR- | | | RENCE *-----------*-----------*-----------* *-------*-------*-------*-------* RENCES TO | | | | MIN | MAX | AVG | NR | LEV=0 | LEV>0 | MAX | AVG | REORGANIZE| *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | CST-ORD-PLACED | ***** E M P T Y S E T ***** |.. *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | OFFER | 4 | 1 | 8 | 3 | 1 | 5 | 0 | 0 | 0,0 | 0 | *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | SHORT-LIST | 5 | 1 | 6 | 2 | 1 | 4 | 0 | 0 | 0,0 | 0 | *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | P-ORD-SPEC | 13 | 1 | 7 | 4 | 1 | 33 | 0 | 0 | 0,0 | 0 | *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | MIN-STOCK-LEVEL | SINGULAR | | | 0 | 1 | 0 | 0 | | 0 | 0 | *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | CONTAINING | ***** E M P T Y S E T ***** | *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | CONTAINED-IN | ***** E M P T Y S E T ***** | *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | SUPPLIERS | SINGULAR | | | 1 | 1 | 2 | 0 | | 0 | 0 | *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | ARTICLES-AVAILABLE | 1 | 63 | 63 | 63 | 1 | 80 | 0 | 0 | 0,0 | 0 | | | | | | | | | | | | | | | | | | | 2 | 10 | 0 | 0 | 0,0 | | *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------*.. *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | P-ORD-CONTENTS | ***** E M P T Y S E T ***** | *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | RESULT-SET | ***** D Y N A M I C S E T ***** |.. *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | SYS_INSTALMENT | SINGULAR | | | 0 | 1 | 1 | 0 | | 0 | 0 | *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | SYS_ART-TYPE | SINGULAR | | | 4 | **** CHAIN SET WITHOUT TABLES **** | 0 | *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | SYS_ART-SELECTION | SINGULAR | | | 5 | 1 | 5 | 0 | | 0 | 0 | *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | SYS_ARTICLE | SINGULAR | | | 63 | **** CHAIN SET WITHOUT TABLES **** | 0 | *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | SYS_COLORS | SINGULAR | | | 25 | **** CHAIN SET WITHOUT TABLES **** | 0 | *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | SYS_MATERIALS | SINGULAR | | | 10 | 1 | 3 | 0 | | 0 | 0 | | | | | | | | | | | | | | | | | | | 2 | 8 | 0 | | 0 | | *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------* | IMPLICIT_RESULT_SET | ***** D Y N A M I C S E T ***** | *--------------------------------*-----------*-----------*-----------*-----------*-----*-------*-------*-------*-------*-----------*
BSTATUS does not print statistics for dynamic sets or for sets for which there are no set occurrences. Such sets are indicated as an *EMPTY SET*.
SET IDENTIFICATION
Name of set in schema
OWNER OCCURRENCE
Number of occurrences of the set
SINGULAR: SYSTEM set
MEMBER OCCURRENCE
Number of stored member records in the set
MIN:
Number of member records in the smallest set occurrence
MAX:
Number of member records in the largest set occurrence
AVG:
Average number of member records per set
TABLE STATISTICS
Information on the tables in the set
(pointer arrays, sort key tables or SEARCH key tables)
If the set does not have any tables, the following message is printed:
**** CHAIN SET WITHOUT TABLES ****
COL NR
Column numbers in the owner DBTT containing the address of the given table
FILLING RATIO
Table occupancy level, expressed as a percentage of all bytes reserved for the table;
LEV=0:
Average table occupancy on index level 0 (main level)
0: Tables are set up, but no member records stored (empty set occurrence). For duplicates tables the occupancy level is always greater than 0, even in the case of empty set occurrences.
LEV>0:
Average table occupancy on all index levels (main level not included)
LEVEL NR
Number of index levels in set (main level not included)
MAX:
Highest index level in any table in a set occurrence
AVG:
Average number of index levels in set
NR OCCURRENCES TO REORGANIZE
Number of set occurrences for which BREORG can be used to reduce the number of index levels; applies to any reorganization using the statement
REORGANIZE SET NAME IS set-name FILLING IS 100 PERCENT