IBM Support

Using newer version of the JCC drivers

Troubleshooting


Problem

Due to BCG103201 every 5 seconds the DB file system is filled up

Symptom

Errors of this kind as shown below are seen in the WebSphere Partner Gateway logs:

Error during Database procedure call, procedure name is
'BP_Sponsor_STATES_AH1, error reason:[ibm][db2][jcc][10342][11669]
Application must execute a rollback. The unit of work has already been
rolled back in the database but other resource managers involved in
this unit of work might not. To ensure integrity of this application,
all SQL requests will be rejected until the application issues a
rollback.

Diagnosing The Problem

The above reported error has been fixed using APAR IZ22295. The APAR IZ22295 defect fix is for

- DB2 9.5 in JCC driver 3.53.x versions that are 3.53.52 or above and for
- DB2 9.1 in JCC driver 3.8.x versions that are 3.8.35 or above

Check if the JDBC Driver of the DB2Client does contain APAR IZ22295 fix or not.


JCC traces generally include the JCC driver version near the beginning.
The article at https://www-304.ibm.com/support/docview.wss?uid=swg21196160 explains how to get a JCC trace.

Resolving The Problem

Upgrade the db2jcc.jar used by WebSphere Partner Gateway to versions that are 3.53.52 or above.
If you are using DB2 9.5 FP3 and above you can use the same jcc driver as provided in the DB2 client.

So either you can extract the db2jcc.jar DB2 9.5 FP5 package file or from the <DB2 installed location>/java/ and update the jcc driver in WPG applications to resolve the issue.


Please follow the following steps to replace the jcc driver jars at all the needed locations:

  1. Stop all the servers.
  2. Take the backup of db2jcc.jar available under
    • a. <WPG_HUB_INSTALLED_LOCATION>/lib ,
    • b. <WPG_HUB_INSTALLED_LOCATION>/ftpserver/common/lib and
    • c. if it is a distributed installation <WPG_HUB_INSTALLED_LOCATION>/MAS/lib
  3. Copy db2jcc.jar from <DB2 installed location>/java and paste under below locations -
    • a. <WPG_HUB_INSTALLED_LOCATION>/lib
    • b. <WPG_HUB_INSTALLED_LOCATION>/ftpserver/common/lib and when available
    • c. <WPG_HUB_INSTALLED_LOCATION>/MAS/lib
      Note: If on Unix platform, change owner of copied jars to bcguser.
  4. Follow these steps to update the db2jcc.jar in the BCGBPE.ear.
    • a. Take backups of the db2jcc.jars. They will be available at
      <WPG_HUB_INSTALLED_LOCATION>/wasND/Profiles/bcgprofile/installedApps/wpgCell/BCG*.ear/lib
    • b. Pull up the WAS admin console.
    • c. Navigate to Application/Enterprise Applications
    • d. Select the BCGBPE application and click on Update.
    • e. In the next screen scroll down and select "Replace or add a single file" enter /lib/db2jcc.jar.
      In the 'Specify the path to the file', select "Local file system" and select the saved jar file from one path touched in step 3.
    • f. Click Next and OK on the next screen.
    • g. Click on the "Save" link.
  5. Repeat Step 4 in below Enterprise Applications
    • a. BCGArchiver,
    • b. BCGDocMgr and
    • c. BCGReceiver
  6. Update the .jar following the same steps above as in Step 4 for BCGBPEConsole, but for updating the Console application the path of jar file (4.e) would be /lib/support/db2jcc.jar.
Note: If the DB2 was upgraded to Version 9.5 since the initial installation from WPG the db2jcc_license_cu.jar has also to be replaced in the same way as described for the db2jcc.jar above
Using this FPor later version it is necesary to set DB2_RESTRICT_DDF=TRUE


Login to bcgappsdb -
su <db instance>
db2 connect to bcgapps
db2set DB2_RESTRICT_DDF=TRUE
db2stop
db2start
Start WPG servers

[{"Product":{"code":"SSDKJ8","label":"WebSphere Partner Gateway Enterprise Edition"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.2.1.1;6.2.1.0;6.2.1;6.2.0.5;6.2.0.4;6.2.0.3;6.2.0.2;6.2.0.1;6.2;6.1.1.2;6.1.1.1;6.1.1;6.1.0.3;6.1.0.2;6.1.0.1;6.1;6.2.1.2","Edition":"Advanced;Enterprise","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
11 October 2019

UID

swg21509070

Page Feedback