SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Introduction

HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004

1-19

Concurrency

Table 1-4 describes the effect of various DDL and utility operations on table

timestamps:

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 SEQUENCE 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 SEQUENCE No

CREATE TABLE No

CREATE TRIGGER Yes, of the table on which the trigger is defined

CREATE VIEW No

DUP No

FIXUP Yes

GRANT No

IMPORT Yes, if using fast load technique

INFO No

MODIFY, all forms Yes

mxexportddl No

MXGNAMES No

POPULATE INDEX Yes

Table 1-3. Concurrent DML and DDL Operations (page2of2)

DML Operations You Can Start