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
Reorg compressed tablespace
Previous topic • Next topic • 2 posts
• Page 1 of 1
Reorg compressed tablespace
by haldur » Wed Apr 15, 2015 2:44 pm
- haldur
- Posts: 1
- Joined: Wed Apr 15, 2015 1:54 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: Reorg compressed tablespace
by 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
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
-
alexm - Posts: 35
- Joined: Wed Oct 13, 2010 6:40 pm
- Has thanked: 0 time
- Been thanked: 0 time
Previous topic • Next topic • 2 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- When REORG TABLESPACE getting ABEND=S213
by pavelbely » Thu Mar 15, 2012 2:36 pm - 7 Replies
- 6733 Views
- Last post by pavelbely
Fri Mar 16, 2012 7:05 pm
- When REORG TABLESPACE getting ABEND=S213
-
- ADM5510E tablespace full in an autoextend tablespace
by Riddick » Tue Sep 13, 2022 1:44 am - 1 Replies
- 1859 Views
- Last post by engh
Wed Sep 21, 2022 2:29 pm
- ADM5510E tablespace full in an autoextend tablespace
-
- Reorg with Discard and CLOBs
by ljcornwell » Tue Jul 20, 2010 12:56 am - 0 Replies
- 1987 Views
- Last post by ljcornwell
Tue Jul 20, 2010 12:56 am
- Reorg with Discard and CLOBs
-
- Reorg SYSIBM tables to reduce extents (XT) - change priqty &
by TechnoCaveman » Thu Feb 17, 2022 7:46 pm - 2 Replies
- 3037 Views
- Last post by sergeyken
Thu Sep 22, 2022 4:49 pm
- Reorg SYSIBM tables to reduce extents (XT) - change priqty &
-
- DB2 checkpending tablespace
by Lightning Lad » Mon Feb 15, 2010 8:18 pm - 0 Replies
- 1862 Views
- Last post by Lightning Lad
Mon Feb 15, 2010 8:18 pm
- DB2 checkpending tablespace