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>