Use this overview task to help resolve a problem that you think is related to the Transaction service.
To identify and resolve transaction-related problems, you can use the standard WebSphere® Application Server RAS facilities. If you encounter a problem that you think might be related to transactions, complete the following steps:
The Transaction service produces diagnostic messages prefixed by "CWWTR". The error message indicates the nature of the problem and provides some detail. The associated message information provides an explanation and any user actions to resolve the problem.
Check the activity log.
Check the application server stdout.log.
For
more information about a problem, check the stdout.log file for the
application server, which should contain more error messages and extra
details about the problem.
See the topic about Transaction troubleshooting tips for an ongoing collection of troubleshooting tips, based on test and user experience. If you have suggestions for other tips, please let the IBM® WebSphere writing team know.
SQLException: com.ibm.db2.jdbc.app.DB2DBException: Row or object WAREHOUSE in CBIVP type *FILE in use
The first SQL job that locks the table never commits the transaction, and the lock is never released.
requires="managedTransaction.local"
and requires="managedTransaction.global"
to requires="noManagedTransaction"
requires="propagatesTransaction"
to requires="suspendsTransaction"