HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

Overview Session Screen 

This screen identifies all sessions connected to the DBEnvironment.

	       Click here to view figure.
            

To invoke the Overview Session screen, use the s command from the
Overview subsystem or the /o s 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 for 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.  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 or a SET TRANSACTION
                 statement.

Display Conventions 

When a session is displayed in inverse video, the session 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