Ability to truncate?

[pmcmicha]

In DB2, are you able to truncate a table (meaning wipe all data clean without having to drop it) and not log those actions? From what I have read, this functionality is not built into DB2. You can run deletes against the table, but these are all logged transactions. I have a few massive deletes to run which I do not want logged since the data is stored in a flat file which could be recovered if needed and since I do not want to monitor the log size while this is occuring. So is there some other way to make this happen? Thanks in advance.

 

[sathyarams]

http://www.tek-tips.com/faqs.cfm?spid=178&sfid=2955

See if the link helps

Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8