IBM Support

Resolving SQL0911N Reason Code = 68

Troubleshooting


Problem

Error occurred while logging activity details LG_AS_HDRI_ah1 failed with error code = 1. Error msg = SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68".

Cause

Reason Code "68" translates to the transaction rolled back due to a lock timeout

Resolving The Problem

1.) Stop WPG servers by using the bcgStopServer.sh/bcgStopServer.bat script located in the WPG_Install Directory/bin directory.

2,) Login with userid that has db2admin credentials.

3.) restart DB2 using the below commands

db2 force applications all
db2stop
db2start

4.) run db2rbind using the below command :-
db2rbind <dbname> -l bind.log all

5.) Log back in with bcguser userid.


6.) Start WPG servers by using the bcgStartServer.sh/bcgStartServer.bat script located in the WPG_Install Directory/bin directory.

[{"Product":{"code":"SSDKKW","label":"WebSphere Partner Gateway Advanced Edition"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","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.0.0.7;6.0.0.6;6.0.0.5;6.0.0.4;6.0.0.3;6.0.0.2;6.0.0.1;6.0.0;6.0;6.2.1.2","Edition":"Advanced;Enterprise","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
23 June 2018

UID

swg21406093

Page Feedback