Displays information about the logical areas.
Data
Column Name Type Description
RDB$LOGICAL_AREA_ID integer Logical area ID
RDB$AREA_ID integer Physical area ID
RDB$FLAGS integer Flags
RDB$RECORD_LENGTH integer Record length
RDB$THRESHOLD1_PERCENT integer First threshold percent
value
RDB$THRESHOLD2_PERCENT integer Second threshold percent
value
RDB$THRESHOLD3_PERCENT integer Third threshold percent
value
RDB$ORDERED_HASH_OFFSET integer Ordered hash offset
RDB$RECORD_TYPE integer AIP record type
RDB$LOGICAL_AREA_NAME char(31) Logical area name
1 – RDB$FLAGS
Represents flags for RDB$LOGICAL_AREAS information table.
Bit
Position Description
0 Logical area uses hash ordered index
1 Logical area modified with unjournaled records
2 Nologging is enabled
2 – RDB$RECORD_TYPE
Represents AIP record types for RDB$LOGICAL_AREAS information
table.
AIP Record
Types Description
0 Unknown
1 Table
2 Sorted index
3 Hashed index
4 System record
5 Segmented string