HELPLIB.HLB  —  SQL72  Information Tables, RDB$LOGICAL_AREAS
    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
Close Help