DBH form TRANSACTIONS

This form provides information on the number of transactions. The duration, type and number of I/Os is output for each transaction.

Field descriptions

<ver> DBH CNF Time

Version of the DBH. Name of the DBH to which the data in the form relates. Name of the configuration monitored. Time at which the form is output.

Number

Number of completed transactions (for the session and per time period), including internal transactions.

Retrieval

Number of completed retrieval transactions (for the session and per time period), including internal transactions.

Update

Number of completed update transactions (for the session and per time period).

Reset

Number of rolled-back transactions (for the session and per time period).

Group Commit / Session

Average number of transactions involved in a group commit (for the session).

Group Commit / Interval

Average number of transactions involved in a group commit within the last time interval.

Number of Locks / Session

Number of transaction locks for the session.

Number of Locks / Interval

Number of transaction locks per time interval.

Users

Number of currently active users.

Open TAs

Number of currently open transactions

The following information relates to individual transactions. A maximum of nine transactions are output. They are sorted in ascending order according to their duration. The maximum number of transactions to be output to SYSLST is determined by the user (range of values: 10-999, default value: 200).

N TAC

Unique transaction number assigned by SESMON (one digit) UTM transaction code used to call the application program that opened this transaction (eight characters). In the case of TIAM applications, the user ID of the application program appears here, in the case of DCAM applications the request name.

User-ID

Identification of the user who opened the transaction (32 characters). It is output in 32 positions in the following form: HOST-NAME, APPLICATION-NAME, CUSTOMER-NAME, CONVERSATION-ID (see section “Syntax for the identification of users”).

S (State)

State of the transaction (one character):

A:	The transaction is being processed by a thread.
L:	The transaction is locked.
P:	The transaction is in the PTC state.
R:	The transaction has been rolled back.
W:	The transaction has been canceled due to a service task.
F:	The transaction has been unlocked with INFORM-PROGRAM JOB-ID=*TSN(TSN=tsn), MSG='component,RELEASE-USER-RESOURCES' or the corresponding CALL-DML administration statement.
'BLANK' (space):	The state of the transaction does not correspond to any of the above categories.

I/O

Weighted sum of the logical inputs and outputs of this transaction. The weighted sum is obtained by counting write accesses twice and read accesses once.

L (Lock)

Number of the transaction that locks this transaction (one digit). If the output transaction is locked by a transaction that can no longer be displayed on the screen, this is indicated by “*” (asterisk).

Duration

Elapsed time of the transaction in the form hh:mm:ss

Statements

Number of statements executed so far in this transaction. Only those statements received by the DBH for processing are counted. Statements that have already been processed by the connection module or the SQL runtime system are not counted. Chained CALL DML statements are counted as one statement.

T (Type)

Transaction type
M: DML transaction
D: DDL transaction
U: internal utility transaction