Symptom
- ALTER TABLE ... LOCK command executed to change the lock scheme for a large table may run for a lengthy time
- CREATE CLUSTERED INDEX command may run for a lengthy time
- ALTER TABLE ... LOCK or CREATE CLUSTERED INDEX or DROP INDEX command fails (possibly after some hours) with ASE error 14127:
Msg 14127, Level 16, State 2:
Server 'SYBASE', Line 1:
Cannot drop or modify partition descriptor database 'mydb' (23), object 'mytable' (430621546), index 'mytable' (0), partition 'mytable_430621546' (430621546) as it is in use. Please retry your command later. Total reference count '8'. Task reference count '4'.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) all versions
Product
Keywords
"CREATE CLUSTERED INDEX" , "alter lock scheme" , "alter table lock", "drop index" , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Product Enhancement
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.