SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Introduction
HP NonStop SQL/MX Reference Manual—523725-004
1-16
Concurrency
Table 1-4 describes the effect of various DDL and utility operations on table
timestamps:
ALTER TABLE other Allowed
*
Waits Waits Waits
CREATE INDEX with
POPULATE
Allowed
*
Allowed Waits Waits
CREATE INDEX NO
POPULATE
Allowed Allowed Allowed Allowed
CREATE TRIGGER subject
table
Allowed Allowed Waits Waits
CREATE TRIGGER
referenced table
Allowed Allowed Allowed Allowed
CREATE VIEW Allowed Allowed Allowed Allowed
GRANT Allowed
*
Waits Waits Waits
MODIFY online operations Allowed
*
Allowed Waits Waits
MODIFY offline operations
***
Allowed
*
Allowed
**
Allowed
**
Waits
POPULATE INDEX Allowed
*
Allowed
**
Allowed
**
Waits
REVOKE Allowed
*
Allowed Waits Waits
UPDATE STATISTICS Allowed Allowed Allowed Allowed
**
* DDL operation aborts the DML operation
** Allowed except during commit phase
*** There are some exceptions. Dropping a partition from a hash partitioned table or index requires exclusive
access.
Table 1-4. Operations Effect on Table Timestamps (page 1 of 2)
Alter Operation Timestamp Updated
ALTER INDEX No
ALTER SQL/MP ALIAS No*
ALTER TABLE Yes, if you add columns or add or drop constraints
No, if you change attributes
ALTER TRIGGER No
BACKUP No
CREATE CATALOG No
CREATE INDEX Yes, if populated
CREATE PROCEDURE No
CREATE SCHEMA No
CREATE SQLMP ALIAS No
CREATE TABLE No
Table 1-3. Concurrent DML and DDL Operations (page2of2)
DML Operations You Can Start