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

Performing Recovery Operations
HP NonStop SQL/MX Installation and Management Guide—544536-007
12-35
Examples of Using FIXUP
Changing Catalog, Schema, and Object UIDs
Every time a partition for a table or index is created, its related catalog, schema, and
object UID is stored in the resource fork. If accidentally dropping a table makes it
necessary to recover the table from scratch, you use the saved DDL information to re-
create the table and recover the privileges in the metadata, and then execute the TMF
RECOVER FILES command to recover the file label, data, and resource fork.
The new metadata will now have a new object UID, and the data and resource fork will
have the old object UID. Use the VERIFY command to confirm that the object UID in
the metadata tables does not match the object UID in the resource fork.
Use the FIXUP command with the -ru option to make the UID values in the resource
fork match the UID values in the metadata. FIXUP replaces the catalog, schema, and
object UIDs in the resource fork with the UIDs found in the metadata. For example:
mxtool FIXUP TABLE mycat.mysch.FIXUPtable -ru -d
For more information about FIXUP command syntax, see the SQL/MX Reference
Manual.
Examples of Using FIXUP
Suppose that table1 is located in the catalog cat and the schema sch and has three
partitions. Two of the partitions are located on the local node, \local. The third partition
is located on a remote node, \remote, and contains a trigger that requires a trigger
temporary table, which is located on the local node. Two indexes are also associated
with the table: index1 and index2. Each index has three partitions organized similarly to
those of the table.
1. Create three partitions with these names:
•
\LOCAL.$DATA02.ZSD1123U.SUEIFO00
•
\LOCAL.$DATA01.ZSD1123U.SUEIGO00
•
\REMOTE.$DATA01.ZSD1123U.SUEIHO00
CREATE TABLE cat.sch.table1
(Col1 int not null primary key,
Col2 int not null,
Col3 timestamp not null no default, Col4 char (20))
Partition
(Add first key (1000) location \local.$data01 name part2,
Add first key (2000) location \remote.$data01 name part3)
Location \local.$data02 name part1;
2. Create three partitions with these names:
•
\LOCAL.$DATA03.ZSDWUEIR.SUDIFO00
•
\LOCAL.$DATA02.ZSDWUEIR.SUDIFP00
•
\REMOTE.$DATA02.ZSDWUEIR.SUDIFQ00
CREATE INDEX index1 (col2) ON table1 Location
\local.$data03 name i1part1