CALC INFORMATION

Example

                  *** CALC INFORMATION ***                                                    
  
REC                                                           PPP-BITS   PHYSICAL_CALC_INFO    
 REF RECORD-NAME                    DIR DUPL LENGTH HASH-REF O M TAB  FIRST-BUCKET   NR-BUCKETS
  
   8 ART-DESCR                            *     40                        5        2          3
                                                                          6        2          2
                                                                          7        2          3
                                                                          8        2          1
                                                                          9        2          3
                                                                         10        2          2
   9 ARTICLE                                    10                        5        5          3
                                                                          6        4          1
                                                                          7        5          3
                                                                          8        3          1
                                                                          9        5          3
                                                                         10        4          2
  13 SUPPLIER                        *          35                        4        5         13

The items printed in bold contain the value '0' before the BFORMAT utility routine is run.

Under the header CALC INFORMATION, BPSIA prints out information on the record types defined with LOCATION MODE IS CALC.

REC REF

Number of the record type

RECORD-NAME

Name of the record type

DIR       

Marker indicating whether a direct or indirect hash area was created

*: Direct hash area

DUPL   

Marker indicating whether key values may or may not occur more than once

*: Duplicates allowed

LENGTH

Total length of the CALC key

HASH-REF

Marker for a user-defined hash routine; If no marker is printed in this column, the standard UDS/SQL hash routine is used.

PPP-BITS

* means the following with

O       

Owing to relocation of owner records, e.g. with BREORG, probable position pointers (PPPs) which refer to these owner records are very probably no longer up to date

M      

Owing to relocation of member records, e.g. with BREORG, probable position pointers which refer to these member records are very probably no longer up to date

TAB    

Owing to relocation of tables, e.g. with BREORG, probable position pointers which refer to these tables are very probably no longer up to date

Probable position pointers can also exist without these displays being set because the DBH does not maintain these bits when individual records are relocated. The displays are as a rule set when all records have been relocated by utility routines.
It may be useful to perform a BREORG run.

PHYSICAL CALC INFO

Physical information on the hash area:

FIRST-BUCKET

Address (realm number and page number) of the first CALC page in the primary area

NR-BUCKETS

Number of CALC pages reserved for the primary area

Information listed under the header PHYSICAL CALC INFO is repeated by BPSIA for each realm in which a hash area for the relevant record type is located.