Truncate Load Write property query

vivekreddy · Post by **vivekreddy** » Sun Feb 04, 2007 11:38 pm

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?

sud · Post by **sud** » Mon Feb 05, 2007 12:14 am

It invokes the DB2 fast load utility with the 'truncate' option. I think this will answer the reamining questions as well.

DSguru2B · Post by **DSguru2B** » Mon Feb 05, 2007 12:21 am

First of all, DB2 does not have TRUNCATE. Either its a delete or its a load from /dev/null or import from /dev/null.

vivekreddy · Post by **vivekreddy** » Mon Feb 05, 2007 12:30 am

I was referring to the truncate write mode for the load write method in DB2 Enterprise stage.

sud · Post by **sud** » Mon Feb 05, 2007 12:37 am

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.

DSXchange

Truncate Load Write property query

Truncate Load Write property query

Re: Truncate Load Write property query