My Oracle Support Banner

DB2 SAVEPOINT Not Working With OTMQ (Doc ID 2233681.1)

Last updated on JULY 24, 2018

Applies to:

Oracle Tuxedo Message Queue - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

User has the following pseudo code:

Set the DB savepoint
Retrieve the message from queue
Process the message causing DB updates.
If above step is success then
tpcommit()
Else
Rollback to DB savepoint
Do few DB updates
tpcommit()
end if

User encountered "rollback" to SAVEPOINT failure using the above pseudo code. User tested this by processing the message with failure so that the execution can go into the "else" part to rollback to savepoint; however, the rollback to DB SAVEPOINT failed.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.