SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-67
Concurrency
Scan phase A A Wait Wait
Change timestamp A
1
Wait Wait Wait
A Allowed
Wait Started operation waits for the operation in progress to complete. The waiting operation might also
time out.
1 DDL operation aborts the DML operation
2 Allowed except during commit phase
Table C-6. ALTER Operation Effects on Timestamps
ALTER Operation
Timestamp
Updated
Timestamp
Unaffected
ALTER INDEX
ADD/DROP PARTITION X
RENAME X
File attributes X
ALTER TABLE
ADD COLUMN X
ADD/DROP PARTITION X
COLUMN HEADING X
File attributes X
RENAME X
Security attributes X
ALTER VIEW
COLUMN HEADING X
RENAME X
Security attributes X
File attributes and whether you can alter them for tables (T) or indexes (I) are:
ALLOCATE T, I
AUDIT T
AUDITCOMPRESS T, I
BUFFERED T, I
LOCKLENGTH T, I
MAXEXTENTS T, I
RESETBROKEN T, I
SERIALWRITES T, I
TABLECODE T, I
VERIFIEDWRITES T, I
Table C-5. Summary of Concurrent DDL and DML Operations (page 3 of 3)