Example
*** CALC-SEARCH-KEY INFORMATION *** SET KEY DUPL HASH PPP-BITS SSIA PHYSICAL_CALC_INFO REF SET-NAME REF LNGTH NOT REF O M TAB DISPL FIRST-BUCKET NR-BUCKETS
29 SYS_ART-TYPE 12 25 0 11 14 1 31 SYS_ARTICLE 14 8 * 0 11 15 3 15 40 68 11 18 11 32 SYS_COLORS 16 20 * 0 11 29 1 17 2 * 28 11 30 1
Under the header CALC-SEARCH-KEY INFORMATION, BPSIA prints out information on the SEARCH keys which are defined on record or set level (for SYSTEM sets) by USING CALC:
SET REF
Set number (implicit set or SYSTEM set)
SET-NAME
Name of the set
KEY REF
Number of the key
LNGTH
Total length of the key
DUPL NOT
Marker indicating whether duplicate key values may occur or not
*: Duplicates not allowed
HASH REF
Marker for the hash routine used
'BLANK':
Standard UDS/SQL hash routine
> 0:
Number of user-defined hash routine
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.
SSIA DISPL
Displacement of this key description in the SSIA relative to the beginning of all key information for this set
PHYSICAL CALC INFO
Physical information on the hash area
FIRST-BUCKET
Address of the first CALC page reserved for table entries
NR-BUCKETS
Number of CALC pages reserved for table entries