DBH form STATEMENTS

The form provides an overview of all active statements. It displays statements both within transactions and those outside transactions.

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.

Local DML

Number of local CALL DML statements (for the session and per time period).

Local SQL

Number of all local SQL statements, including utility statements (for the session and per time period).

Remote DML

Number of CALL DML statements entered from a different configuration (for the session and per time period).

Remote SQL

Number of all SQL statements, including utility statements, entered from another configuration (for the session and per time period).

Number

Current number of statements (actual value).
This value is the sum of the two subsequent fields Active and Waiting.

Active

Number of active statements (actual value), i.e. all statements marked “A” in column S (see below).

Waiting

Number of waiting statements (actual value), i.e. all statements with the status “L” and “W” in column S (see below).

Up to nine statements are output, sorted in descending order based on their duration. The following specifications refer to individual statements.

TAC

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

Status of the statements (one position)

A:	The statement is being processed by a thread.
L:	The statement ran into a transaction lock. (The lock relationships of the transactions can be taken from the DBH form TRANSACTIONS.)
W:	The statement is in the priority queue or is waiting for a service task.

I/O

Number of weighted inputs and outputs of this statement (i.e. write accesses are counted twice, read accesses once).

Duration

Duration of the statement (elapsed time) in the format hh:mm:ss.

Activity-Time

Elapsed activity time of the statement in the DBH in seconds.

T

Application type

M:	DML statement
D:	DDL statement
U:	Utility statement
'BLANK' (space):	The statement type is not yet known.