|
| 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 | | | | |
|
| |
|
Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, Java 2 Connectivity (J2C) Operating system(s): AIX, HPUX, Linux, Multi-Platform, Solaris, Windows Software version: 3.5, 4.0, 5.0, 5.1, 6.0 Software edition: Edition Independent Reference #: 1052995 IBM Group: Software Group Modified date: 2004-05-27
(C) Copyright IBM Corporation 2000, 2004. All Rights Reserved.
|