Problem in using Dynamic RDBMS stage

shalini11 · Post by **shalini11** » Mon Aug 24, 2009 2:43 am

Hi All,

I have to load data from oracle to db2.Its a direct load without any transformations except TimestampToDate().

Data is getting loaded using DB2 API stage. It is taking around 5:30 hrs to load approx 1 billion records.

So i thought of using Dynamic RDBMS to speed up the process. But this stage is throwing the below error:

Assignment of a NULL value to a NOT NULL column "TBSPACEID=5, TABLEID=24, COLNO=0" is not allowed.

I checked in the oracle database, there are no nulls in not null columns.

What can be the cause of this warning?

Please advice.

Thanks

miwinter · Post by **miwinter** » Mon Aug 24, 2009 5:35 am

Can you post the metadata of your target table please?

chulett · Post by **chulett** » Mon Aug 24, 2009 5:52 am

ps. DRS stage <> speed up the process.

miwinter · Post by **miwinter** » Mon Aug 24, 2009 5:55 am

Switch to using the (Starship) Enterprise stage instead

chulett · Post by **chulett** » Mon Aug 24, 2009 5:58 am

Or some sort of bulk load process, unless that is what the DB2 API stage is already doing for you.

miwinter · Post by **miwinter** » Mon Aug 24, 2009 6:23 am

Absolutely :D

shalini11 · Post by **shalini11** » Tue Aug 25, 2009 12:49 am

The Enterprise stage is not working. It is giving some error like:

db2nodes.cfg file is not present

Is this an installation error?

ray.wurlod · Post by **ray.wurlod** » Tue Aug 25, 2009 12:53 am

Yes. Further, it's a DB2 installation/configuration error, not a DataStage installation error.

shalini11 · Post by **shalini11** » Tue Aug 25, 2009 5:02 am

Thanks for your response.

But why DRS stage is not working and throwing error. It should be able to load to any database.

miwinter · Post by **miwinter** » Tue Aug 25, 2009 5:08 am

I'll try again...

miwinter wrote:Can you post the metadata of your target table please?

As per Craig's comment too, what makes you think the DRS stage will be quicker than the API stage that took 5 1/2 hours?