Previous Topic: DCMT DISPLAY TRANSACTION Command ParametersNext Topic: DCMT DISPLAY TRANSACTION Command Usage


Example: DCMT DISPLAY TRANSACTION Command

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