Getting DB2 FETCH not valid, cursor in unknown position after upgrade from 7.1 to 7.3

Asked Oct 31 '19 at 16:08

Active Oct 31 '19 at 16:18

Viewed 423 times

We have Attunity Replicate running which does a change data capture on the data.

The Replication works by first doing a full load of a table, then constantly updates the data using the DB2 journal.

We recently upgraded from 7.1 to 7.3, and the full load query is not working anymore.

When trying to load a table with 500k rows, it stops after 350k rows and I get the following error.

Note that this is only happening for some tables, and not all.

I have set up the waitTimeOut to be 600 seconds.

The error I get is:

RetCode: SQL_ERROR SqlState: 07005 NativeError: -227 Message: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0227 - FETCH not valid, cursor SQL_CUR98BF6120 in unknown position.

Is there any command or something to run on the AS400 or Attunity Replicate which can sort this error message out?

edited Oct 31 '19 at 16:18

mao

11,321
2
13
29

asked Oct 31 '19 at 16:08

Jeremy Teemull

Can you post one of the SQL getting error? – Nifriz Nov 04 '19 at 11:33
Are you up to date with PTFs? Contact Attunity and/or IBM. – Charles Nov 06 '19 at 18:19

Getting DB2 FETCH not valid, cursor in unknown position after upgrade from 7.1 to 7.3

0 Answers0