Does the truncate load write property in the DB2 enterprise stage works as a truncate with no logging or is it that it works as a delete and write to the transaction log?
And if so where and how does it pick the commit interval from?
Truncate Load Write property query
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 43
- Joined: Mon Jan 15, 2007 10:53 pm
Truncate Load Write property query
Regards,
Vivek D. Reddy
__________________________________________
If knowledge can create problems, it is not through ignorance that we can solve them. - Isaac Asimov
Vivek D. Reddy
__________________________________________
If knowledge can create problems, it is not through ignorance that we can solve them. - Isaac Asimov
Re: Truncate Load Write property query
It invokes the DB2 fast load utility with the 'truncate' option. I think this will answer the reamining questions as well.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
-
- Participant
- Posts: 43
- Joined: Mon Jan 15, 2007 10:53 pm
Yes that's right. DsGuru2b was also right, DB2 doesn't have a truncate option like Oracle, however this option is there in the load utility and as far as I know, it drops the table and recreates it and goes ahead with the load.vivekreddy wrote:I was referring to the truncate write mode for the load write method in DB2 Enterprise stage.
![Question :?:](./images/smilies/icon_question.gif)
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.