Example
*** SIA PRINT REPORT ***
DATABASE ID = XXXXXXXX
DATABASE NAME = SHIPPING
DATABASE-LAYOUT-VERSION = 004.00
SCHEMA NAME = MAIL-ORDERS
SCHEMA TYPE = USER SCHEMA
SIA VALIDATION DATE = 2019-01-29 09:31:31
LENGTH OF SIA = 6576
MAXIMUM AREA REF = 12
MAXIMUM RECORD REF = 15
MAXIMUM SET REF = 34
MAXIMUM KEY REF = 19
TCUA LENGTH = 3424
MAXIMUM RECORD LENGTH = 580
MAXIMUM ENTRY LENGTH = 52
MAXIMUM NR MEMBERSHIPS = 4
MAXIMUM SPLIT PARAMETER = 5
LENGTH KEY-BIT-STRING = 0
LENGTH PHYSICAL BLOCK = 4000
FPA-ENTRIES MAIN-BLOCK = 1990
Under the header SIA PRINT REPORT, BPSIA prints the following general information:
DATABASE ID
Identification the database is stored under
DATABASE NAME
Name of the database
DATABASE-LAYOUT-VERSION
Layout version of the database
SCHEMA NAME
Name of the schema
SCHEMA TYPE
Type of schema
SIA VALIDATION DATE
Validation date of the schema (date and time)
LENGTH OF SIA
Self-explanatory
MAXIMUM AREA REF
Highest realm number in the user’s database;
after reorganization, it is not necessarily identical with the actual number of realms
MAXIMUM RECORD REF
Highest number of a record type in the user’s database;
after reorganization, it is not necessarily identical with the actual number of record types
MAXIMUM SET REF
Highest set number in the user’s database;
after reorganization, it is not necessarily identical with the actual number of sets
MAXIMUM KEY REF
Highest number of an ASC, DESC, or SEARCH key in the user’s database;
after reorganization, it is not necessarily identical with the actual number of corresponding keys
TCUA LENGTH
Length of the Transaction Currency Area of a subschema
MAXIMUM RECORD LENGTH
Length of the longest record type in the schema including set connection data
(SCD)
MAXIMUM ENTRY LENGTH
Length of the longest key in the schema (CALC key, ASC or DESC key, or SEARCH key), incremented by 7 bytes and rounded up to an integral multiple of 4
MAXIMUM NR MEMBERSHIPS
The maximum number of sets in the schema containing the same record type as member record type
MAXIMUM SPLIT PARAMETER
Maximum value specified in the DYNAMIC REORGANIZATION clause of the SSL
LENGTH-KEY-BIT-STRING
Check byte for the MODIFY function; if 0 is specified, 4 bytes are reserved
LENGTH PHYSICAL BLOCK
Length of the database pages
FPA ENTRIES MAIN-BLOCK
Number of possible FPA entries per FPA base page