Under the header DBTT INFORMATION, BPSIA prints out two tables:
The first table contains information on the database key translation tables (DBTTs) of the individual record types in the schema.
The second table lists the sets in which the record types in the schema are member record types or owner record types.
Example
*** DBTT INFORMATION *** REF RECORD-NAME ANCHOR CURRENT NR EXTENTS LENGTH PER-BLOCK NO REUSE 1 SSIA-RECORD 1 2 11 995 0 4 995 2 CUSTOMER 3 2 1 331 0 12 331 3 CST-ORDERS 3 4 1 497 0 8 497 4 ORD-ITEM 3 6 1 1990 0 4 995 5 INSTALMENT 3 9 1 995 0 4 995 6 ART-TYPE 11 2 4 497 0 8 497 7 ART-SELECTION 11 4 5 497 0 8 497 8 ART-DESCR 11 6 13 497 0 8 497 9 ARTICLE 11 8 63 995 0 4 995 10 SUBSET 6 5 1 995 0 4 995 11 COLORS 11 10 25 995 0 4 995 12 MATERIALS 11 12 10 995 0 4 995 13 SUPPLIER 4 2 1 662 0 12 331 14 PURCHASE-ORDER 4 18 1 497 0 8 497 15 P-ORD-ITEM 4 20 1 995 0 4 995 REF RECORD-NAME OWNERSHIPS MEMBERSHIPS 2 CUSTOMER 1 3 4 3 CST-ORDERS 2 1 4 ORD-ITEM 2 3 13 5 INSTALMENT 28 4 6 ART-TYPE 5 29 7 ART-SELECTION 6 30 8 ART-DESCR 7 5 6 9 ARTICLE 9 10 13 14 31 7 8 12 10 SUBSET 9 10 11 COLORS 32 12 MATERIALS 33 13 SUPPLIER 12 15 16 11 14 PURCHASE-ORDER 17 15 16 15 P-ORD-ITEM 14 17
The items printed in bold contain the value '0' before the BFORMAT utility routine is run.
REF
Number of a record type
RECORD-NAME
Name of the record type
ANCHOR
First page of the DBTT anchor table (realm number and page number)
CURRENT
Record sequence number of the last stored record of this record type
NR
Maximum number of records of this record type which can be stored taking into account the current size of the DBTT
EXTENTS
Number of DBTT extents that currently exist
LENGTH
Length of a DBTT entry
PER BLOCK
Number of DBTT entries that can be accommodated in one page
NO REUSE
*:
Database keys of deleted records cannot be reused.
'BLANK'
Database keys of deleted records can be reused.
OWNERSHIPS
Numbers of the sets in which the record type is owner
MEMBERSHIPS
Numbers of the sets in which the record type is member
When a user schema or compiler schema is output, the BEGIN, NR and LENGTH values may not be up to date. This may be the case after BREORG has been executed, for example.