DCMT DISPLAY TRANSACTION

DCMT DISPLAY TRANSACTION displays information about internal and external transactions.
idmscu19
DCMT DISPLAY TRANSACTION displays information about internal and external transactions.
This article describes the following information:
2
2
Syntax
Following is an example of the DCMT DISPLAY TRANSACTION syntax:
►►─── DCMT ─┬───────────────────┬─────────────────────────────────────────────►             └─ 
broadcast-parms
 ─┘  ►─── Display ────────────────────────────────────────────────────────────────►  ►─┬─ TRansaction 
transaction-id
 ─┬───────────────────────────────────────────►◄    └─ TRansactions ───────────────┘
Parameters
Following are the descriptions for the DCMT DISPLAY TRANSACTION parameters:
  • broadcast-parms
    Indicates to execute the DCMT command on all or a list of data sharing group members. For more information about broadcasting and broadcast-parms syntax, see How to Broadcast System Tasks in the Using System Tasks section
    .
  • TRansaction
    Displays detailed and summary information about a specified transaction.
    • transaction-id
      Specifies a transaction with its ID.
  • TRansactions
    Displays summary information about all external and internal transactions.
Usage
Summary for All Transactions
The following table describes the summary information displayed for each transaction:
Field
Value
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
STATUS Field Values
The following table shows describes the possible STATUS field values:
Code
Position 1
(Controlling Module)
Position 2
(Wait Status of Transaction)
Position 3
(Progress of Transaction)
blank
Outside of IDMSDBMS
Waiting for normal I/O, or for application
to issue another database request
Signon in progress
(storage acquisition, loading sub-schema, 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 sub-schema 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
 
Detail for all Transactions
DCMT DISPLAY TRANSACTION displays the following detailed database access information for the specified transaction:
Field
Value
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
Journal Access
DCMT DISPLAY TRANSACTION displays the following detailed journal access information for the specified transaction:
Field
Value
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
Locking
DCMT DISPLAY TRANSACTION displays the following detailed locking information for the specified transaction:
Field
Value
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
Index Statistics for Transaction
DCMT DISPLAY TRANSACTION displays the following detailed index statistics for the specified transaction:
Field
Value
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
Detail for a Specified Transaction
DCMT DISPLAY TRANSACTION displays the following detailed information for the specified transaction:
Field
Value
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.
Examples
Following are examples of the output of DCMT DISPLAY TRANSACTION commands:
DCMT DISPLAY TRANSACTIONS
      D TRANS 7 Task / LTE   Trans-ID Pri Orig Module   SS/AM    St Stat        Date:Time          7     350455 253  LOC RHDCRUAL IDMSSECS RO   A 2008-09-16-15.06.35.5697 DataBase        DBMS     Lines     Reads     Pages    Writes     Pages    Forced                Calls      Rqst      Rqst      Read      Rqst   Written    Writes                   33        24         6         2         0         0         0                 Rows      Calc      Calc   Cluster   Cluster     Frags      Rows              Current    Target     Oflow    Target     Oflow    Stored      Relo                    0         0         0         0         0         0         0 Journal       Before    Writes               Images                    0         0 Locks          Reqst     Share   Non-Shr     Freed                    1         1         0         0 INDEX      SR8-SPLIT SR8-SPAWN SR8-STORE SR8-ERASE SR7-STORE SR7-ERASE ORPH-ADOP                    0         0         0         0         0         0         0 SEARCHES                B-TREE B-TREE-LV BEST-CASE WORST-CSE                              0         0         0         0 --------- Area -----------          ------ Mode  ------ SYSTEM.DDLDML                       Shared Retrieval
DCMT DISPLAY TRANSACTION transaction-id
      DISPLAY TRANSACTION 486461 Task / LTE   Trans-ID Pri Orig Module   SS/AM    St Stat        Date:Time          2     486461 253  LOC RHDCRUAL IDMSNWK7 RW   H 2001-11-04-11.34.43.9754 DataBase        DBMS     Lines     Reads     Pages    Writes     Pages    Forced                Calls      Rqst      Rqst      Read      Rqst   Written    Writes                 1628      1592      2582      1002         2         2         0                 Rows      Calc      Calc   Cluster   Cluster     Frags      Rows              Current    Target     Oflow    Target     Oflow    Stored      Relo                 1574         1         0         1         0         0         0 Journal       Before    Writes               Images                    0         6 Locks          Reqst     Share   Non-Shr     Freed                 1402         0         1      1401 --------- Area -----------          ------ Mode  ------ SYSDEF.DDLDCRUN                     Shared Update