Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

reclaim storage in DB2 9.7 with HWM


I've recently upgraded our ECC system from DB2 9.1 to 9.7.

As I could check from documentation, I'm not able to reduce HWM from tablespaces since they were created from an older version of DB2 prior to 9.7.

To workaround this issue I can export-import database or use DB6CONV for massive conversion.

Since I want to reduce a lot of tablespaces HWM, my strategy is:

1. export database

2. recreate tablespaces

3. import database

My doubt is, is there any other strategy less painful?

How can I recreate tablespaces?


FIlipe Vasconcelos

Former Member
Not what you were looking for? View more on this topic or Ask a question