Skip to Content
0
Jun 11, 2020 at 03:51 PM

Select query getting declined on a table that has reorg compact is under execution on the same table

110 Views

Hi All,

In my client environment a table with DRL(not partitioned) has reorg compact under execution and at the same time when I tried to perform a select operation it was declined. ASE 15.7 SP136sp-lock.txt

Personal environment - I tried replicating the same by creating a table - Test(columns a ,b and rows 1million with no indexes), in a sample database in test environment and triggered reorg compact. At the same time I am able to perform select, update, delete and insert operations on table Test though I see the locktype as Ex_intent from sp_lock for the reorg SPID on Test. --- Details attached. Test:16.0 SP03 PL08

Hence I would like to get clarification on the below.
1.What is the actual behaviour of reorg compact?
2.Why sp_lock is showing Ex_intent and still allowing Select and DML? ---Checked same by keeping DRL and DPL.
3.Why in production environment just a select operation got failed?
4.Are there any known issues with reorg compact on 15.7 SP136?

Please advise.

Regards,
Dilip Voora

Attachments

sp-lock.txt (7.9 kB)