Sybase 9.0.2.3534

What is lock type SPA0000 and could this cause serious
issues?

Thanks

If the lock name is NULL then SPA represents a schema lock on that
table; no other connection can modify the schema for that table (ie via
ALTER TABLE) or can acquire an exclusive lock on that table (ie for LOAD
TABLE) until the connection that holds that lock has performed either
COMMIT or ROLLBACK.

Glenn

Herman Miller wrote:
--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport