HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

Overview Program Screen 

This screen displays session information for each program.

	       Click here to view figure.
            

To invoke the Overview Program screen, use the p command from the
Overview subsystem or the /o p command from other subsystems.

Field Definitions 

REFRESH          The screen refresh rate, in seconds.

SESSIONS         The number of DBEnvironment sessions.

CID              The DBEnvironment connection identification number.

PIN              The MPE/iX process identification number of the
                 DBEnvironment session.

USER@ACCT        The MPE/iX user name and account name of the
                 DBEnvironment session.

STATUS           The status of the DBCore call the session has made.
                 This field is equivalent to the STATUS column of the
                 SYSTEM.CALL pseudotable.  The possible values are listed
                 below:

                 Running          DBCore is processing a call from a
                                  session.

                 Waiting for      The session has made a DBCore call, but
                 resource         is waiting until it can acquire a
                                  resource that is currently unavailable.
                                  The resource can be LOCK, LATCH,
                                  BUFFER, THROTTLE, or XACT.

                 Idle             DBCore is not processing a call.

XID              The transaction identifier, equivalent to the XID column
                 of the SYSTEM.TRANSACTION pseudotable.

ISO              The isolation level, equivalent to the ISOLATION LEVEL
                 column of the SYSTEM.TRANSACTION pseudotable.  For more
                 information, see the chapter "Concurrency Control
                 through Locks and Isolation Levels" in the ALLBASE/SQL 
                 Reference Manual.

PRI              The transaction priority, equivalent to the PRIORITY
                 column of the SYSTEM.TRANSACTION pseudotable.  The
                 lowest transaction priority is 255, and the highest is
                 0.

LABEL            The transaction label, equivalent to the LABEL column of
                 the SYSTEM.TRANSACTION pseudotable.  To assign a label
                 to a transaction, use a BEGIN WORK statement or a SET
                 TRANSACTION statement.

PROGRAM NAME     The name of the program being run.  All of the sessions
                 running a program are listed beneath the PROGRAM NAME.

Display Conventions 

When a session is displayed in inverse video, it is waiting for a
resource, probably a lock.

Related SET Commands 

Use the SET REFRESH command to modify the refresh rate of the screen.

MPE/iX 5.0 Documentation