DB2 Server for VSE: System Administration

Managing In-Doubt LUW's

Operator Commands

The following DB2 Server for VSE operator commands can be used to manage in-doubt LUWs:

SHOW ACTIVE

Displays the status of active agent structures ¹

SHOW CONNECT

Displays the status of all users or selected users connected to the application server.

FORCE COMMIT

Heuristically forces an in-doubt LUW to COMMIT

FORCE ROLLBACK

Heuristically forces an LUW to ROLLBACK

SHOW INDOUBT

Displays the status of all DRDA2 distributed units of work that are:

• currently in-doubt
• were heuristically committed or rolled back but RESYNC has not yet been performed nor has RESET INDOUBT been performed
• RESYNC failed for some in-doubt unit of work, because the status of the LUW was the opposite of what RESYNC required. (for example, RESYNC required that the unit of work be COMMITTED, but it had been heuristically ROLLED BACK). At the same time, RESET INDOUBT has not been performed.

RESET INDOUBT

Causes a heuristically committed or rolled back unit of work to be forgotten by the database, (that is, causes a forget log record to be written.)

¹

An agent is the internal database manager representation of an active user