SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Introduction
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
1-22
Concurrency
Utilities that update
metadata and read
and potentially write
user data online:
MODIFY with
SHARED access
UPDATE STATISTICS
All DML operations are
allowed.
Utilities that read
metadata can
only be performed
concurrently.***
Not allowed.
Utilities that update
data and potentially
change metadata:
FIXUP
FASTCOPY (target
table only)
DUP (target table only)
IMPORT using fast
load
MODIFY when
dropping a hash
partition
PURGEDATA
RESTORE
Not allowed. Concurrent
operations are not
allowed.
Not allowed.
Utilities that read and
update metadata, but
do not change user
data:
UPGRADE
DOWNGRADE
All DML operations. Utilities that only
read metadata.
Not allowed.
* 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 (page2of2)
Utility DML operations Other utilities
DDL
operations