AREA INFORMATION

Example

                 *** AREA INFORMATION ***    

                                                                                  
 REF AREA-NAME                      TEMP D/T  FPA-BEGIN    ENTRIES  EXTENTS INCR  CURRENT     FREE     FULL  PART-FILLED  SCAN REUSE
                                             REF      BNR                   -ACT      BNR NR-PAGES NR-PAGES NR-PAGES FIL%            

   1 DATABASE-DIRECTORY                   D    1        1      100        0  YES       49       50       43        7   75   1       
   3 CUSTOMER-ORDER-RLM                   D    3        1       36        0  YES       13       22       13        1    2   1       
   4 PURCHASE-ORDER-RLM                   D    4        1       60        0  YES       24       33       26        1    2   1       
   5 CLOTHING                             D    5        1       54        0  YES       20       32       10       12   65   1       
   6 HOUSEHOLD-GOODS                      D    6        1       24        0  YES        7       16        8        0   -    1       
   7 SPORTS-ARTICLES                      D    7        1       44        0  YES        8       35        9        0   -    1       
   8 FOOD                                 D    8        1       18        0  YES        8        8        5        5   92   1       
   9 LEISURE                              D    9        1       44        0  YES        8       35        9        0   -    1       
  10 STATIONERY                           D   10        1       24        0  YES        6       17        7        0   -    1       
  11 ARTICLE-RLM                          D   11        1       62        0  YES       46       14       44        4    9   1       
  12 SEARCH-RLM                       *   D                                             0        0                          1      

Under the header AREA INFORMATION, BPSIA prints information on the realms of the database:

REF

Realm number

AREA NAME

Realm name

TEMP

Marker for temporary realms

*:

Realm is temporary

D/T

Marker indicating whether the realm is stored on disk or on tape

D:

Disk

T:

Tape

FPA BEGIN

Address (realm number (REF) and page number (BNR)) of the first page of the free place administration in this realm

The fields in bold print contain the value ’0’ before the BFORMAT utility routine is run.

ENTRIES

Total number of database pages in this realm

EXTENTS

Number of FPA extents in this realm

INCR-ACT

Denotes the online extensibility of this realm

YES:

The online extensibility is activated for the realm.

NO:

The online extensibility is not activated for the realm.

The reliable information about online extensibility is stored in the Act-key-0 of the particular realm and can be displayed using BPRECORD statement DISPLAY PAGE ZERO. Reliable information is available in the SIA only if the DBH was the last program which modified the database.

CURRENT BNR

Number of the page in which free storage space was last located
0: Realm has not yet been accessed

FREE NR-PAGES

Number of completely free pages

FULL NR-PAGES:

Number of full pages

PART-FILLED NR-PAGES

Number of partially filled pages; on average FIL% occupied

SCAN Indicates which search mode is used for the free place search

1:

First Scan (space for new data which is to be stored is searched for in the free area at the end of the realm).

2:

Second Scan (space for new data which is to be stored is searched for from the beginning of the realm).

REUSE 

Flag indicating whether the BMODTT statement SET REUSE-FREE-SPACE has been specified for this realm

'BLANK'

not specified

*

specified

When a user schema or compiler schema is output, the FPA-BEGIN and ENTRIES values for the DBDIR (line 1) may not be up-to-date. This may be the case after BREORG has been executed, for example.