SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-66
Concurrency
WITH SHARED
ACCESS
A A Wait Wait
Timestamp change A
1
Wait Wait Wait
No timestamp change A A A Wait
CREATE
CONSTRAINT
A
1
Wait Wait Wait
DEFERRED A
1
Wait Wait Wait
CREATE INDEX A
1
A Wait Wait
WITH SHARED
ACCESS
A A Wait Wait
UPDATE
STATISTICS
A
1
Wait Wait Wait
UPDATE
STATISTICS
Scan phase A A Wait Wait
Change timestamp A
1
Wait Wait Wait
DML Operations You Can Start
DDL Operations
in Progress
SELECT
BROWSE
SELECT
SHARED
SELECT
EXCLUSIVE
DELETE/INSERT
UPDATE
ALTER
WITH SHARED
ACCESS
A
2
A
2
A
2
A
2
Timestamp change A1 Wait Wait Wait
No timestamp chg A A A A
CREATE
CONSTRAINT
Scan phase A A Wait Wait
Change timestamp A
1
Wait Wait Wait
DEFERRED
Change timestamp A
1
Wait Wait Wait
Scan phase A A A A
CREATE INDEX
WITH SHARED
ACCESS
A
2
A
2
A
2
A
2
DML Operations You Can Start
DDL Operations
in Progress
SELECT
BROWSE
SELECT
SHARED
SELECT
EXCLUSIVE
DELETE/INSERT
UPDATE
Table C-5. Summary of Concurrent DDL and DML Operations (page 2 of 3)