db2 connector加載資料時報SQL1476N

在開發環境上運作程式正常，但是測試環境時報錯

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

官網上給出了下面兩種解決方法，第一種方法改了之後仍然報錯，第二種方法修改後成功

To resolve the issue in DataStage DB2 Connector set 'Auto commit mode' to 'On': (DB2 Connector > Properties > 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>