Reorg compressed tablespace



IBM's flagship relational database management system

Reorg compressed tablespace

Postby haldur » Wed Apr 15, 2015 2:44 pm

I have a big compressed tablespace which I want to reorg with discard. Is it possible to do this without data beeing uncompressed?
Regards,
Haldur
haldur
 
Posts: 1
Joined: Wed Apr 15, 2015 1:54 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Reorg compressed tablespace

 

Re: Reorg compressed tablespace

Postby alexm » Tue Jun 16, 2015 11:19 pm

Hi haldur,

the documentation for the REORG utility answers your question: using REORG with DISCARD being specified decompresses the data (assuming you want your discarded records written to a file?).

Happy reading!
alexm
User avatar
alexm
 
Posts: 33
Joined: Wed Oct 13, 2010 6:40 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post