Compression of SPDS Tables

Reply
Occasional Contributor
Posts: 10

Compression of SPDS Tables

Hi All,

I want to compress all the SPDS tables existing under a SPDS library without moving them out? I kept compress-yes for respective spds library but data in it was loaded before I made this change.

Can anyone help me on this like how to compress the data? and syntax for the procs?

Quick reply would be appreciated...

Thanks,

AG

Super Contributor
Posts: 644

Re: Compression of SPDS Tables

Posted in reply to AvinashGinjupalli

I doubt its possible.  What you seem to be looking for is a "compress in place" option where the compressed data is written back to the original location.  This would be very risky as an interrupted operation would leave youwith unreadable data, so you would need to save a copy of the original data at the start.  And that is not going to save you I/O cycles.

Richard in NZ

Super User
Posts: 5,437

Re: Compression of SPDS Tables

Posted in reply to AvinashGinjupalli

I believe you could compress the tables without having them copied outside the SPDS domain (by using implicit/explicit SQL pass.thru). But you need to keep a copy of each table during the process (just to be safe - I think you could create a compressed version to replace the uncompressed - SPDS will keep a temporary copy until the replace operation is complete) .

Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 195 views
  • 0 likes
  • 3 in conversation