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-22
Concurrency
* There are some exceptions. Dropping a partition from a hash partitioned table or index requires exclusive
access.
** The last phase of these operations requires exclusive access to the table or index, which prevents even
SELECT operations.
*** The last phase of the MODIFY operation requires exclusive access to the table or index, which prevents all
DDL and DML operations.
Table 1-5. Concurrency Limits on Utility Operations (page3of3)
Utility DML operations Other utilities
DDL
operations