Resolving outstanding units of work with the rsvmqtrn command

Outstanding units of work complete when the queue manager and Db2 resynchronize.

The output shown in Figure 1 shows a single in-doubt unit of work in which the commit decision has yet to be delivered to both Db2 databases.

To complete this unit of work, the queue manager and Db2 need to resynchronize when Db2 next becomes available. The queue manager uses the start of new units of work as an opportunity to regain contact with Db2. Alternatively, we can instruct the queue manager to resynchronize explicitly using the rsvmqtrn command.

Do this soon after Db2 has been restarted, so that any database locks associated with the in-doubt unit of work are released as quickly as possible. Use the -a option, which tells the queue manager to resolve all in-doubt units of work. In the following example, Db2 has restarted, so the queue manager can resolve the in-doubt unit of work:

> rsvmqtrn -m MY_QMGR -a
Any in-doubt transactions have been resolved.

Parent topic: Considerations when contact is lost with the XA resource manager