These commands take intent locks in Adaptive Server 15.0.2 when they update a system table:
create table
drop table
create index
drop index
create view
drop view
create procedure
drop procedure
create trigger
drop trigger
create default
drop default
create rule
drop rule
create function
drop function
create functional index
drop functional index
create computed column
drop computed column
select into
alter table (all versions)
create schema
reorg rebuild
If two or more of these commands simultaneously access or update the same system table, their intent locks do not conflict with each other so they do not block on the system table.
The sp_fixindex and sp_spaceusage system procedures have also been updated to provide more information about the row-locked catalogs. See Chapter 20, “Changes to System Procedures, Functions, and Commands.”
