DISPLAY [IN CSV [csv-filename]] CALC KEY STATISTICS FOR
{RECORD {record-name-1,... | ALL} | SEARCHKEY {keyref-1,... | ALL}}
IN REALM {realmname-1,... | ALL}
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”.
RECORD
BSTATUS prints CALC key statistics for record types defined with LOCATION
MODE IS CALC
record-name
Name of a record type for which BSTATUS is to print out the CALC key statistics
ALL
BSTATUS prints CALC key statistics for all record types which have been defined with LOCATION MODE IS CALC in the specified subschema
SEARCHKEY
BSTATUS prints the CALC key statistics for the hash areas of CALC SEARCH keys defined on record type or set level
keyref
Number of the CALC SEARCH key whose CALC key statistics are to be printed by BSTATUS.
The numbers can be taken from the SIA PRINT REPORT (see "CALC-SEARCH-KEY INFORMATION")
ALL
BSTATUS prints CALC key statistics for all hash areas of CALC SEARCH keys that are contained in the subschema
REALM
BSTATUS prints CALC key statistics for one or more realms
realmname
Name of a realm for which BSTATUS is to print out the CALC key statistics
ALL
BSTATUS prints CALC key statistics for all realms
Example
DISPLAY CALC SEARCHKEY 12,14,15,16,17 IN REALM ARTICLE-RLM.
STATUS OF CALC KEY BUCKETS - PER CALC KEY R E A L M : ARTICLE-RLM *----------------------------------------------------------------------------------------------------------------------------* | | | RECORDS/ | | FILLING | | RECORDS/ | FILLING | DEPTH | | | NR OF | POINTERS | NR OF | % | NR OF | POINTERS | % | FACTOR | | C A L C K E Y S | PRIMARY | THAT CAN | EMPTY | PRIMARY | OVERFLOW | IN | OVERFLOW | FOR | | | BUCKETS | BE ADDED | BUCKETS | BUCKETS | BUCKETS | OVERFLOW | BUCKETS | RECORD | |--------------------------------|----------|------------|----------|----------|----------|------------|----------|----------| | | | | | | | | | | | KEY-REF: 12 | 1 | 109 | 0 | 4 | 0 | 0 | - | 2,00 | | | | | | | | | | | | KEY-REF: 14 | 3 | 597 | 0 | 10 | 0 | 0 | - | 2,00 | | | | | | | | | | | | KEY-REF: 15 | 11 | 806 | 3 | 7 | 0 | 0 | - | 2,00 | | | | | | | | | | | | KEY-REF: 16 | 1 | 107 | 0 | 19 | 0 | 0 | - | 2,00 | | | | | | | | | | | | KEY-REF: 17 | 1 | 305 | 0 | 8 | 0 | 0 | - | 2,00 | | | | | | | | | | | *----------------------------------------------------------------------------------------------------------------------------*
BSTATUS prints separate CALC key statistics for each realm.
RECORDS
Only if DISPLAY CALC RECORD is specified:
Names of the record types for which BSTATUS is to print out the CALC key statistics
CALC KEYS
KEY REF: keyref
Only if DISPLAY CALC SEARCHKEY is specified:
Numbers of CALC SEARCH keys for which BSTATUS is to print out the CALC key statistics
NR OF PRIMARY BUCKETS
Number of primary pages reserved for the hash area
RECORDS/POINTERS THAT CAN BE ADDED
Number of records (for a direct hash area) or pointers (for an indirect hash area) that can still be stored in the primary pages of the hash area
NR OF EMPTY BUCKETS
Number of empty primary pages
FILLING % PRIMARY BUCKETS
Occupancy level of the primary pages
NR OF OVERFLOW BUCKETS
Current number of overflow pages
RECORDS/POINTERS IN OVERFLOW
Number of records (for a direct hash area) or number of pointers (for an indirect hash area) in the overflow pages
FILLING % OVERFLOW BUCKETS
Occupancy level i.e. occupancy level of the overflow pages
DEPTH FACTOR FOR RECORD
Depth factor for accessing a record, i.e. average number of accesses required for locating a record
BSTATUS calculates the depth factor according to the following formulas:
Direct hash area
Indirect hash area:
n
Number of all pages in the hash area (primary and overflow pages)
ranki
Ranking of the i-th CALC page in a chain of primary and overflow pages
Primary page: rank 1
1st overflow page: rank 2
2nd overflow page: rank 3
and so forth
d
Depth factor
total no. of records
Number of all records stored in the primary and overflow pages of the hash area
total no. of pointers
Number of all pointers stored in the primary and overflow pages of the hash area