Troubleshooting
Problem
On high workloads DB2 Connector job fails with an error: SQL1476N The current transaction was rolled back because of error "-911".
Symptom
A fatal error message in the job log:
Message: DB2_Connector_0,1: [Input link 0] SQLExecute reported: SQLSTATE = 40506: Native
Error Code = -1,476: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL1476N The current
transaction was rolled back because of error "-911". SQLSTATE=40506
Message: DB2_Connector_0,1: [Input link 0] SQLExecute reported: SQLSTATE = 40506: Native
Error Code = -1,476: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL1476N The current
transaction was rolled back because of error "-911". SQLSTATE=40506
Resolving The Problem
To resolve the issue in DataStage DB2 Connector set 'Auto commit mode' to 'On': (DB2 Connector > Properties > Usage > Session > Auto commit mode = On )
Alternatively the issue can be resolved on DB2 side by:
– increasing the locklist size:
update db cfg using LOCKLIST <value>
– increasing percent of lock lists per an application:
update db cfg using MAXLOCKS <value>
Alternatively the issue can be resolved on DB2 side by:
– increasing the locklist size:
update db cfg using LOCKLIST <value>
– increasing percent of lock lists per an application:
update db cfg using MAXLOCKS <value>
[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"8.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
14 September 2023
UID
swg21657646