DSXchange

My source and target are DB2

I have a job which is loading more than 10 million rows,i am using Clear table then insert rows in the target table,which is creating so many DB2 logs in the database. I have asked my DBA to turn of that or purge the logs which they are not intrested.

Is there any way in datastage to make the jobs not to create the logs in DB2 database..


Thanks.

No, since clearly you don't have the requisite privileges.

Hi,

when you do a clear and insert in DataStage a SQL delete and SQL inserts (one per row) are sent to the database. The database has to do the logging for transaction purposes (to be able to rollback).
This all work like desinged and is good though.

What you want to do is to Use Commitcount or the load utility - the load wirtes data direct to the disks - not by SQL - and therefor is not logged (but other mechanisms apply).
Ask your DBA

kind regards
Michael