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?