Page 1 of 1
Truncate Load Write property query
Posted: Sun Feb 04, 2007 11:38 pm
by vivekreddy
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?
Re: Truncate Load Write property query
Posted: Mon Feb 05, 2007 12:14 am
by sud
It invokes the DB2 fast load utility with the 'truncate' option. I think this will answer the reamining questions as well.
Posted: Mon Feb 05, 2007 12:21 am
by DSguru2B
First of all, DB2 does not have TRUNCATE. Either its a delete or its a load from /dev/null or import from /dev/null.
Posted: Mon Feb 05, 2007 12:30 am
by vivekreddy
I was referring to the truncate write mode for the load write method in DB2 Enterprise stage.
Posted: Mon Feb 05, 2007 12:37 am
by sud
vivekreddy wrote:I was referring to the truncate write mode for the load write method in DB2 Enterprise stage.
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.
![Question :?:](./images/smilies/icon_question.gif)