Neoview SQL Reference Manual (R2.4 SP2)

Table 1-1 Concurrent DDL/Utility Operation and File Access Modes
Access Mode
SERIALIZABLEREAD COMMITTEDREAD UNCOMMITTEDDDL Operations You Can
Start
WaitsAllowed
1
Allowed
1
ALTER TABLE attributes
1 DDL operation aborts the DML operation.
Table 1-2 compares DDL and utility operations with DML operations and shows DDL operations
you can start while DML operations are in progress:
Table 1-2 Concurrent DDL/Utility and DML Operations
DML Operation in Progress
UPDATE/ INSERT/
DELETE
SELECT EXCLUSIVESELECT SHARESELECT
UNCOMMITTED
DDL Operations You
Can Start
AllowedAllowedAllowedAllowed
1
ALTER TABLE
attributes
WaitsWaitsWaitsAllowed
1
ALTER TABLE other
WaitsWaitsAllowedAllowed
1
CREATE INDEX with
POPULATE
AllowedAllowedAllowedAllowedCREATE INDEX NO
POPULATE
WaitsWaitsAllowedAllowedCREATE TRIGGER
subject table
AllowedAllowedAllowedAllowedCREATE TRIGGER
referenced table
AllowedAllowedAllowedAllowedCREATE VIEW
WaitsWaitsWaitsAllowed
1
GRANT
WaitsAllowed
2
Allowed
2
Allowed
1
POPULATE INDEX
WaitsWaitsAllowedAllowed
1
REVOKE
Allowed
2
AllowedAllowedAllowedUPDATE
STATISTICS
1 DDL operation aborts the DML operation.
2 Allowed except during commit phase.
Table 1-3 compares DML operations you can start when DDL operations are in progress:
Table 1-3 Concurrent DML and DDL Operations
DML Operations You Can Start
UPDATE/ INSERT
DELETE
SELECT EXCLUSIVESELECT SHARESELECT
UNCOMMITTED
DDL Operations in
Progress
AllowedAllowedAllowedAllowed
1
ALTER TABLE
attributes
WaitsWaitsWaitsAllowed
1
ALTER TABLE other
WaitsWaitsAllowedAllowed
1
CREATE INDEX with
POPULATE
AllowedAllowedAllowedAllowedCREATE INDEX NO
POPULATE
30 Introduction