Wei Jiang <[EMAIL PROTECTED]> 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
