DISPLAY [IN CSV [csv-filename]] PAGE ZERO;
The DISPLAY-PAGE-ZERO statement prints the first 108 bytes of the realm information page (Act-Key-0 page) in normal text. Use of this statement is optional; repeated input for the same realm is ignored by BPRECORD.
IN CSV
BPRECORD 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 BPRECORD run (e.g. DISPLAY IN CSV 'BPRECORD.CSV' ...).
For a detailed description of CSV format output, see the manual “Database Operation”, section “Outputting database information in a neutral format”.
Example
DISPLAY PAGE ZERO
************************************* ACTUAL-KEY-0 OF REALM < :IUDS:$XXXXXXXX.SHIPPING.ARTICLE-RLM > ************* PHYS REC LENGTH : 4000 DATASET INFO : TOTAL NR PAGES: 2062 FPA BASE BEGIN: AREA REF: 11 BNR: 1 NR PAGES IN FPA BASE: 1990 FPA EXTENTS NR BNR 1 47 MAX NR PAGES IN EXTENT: 63680 HIGHEST PAGE NR FOR FORMATTING: 2061 CREATE DATA: DATE : 20190129 TIME: 092704 BACK UP DATA: DATE : 20190129 TIME: 092742 REALM VERSION NR: 3 SYSTEM BREAK: OCCURRED: 0 ADMIN USERID: $XXXXXXXX CONFNAME: BREORG FILE NAME: :IUDS:$XXXXXXXX.SHIPPING.ARTICLE-RLM REALM LAYOUT VERSION: 004.00 UDS VERSION: V2.9 INCR NR PAGES: 64 INCR MIN PAGES: 0
PHYS REC LENGTH
Page length (in bytes)
DATASET INFO
General information on the realm:
FPA BASE
Information on the FPA base
AREA REF
Number of the realm that this free place administration applies to in the FPA base.
BNR
Page number of the first FPA page
TOTAL NR PAGES
Total number of pages administered in the realm
NR PAGES FPA BASE
Number of pages past the FPA base administered in the realm
FPA EXTENTS
Information on all FPA extents of the realm
NR
Number of FPA extent
BNR
Number of the first page of the FPA extent
MAX NR PAGES IN EXTENT
Maximum number of data pages administered in a FPA extent
HIGHEST PAGE NR FOR FORMATTING
Number of the database page up to which a format applies when extending a realm
nnnnnnnn
Number of the database page up to which a format applies when extending a realm.
If the value is the same as the value of TOTAL NR PAGES, then any new pages added to a realm during a realm extension are not formatted.
If the value is greater than the value of TOTAL NR PAGES, then all new pages up to the specified number that are added to a realm during a realm extension are formatted.
In the case of 2-Kbyte databases, further conditions must be fulfilled for reasons of safety thus making it unnecessary to format newly added pages.
UNKNOWN
All pages added to a realm during a realm extension are formatted.
CREATE DATA
Creation date for the realm:
DATE
Creation date in the format: yyyymmdd
TIME
Creation time in the format: hhmmss
BACK UP DATA
Time last update occurred see CREATE DATA for format)
DATE
Date of last update
TIME
Time of last updates
REALM VERSION NR
Internal version number of the realm; only changed by utility routines intended for updates (e.g. BALTER, BCHANGE, BOUTLOAD, BREORG)
SYSTEM BREAK
Indicates whether or not the realm was closed correctly
OCCURRED
0:
Last session terminated normally
1:
Last session aborted, i.e. the realm may be inconsistent
ADMIN USERID
ID under which the database is maintained.
CONFNAME
Name of configuration or utility routine with which the database was last accessed
FILE NAME
Complete file name of the realm
DATABASE LAYOUT VERSION
Version number of present database layout version in the format nnn.nn (output for the DBDIR)
REALM LAYOUT VERSION
Version number of the present realm layout structure in the format nnn.nn
UDS VERSION
UDS/SQL version number under which the database was last modified by DBH.
The field is used to ensure that warm starts are performed correctly.
INCR
Information on the online extensibility of the realm. This information is output for the DBDIR and the user realms.
The information is only output for realms for which the online extensibility was activated with the DAL command ACT INCR.
The information is also output when the online extensibility is deactivated.
NR PAGES
Number of pages added to the realm during an online extension.
MIN PAGES
Minimum number of free pages. If the number of free pages drops below this value, then an online extension is triggered by the DBH for the corresponding realm.