DSXchange

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.

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 ??????????

Patience, grasshopper.

I would execute a stored procedure as a separate step to truncate the table. Clear does a DELETE on all rows. You might be filling up your rollback segments. Try it with 2 steps. Take the CLEAR out.

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".