Run DBInfo in Interactive Mode

You can run DBInfo in interactive mode to find the first quiet point in an audit trail from a specified AFN and ABSN and use that information (that is, AFN, ABSN, SEG, and INX) to configure DATABridge Span or a DATABridge Client after a rollback. (Run DBInfo in normal mode to determine the current AFN and ABSN.)

In interactive mode, DBInfo uses a remote file interface.

To run DBInfo in interactive mode

  1. Start DBInfo in interactive mode by typing the following command. You must include the quotation marks.

    START WFL/DATABRIDGE/DBINFO ("databasename", "parameter [ON diskfamilyname] " [, "logicaldatabasename"])

    where databasename indicates the title of the DESCRIPTION file without the DESCRIPTION node, parameter is one of the following parameters that initiate interactive mode, and diskfamilyname is the pack DBInfo will use for reading the audit files (the default is the primary audit pack specified in the DASDL).

    All of the following parameters initiate interactive mode, so use the parameter that is easiest for you to remember:

    FINDQPT
    FIND
    QPT
    FIND QPT
    FIRSTQPT
    FIRST
    FIRST QPT

  2. When prompted, type the AFN and the ABSN in the following format. The ABSN must be a value of two or greater. The ABSN does not have to be in the specified audit file. DBInfo will stop at the first QPT that has an ABSN greater than or equal to the specified ABSN.

    Note: If you do not know the ABSN, enter 2 and DBInfo will use the first quiet point in the specified file.

    <AFN>space<ABSN>

  3. Press transmit.

    DBInfo returns the AFN, ABSN, SEG, INX, and time stamp for the first quiet point after the specified AFN and ABSN.

    For example:

    Quiet point found on December 9, 2009 @ 09:12:17 at audit location

    AFN = 18 ABSN = 17090 SEG = 9 INX = 10

    Please enter <AFN> space <ABSN> or ?END

  4. To search for another quiet point, type the AFN and the ABSN and then press transmit. To quit DBInfo, type ?END and then press transmit.

    Example

    The following example uses a sample database named BANKDB:

    START WFL/DATABRIDGE/DBINFO ("(USER)BANKDB ON HOST","QPT")

    The following prompt appears:

    Please enter <AFN> space <ABSN> or ?END

    Enter the AFN and ABSN to specify the starting point of the search. Using the example in step 2, you would enter:

    18 17090

    DBInfo returns the following:

    Searching from AFN 18 ABSN 17090 ...

    Quiet point found on December 9, 2009 @ 09:12:17 at audit location

    AFN = 18 ABSN = 17090 SEG = 9 INX = 10

    Please enter <AFN> space <ABSN> or ?END