db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: SYSCS_UTIL.SYSCS_COMPRESS_TABLE
Date Thu, 27 Nov 2008 09:54:20 GMT
Wei Jiang <_weijiang_@yahoo.com> writes:

> Hi,
>
> Can I use SYSCS_UTIL.SYSCS_COMPRESS_TABLE and
> SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE when the database is working
> with insert/delete/update?

Yes, that's supposed to work. SYSCS_COMPRESS_TABLE will obtain an
exclusive lock on the table, which means that it will wait until all
transactions that are currently accessing the table have released their
locks, and it will block new transactions from accessing the table until
it has completed the compress operation.

-- 
Knut Anders

Mime
View raw message