SQLFetch failed in AS400

[mceccaro]

I am getting an intermittent error like odbc fecth failed after processing some number of rows.

Actually i am trying to pull the data from db2 table using the odbc stage ,some times it will goes fine and job is getting successful ,once in a while i am getting the follwing error:

DSD.BCIGetNext call to SQLFetch failed.
SQL statement:SELECT "col1", col2, "col3",col4 FROM S107472F.CESSIONI.LORPLINSO
SQLSTATE=S1000, DBMS.CODE=30187
[DataStage][SQL Client][ODBC][IBM][iSeries Access ODBC Driver]Error in host server data stream

Regards
Max

[JoshGeorge]

Your iSeries host is not able to process this much big amount of data at once. You might have to get a fix for this from IBM (Not DS related)