Displaying commitment control information

 

iSeries™ Navigator can display information about all transactions (logical units of work) on the system. iSeries Navigator can also display information about the job, if any, associated with a transaction.

These display operations do not display the isolation level for SQL applications.

To display information, proceed as follows:

1. From iSeries Navigator, expand the system you want to use.

2. Expand Databases.

3. Expand the system you want to work with.

4. Expand Transactions.

   To view a transaction that is associated with an X/Open global transaction, expand Global Transactions. To view a DB2 Universal Database™ (UDB) managed transaction, expand Database Transactions.

5. Expand Global Transactions or Database Transactions.

This display shows the following information:

• Unit of Work ID

• Unit of Work State

• Job

• User

• Number

• Resynchronization in Progress

• Commitment Definition

Online help provides information about all the status displays and the fields on each display.

• Displaying locked objects for a transaction
  You can display locked objects for global transactions with transaction-scoped locks only.

• Displaying jobs associated with a transaction
  To display jobs associated with a transaction, follow these steps.

• Displaying resource status of a transaction
  To display the resource status of a transaction, follow these steps.

• Displaying transaction properties
  To display transaction properties, follow these steps.

 

Parent topic:

Managing transactions and commitment control

 

Related tasks

Detecting deadlocks
Recovering transactions after communications failure
When to force commit and rollback operations and when to cancel resynchronization