DISPLAY [IN CSV [csv-filename]] REALM STATISTICS FOR {realm-name-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”.
realm-name
Name of a realm for which realm statistics are to be printed.
You must specify names as follows:
- for user realms: the realm name defined in the Schema DDL by the AREA clause
- for the DBDIR: DATABASE DIRECTORY
- for the DBCOM: DATABASE COMPILER REALM
ALL
BSTATUS prints realm statistics on all the realms contained in the specified subschema.
Example
DISPLAY REALM STATISTICS FOR ALL
*----------------------------------------------------------------------------------------------------------------------------------* | | NR OF |MAX NR OF | NR PAGES WITH FILLING PERCENTAGES BETWEEN | NR FULL | TOTAL | FREE | | | EMPTY |CONTIGUOUS |--------------------------------------------| USER | NR OF | OCTADS | | R E A L M S | PAGES |EMPTY PAGES| 0- 19 | 20- 39 | 40- 59 | 60- 79 | 80- 99 | PAGES | PAGES | TOTAL | |-------------------------------|--------|-----------|--------|--------|--------|--------|--------|----------|----------|----------| | | | | | | | | | | | | | CUSTOMER-ORDER-RLM | 22| 22| 1| 0| 0| 0| 0| 10| 36| 91 520 | | | | | | | | | | | | | | PURCHASE-ORDER-RLM | 33| 33| 1| 0| 0| 0| 0| 23| 60| 135K | | | | | | | | | | | | | | CLOTHING | 21| 20| 4| 0| 0| 0| 8| 6| 42| 101K | | | | | | | | | | | | | | HOUSEHOLD-GOODS | 15| 14| 0| 0| 0| 0| 0| 6| 24| 59 700 | | | | | | | | | | | | | | SPORTS-ARTICLES | 36| 36| 0| 0| 0| 0| 0| 5| 44| 143K | | | | | | | | | | | | | | FOOD | 7| 6| 0| 0| 0| 0| 5| 3| 18| 29 630 | | | | | | | | | | | | | | LEISURE | 36| 36| 0| 0| 0| 0| 0| 5| 44| 143K | | | | | | | | | | | | | | STATIONERY | 17| 17| 0| 0| 0| 0| 0| 4| 24| 67 660 | | | | | | | | | | | | | | ARTICLE-RLM | 1982| 1982| 3| 1| 0| 0| 0| 41| 2062| 7 903K | | | | | | | | | | | | | | SEARCH-RLM | | | T E M P O R A R Y R E A L M | | | | | | | | | | | | | | | | *----------------------------------------------------------------------------------------------------------------------------------* | | | | | | | | | | | | | T O T A L S | 2 169| | 9| 1| 0| 0| 13| 103| 2 354| 8 674K | | | | | | | | | | | | | *----------------------------------------------------------------------------------------------------------------------------------*
BSTATUS does not provide statistics on temporary realms.
REALMS
Names of the realms
NR OF EMPTY PAGES
Number of empty pages
MAX NR OF CONTIGUOUS EMPTY PAGES
Maximum number of contiguous empty pages
NR PAGES WITH FILLING PERCENTAGES BETWEEN
Number of partially filled pages, divided into groups with the specified occupancy level (excluding FPA pages, Act-key-0 pages, and Act-key-N pages)
NR FULL USER PAGES
Number of full pages (excluding FPA pages, Act-key-0 pages, and Act-key-N pages)
TOTAL NR OF PAGES
Size of the realm in pages (including FPA pages, Act-key-0 pages, and Act-key-N pages)
FREE OCTADS TOTAL
Total number of unused bytes per realm
K:
If the number is greater than 100,000 bytes, BSTATUS rounds it off to a multiple of 1,000 =1 kbyte
M:
If the number is greater than 100,000 kbytes, BSTATUS rounds it off to a multiple of 1,000 kbyte =1 Mbyte
TOTALS
If ALL is specified in the DISPLAY REALM statement, BSTATUS prints the sums of all columns in the TOTALS line.
In this case it calculates the total number of unused bytes before rounding off the numbers for the individual realms.