|
Problem |
If you have problems with 2PC on a WebSphere® Application
Server Web application using DB2/390, try these troubleshooting
techniques. They help you verify that DB2 2PC is enabled and eliminate DB2
as a potential cause of the problem. |
|
Solution |
Execute the following commands from the DB2 command prompt where db
1 or db 2 is the host database that you are having problems
performing two phase commit transactions against from your application:
- db2set -g DB2OPTIONS=+c
- db2stop
- db2start
- db2 set client connect 2 syncpoint twophase
- db2 connect to db 1 user userid using password
- Perform some sort of update; for example db2 insert into
tab 1...
- db2 connect to db 2 user userid using password
- Perform some sort of update; for example db2 insert into tab
2...
- db2 commit
- If the db2 commit command returns without errors, the test completed
successfully.
|
|
|
|
Cross Reference information |
Segment |
Product |
Component |
Platform |
Version |
Edition |
Data & Information Management |
DB2 for OS/390 |
|
|
|
|
|
|
|
|