I am getting this error message:
SQL7008N REXX variable "SBMSCUSTD " contains inconsistent data. SQLSTATE=55019
I am trying to update to ISeries database using DB2 stage. Am using DataStage 7.0 running on windows.
Can anyone help me resolve this?
I greatly appreciate your help!
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
3 replies Latest Post - 2011-08-17T07:02:43Z by SumitBisht
Pinned topic DB2 Connectivity - REXX Variable Error
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-08-17T07:02:43Z at 2011-08-17T07:02:43Z by SumitBisht
Re: DB2 Connectivity - REXX Variable Error2006-12-05T09:48:26Z in response to SystemAdminThis is as far as I've got so far: http://www-1.ibm.com/support/docview.wss?uid=swg21206832
But I've yet to find out where exactly I've to put this
connect.nojournal = True
> Hi All,
> I am getting this error message:
> SQL7008N REXX variable "SBMSCUSTD " contains
> inconsistent data. SQLSTATE=55019
> I am trying to update to ISeries database using DB2
> stage. Am using DataStage 7.0 running on windows.
> Can anyone help me resolve this?
> I greatly appreciate your help!
Re: DB2 Connectivity - REXX Variable Error2009-02-27T01:08:58Z in response to SystemAdminThis issue is caused by transaction isolation levels for iSeries DB2. Set the TXNISOLATION=32 in db2cli.cfg file on DB2 client and it should solve the issue. File is located under <db2_inst_home>/sqllib/cfg directory on DB2 client machine.
SumitBisht 2700033Y0Q1 Post