Task/LTE

The task ID or the logical terminal identification

Trans-ID

The transaction ID

Pri

The transaction priority

Orig

The name of the program that originated the transaction

Module

The module being used by the transaction

SS/AM

The subschema or access module being used by the transaction

State

How the transaction is working:

• NO—suspended
• RO—read only retrieval
• RW—update

Status

The current (VIB) status of the transaction; a three-byte value

Date:Time

The date and time of the most recent checkpoint for the transaction

blank

Outside of IDMSDBMS

Waiting for normal I/O, or for application to issue another database request

Signon in progress (storage acquisition, loading subschema, etc.); no area(s) yet readied

A

Waiting for access to an area

Has gained access to requested area(s); proceeding; no db-keys yet locked

B

Waiting for a buffer in buffer pool to become available

C

IDMSCOLS

H

Has gained access to requested area(s); proceeding; one or more db-keys locked

I

IDMSDBIO

J

Transaction waiting for journal

K

IDMSLMGR

Waiting for db-key lock held by another transaction

L

Waiting for subschema or database procedure to be loaded

M

IDMSDBMS

P

User database procedure

Waiting on DB buffer pool

S

DC/UCF trying to satisfy transaction request for access to area(s)

U

Utility Program

Waiting for journal buffer

SQL Calls

The number of calls the transaction has made to CA IDMS

Rows Rqst

The number of records the transaction has requested

Reads Rqst

The number of pages the transaction has requested

Pages Read

The number of pages actually read into buffer(s) for the transaction

Writes Rqst

The number of writes the transaction has requested

Pages Written

The number of writes actually performed for the transaction

Forced Writes

The number of writes performed for the transaction because the buffer was needed for something else

Rows Current

The number of records on which the transaction has any kind of lock

Hash Target

The number of records the transaction has found on the target CALC page

Hash Oflow

The number of records the transaction has found on a CALC overflow page

Cluster Target

The number of records the transaction has found on a VIA target page

Cluster Oflow

The number of records the transaction has found on a VIA overflow page

Frags Stored

The number of record fragments stored for the transaction

Rows Relo

The number of record fragments relocated for the transaction as a result of fragment consolidation

Before Images

The number of before images written since the most recent checkpoint

Writes

The number of writes to the journal performed since the beginning of the transaction

Total

The total number of records held in any access mode by the transaction

Share

The number of records held in share access mode by the transaction

Non-Share

The number of records held in update or exclusive access mode by the transaction

Freed

The number of records that have been held and released by the transaction

SR8-SPLIT

Number of SR8 record splits

SR8-SPAWN

Number of SR8 record spawns

SR8-STORE

Number of SR8 records stored

SR8-ERASE

Number of SR8 records erased

SR7-STORE

Number of SR7 records stored

SR7-ERASE

Number of SR7 records erased

ORPH-ADOP

Number of orphans adopted

B-TREE

Number of indexes searched

B-TREE-LV

Number of index levels searched

BEST-CASE

Minimum number of index levels searched

WORST-CSE

Maximum number of index levels searched

Area

The name(s) of area(s) opened for the transaction

Mode

The access mode in use:

• EXCLUSIVE RETRIEVAL
• EXCLUSIVE UPDATE
• PROTECTED RETRIEVAL
• PROTECTED UPDATE
• SHARED RETRIEVAL
• SHARED UPDATE
• TRANSIENT RETRIEVAL

Table Locks

The state of the lock:

• HOLD—The transaction is holding a lock on the area.
• WAIT—The transaction is waiting for a lock on the area.