Hi All,
I am loading data into AS400 table from oracle stage. we have journaling is on onthis table. Job is aborting with the following error.
"VPMDATA,0: Fatal Error: Fatal: [IBM][CLI Driver][AS] SQL7008N REXX variable "VPMDATA " contains inconsistent data. SQLSTATE=55019
DSTAGE-DB2CLI-0027`:`SQLExecDirect: Error executing statement 'DELETE FROM SCSTCDprd.VPMDATA'. See following DB2 message for details."
update action for this table is 'Clear table then insert rows'
Transaction Isolation is : Cursor Stability.
We are running all our jobs on grid environment
Please help me on this.
Thanks
-Deva
AS400 team is not agreed to turnoff the journaling.
Loading data in to AS400 table
Moderators: chulett, rschirm, roy
Re: Loading data in to AS400 table
deva wrote:Hi All,
I am loading data into AS400 table from oracle stage. we have journaling is on onthis table. Job is aborting with the following error.
"VPMDATA,0: Fatal Error: Fatal: [IBM][CLI Driver][AS] SQL7008N REXX variable "VPMDATA " contains inconsistent data. SQLSTATE=55019
DSTAGE-DB2CLI-0027`:`SQLExecDirect: Error executing statement 'DELETE FROM SCSTCDprd.VPMDATA'. See following DB2 message for details."
update action for this table is 'Clear table then insert rows'
Transaction Isolation is : Cursor Stability.
We are running all our jobs on grid environment
Please help me on this.
Thanks
-Deva
AS400 team is not agreed to turnoff the journaling.
Any solution ??????????
According to IBM:
"SQL7008N REXX variable <tablename> contains inconsistent data SQLSTATE = 55019".
Answer
The error occurs because you are attempting to update a non-journaled DB2 table on the iSeries.
Please ask the AS400 people to confirm that the file is journalled by typing dspfd lib/filename, then type journal on "find" field, then press shift+pf4 to search for "file is currenctly journaled" and the value should be "yes".
"SQL7008N REXX variable <tablename> contains inconsistent data SQLSTATE = 55019".
Answer
The error occurs because you are attempting to update a non-journaled DB2 table on the iSeries.
Please ask the AS400 people to confirm that the file is journalled by typing dspfd lib/filename, then type journal on "find" field, then press shift+pf4 to search for "file is currenctly journaled" and the value should be "yes".