By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,222 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

DB2 High Performance Unload + remove unwanted data

P: n/a
Hello,

Linux RedHat AS4 running DB2 V8 FP15.

I have very large tables (100 Million+ rows), and I only need to keep
6 months of data online/available. The tables have a timestamp field.

I was hoping that DB2 High Performance Unload V3 allow me to 'extract
and delete' data from tablespaces very quickly, but unfortunately it
is only able to extract/export data (much faster than regular 'export'
statements).

Silly question: How do I efficiently remove unwanted data from very
large tables, without having to take my applications down ? DELETE
statements are fairly slow/unefficient with large tables.

PS: High Performance Unload is a great tool. You can extract tables
(full or parts of it) from a backup image. It is a must have for all
DBAs.

Thanks

Nov 12 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.