Yes that's the one I am calling and the space is not reclaimed.
________________________________ From: Knut Anders Hatlen <[email protected]> To: Derby Discussion <[email protected]> Sent: Thursday, September 24, 2009 4:00:52 AM Subject: Re: Horrible performance - how can I reclaim table space? T K <[email protected]> writes: > BTW, I have to ask this question: how exactly do we define OFFLINE > compression? I assume I still bring the database up and call the compression > stored proc from ij, but no one else connects, correct? When people talk about offline compression, I think they mean the SYSCS_UTIL.SYSCS_COMPRESS_TABLE routine, as opposed to SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE. Probably, the use of online/offline when talking about compression is due to confusion with the backup terminology. -- Knut Anders
