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
还没有评论,来说两句吧...