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