How to roll-out old data in V8 EEE, migrated to V9.5 is not anoption
in [DB2]
|
Prev: How to roll-out old data in V8 EEE, migrated to V9.5 is not an option
Next: Top 10 Technical requirements for In-Memory Reporting
From: Helmut Tessarek on 27 May 2010 01:36 > Is there a better way to do this ? No, not with 8.1. > how do we reclaim the space left open by the deletes ? Can you REORG > it like you would on a regular table ? Yes you will have to do a reorg. Check the reorg command reference at: http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/core/r0001966.htm You won't be able to lower the HWM in the tablespace though. Please advise the customer that 8.1 has been out of support for over a year now. If he runs into any problem, he is on his own. -- Helmut K. C. Tessarek DB2 Performance and Development /* Thou shalt not follow the NULL pointer for chaos and madness await thee at its end. */ |