Out Of Memory in ODBC Enterprise Stage

itsvarunm · Participant Joined: 31 Aug 2012 Posts: 7 Points: 74

Hi,

I have a DB2 table which is having around 30 columns. I am using SCD staging in DS 8.1 to do SCD on this job. But the job aborts with the below error
[IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver]Out Of Memory

Any help is highly appreciated

Thanks,
Varun

ArndW · Posted: Fri Aug 31, 2012 7:14 am

Is this the read or the write stage? Are you doing any SQL? How many rows of data or megabytes of data in the file and how long before the failure occurs after starting the job? If this is the read stage, then make a copy of your job with just the Read and a peek stage and see if the problem persists.

itsvarunm · Participant Joined: 31 Aug 2012 Posts: 7 Points: 74

Hi ArndW,

This is a write stage with UPSERT.. No custom SQL is used. The data volume is only in the 100s .. No big columns also. So the data size is less. The job barely takes 10 secs to execute. I had tried removing the SCD and doing a direct insert into the table. This works fine. The SCD /upsert seems to be causing the problem.

Thanks,
Varun

ArndW · Posted: Fri Aug 31, 2012 10:56 am

See if setting APT_DISABLE_COMBINATION to "true" changes the error message, perhaps it was incorrectly reported.

Do you have unusual data types in the record?

itsvarunm · Participant Joined: 31 Aug 2012 Posts: 7 Points: 74

Hi ArndW,

Tried that but didnt help. There are no special column types in the table.

Thanks,
Varun

ArndW · Posted: Sat Sep 01, 2012 9:39 am

It does sound like a bug/problem in the SCD stage (since the error disappears when you remove the stage). If you replace your ODBC output with a PEEK or sequential file stage does the error persist?