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
– increasing percent of lock lists per an application:
update db cfg using MAXLOCKS



发表评论

表情:
评论列表 (有 0 条评论,80人围观)

还没有评论,来说两句吧...

相关阅读