SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Reorganizing SQL/MX Tables and Maintaining Data
HP NonStop SQL/MX Installation and Management Guide—523723-004
10-14
Using MODIFY to Manage Range-Partitioned Tables
and Indexes
where cat_name = 'SAMDBCAT'
)
)
for read uncommitted access
order by l.object_uid;
LOCK_NAME UTIL STATUS PROCESS_ID
----------------------- ----- ----------- ----------------
CUSTOMER_77179541_2217 PI 4 \FIGARO.$:3:321:2235264
As shown in the example, the query can return DDL lock name and process ID
information. Depending on the information the query returns, perform one of these
steps to recover a failed utility operation and reset a flag:
•
If the query returns no information, the MODIFY operation has completed.
However, the ORSERV process that MODIFY started has not completed.
Determine which partition still has an UNRECLAIMEDSPACE or INCOMPLETE
SQLDDL OPERATION flag set (see Verifying That a Flag Is Set in a Partition on
page 10-13) and perform a FUP STATUS on the partition, using its Guardian
name, to determine whether or not the reload process is running:
°
If the reload operation is still running, wait until it completes.
°
If the reload operation is not running, perform a FUP RELOAD on the partition
that has the UNRECLAIMEDSPACE or INCOMPLETE SQLDDL OPERATION
flag set.
•
If the query returns a process ID for the MXCMP process associated with the
MODIFY operation, run the TACL command STATUS process-name to determine
the current state of the process ID (running or not running) and the type of the DDL
lock returned by the query (active or inactive).
°
If the STATUS process-name command shows that the process is still
running, the returned lock information is for an active DDL lock. Wait until the
MODIFY operation completes. If the MODIFY operation starts an ORSERV
process to reset the UNRECLAIMEDSPACE or INCOMPLETE SQLDDL
OPERATION flag, wait until the reload operation completes.
°
If the STATUS process-name command returns no process information, the
returned lock information is for an inactive DDL lock. Run the RECOVER
command on the table or index associated with the MODIFY request to cancel
or resume the operation. The RECOVER command can start an ORSERV
process that resets either flag.
Using MODIFY to Manage Range-Partitioned Tables and Indexes
Use MODIFY to manage range-partitioned tables and indexes. You must manage
tables and indexes separately, regardless of their relationship. Both offline and online
operations are supported.
MODIFY supports online partition management for range-partitioned tables and
indexes where the partitioning key is a prefix of the clustering key.