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.
DB2 logs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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