SQL/MX 2.x Reference Manual (H06.04+)

Introduction
HP NonStop SQL/MX Reference Manual—540440-003
1-19
Concurrency
If you restore with PARTONLY (only one or more partitions are restored) or if you
restore the entire partition (that is, the partition did not exist in the target table before
restore), the redefinition time stamp of the table is updated.
If only data is restored (the partition existed in the target table before the restore), the
last open timestamp of partition data fork is updated, and the data modification
timestamp of the partition data fork is updated.
Table 1-5 lists concurrency limits on utilities.
Table 1-5. Concurrency Limits on Utility Operations (page 1 of 2)
Utility DML operations Other utilities
DDL
operations
Utilities that only read
metadata information:
EXPORTDDL
INFO
MXGNAMES
SHOWDDL
SHOWLABEL
VERIFY
All DML operations
(SELECT, UPDATE,
DELETE, INSERT) can be
performed concurrently.
Any utility in this
category can be
performed
concurrently.
Not
recommended.
Utilities that read both
metadata and user
data:
BACKUP
DUP (source table
only)
Only SELECT is allowed. Utilities that read
metadata can be
performed only
concurrently.
Not
recommended.
Utilities that read
metadata and update
user data:
IMPORT (not using
fast load)
All DML operations
(SELECT, UPDATE,
DELETE, INSERT) can be
performed concurrently.
If there are too many locks
on the partition, DP2
escalates to a table lock
which prevents concurrent
DML operations.
Utilities that read
metadata can
only be performed
concurrently.
Parallel imports
on the same table
are allowed.
Not
recommended.
Utilities that update
metadata and read
and write user data
offline:
MODIFY without
SHARED access*
POPULATE INDEX
Only SELECT is allowed.** Utilities that read
metadata can
only be performed
concurrently.
Not allowed.