Adabas

The Adabas page lists the Adabas statements that were detected during the monitoring period.

Adabas Columns

The following columns display in the Adabas Page:

  • DB ID
    A decimal representation of the ADABAS database identifier.
    Limits: 1 to 65535

  • File #
    A decimal representation of the ADABAS File number.
    Limits: 1 to 5000

  • CMD
    One of the Adabas commands that are used to access ADABAS databases. This field displays the database access command. Possible values in this field are as follows:

    Commands

    Description

    A1

    Updates record(s) (hold options)

    BT

    Removes database updates for ET logic users.

    CL

    End/ET session and update database.

    C1

    Writes Command ID, PLOG, RABN checkpoint, buffer flush option.

    C3

    Writes SYNX-03 checkpoint for exclusive control update users.

    C5

    Writes user data on SIBA/PLOG.

    ET

    Ends and saves current transaction.

    E1

    Deletes record (hold options) or refreshes file.

    HI

    Prevents record update by other users.

    L1

    Reads record of specified ISN

    L2

    Reads records in physical order.

    L3

    Reads records in descriptor value order.

    L4

    Reads and holds, "wait for held record/issue return code" option.

    L5

    Reads in physical order and holds "wait/issue return code" option.

    L6

    Reads in descriptor value order with "wait/issue return code" option.

    L9

    Reads the values of the specified descriptor

    lF

    Reads characteristics of all fields in file.

    N1

    Adds new database record with ADABAS-assigned ISN.

    N2

    Adds new database record with user-assigned ISN.

    OP

    Opens ET/ADABAS STAR session.

    RC

    Releases one or more command IDs or a global Format ID for the issuing user.

    RE

    Reads ET data for this or all users.

    RI

    Releases held record and ISN.

    S1/S4

    Returns count and ISNs of records meeting the search criteria.

    S2

    Returns count of records and ISNs in user-specified order.

    S5

    Returns or save a list of coupled ISNs for the specified file.

    S8

    Combines two ISN lists from the same.

    S9

    Sorts the ISN list in ascending ISN or descriptor-specified sequence

  • CMD-IDX
    The Command ID is used by virtually all ADABAS commands to identify users, their transactions, and decoded formats for reuse by subsequent instructions.
    Format: Hexadecimal representation of the ADABAS Command ID. The Command ID is an automatically generated or user-specified non-blank, non-zero value.

  • Active %
    Displays the percentage of the ADABAS delay time that the ADABAS statement used CPU.

  • Wait %
    Displays the percentage of the ADABAS delay time that the ADABAS statement was waiting for data to be returned.

  • Total %
    The sum of the Actv% and the Wait% fields. This represents the total percentage of the ADABAS delay time used by this ADABAS statement.