SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Performing Recovery Operations
HP NonStop SQL/MX Installation and Management Guide—640325-001
12-36
Examples of Using FIXUP
•
\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
Partition
(add first key (1000) location \local.$data02 name
i1part2,
Add first key (4000) location \remove.$data02 name
i1part3);
3. Create three partitions with these names:
•
\LOCAL.$DATA02.ZSDJFKEO.SJDIFL00
•
\LOCAL.$DATA04.ZSDJFKEO.SJDIFM00
•
\REMOTE.$DATA04.ZSDFHKEO.SJDIFN00
CREATE INDEX index2 (col3) on table1
Location \local $data02 name i2part1
Hash partition (add location \local.$data04 name i2part2,
Add location \remote.$data04 name i2part3);
4. Create a work file with the name \LOCAL.$DATA02.ZSDLSKFE.IEOFKS00:
CREATE TRIGGER...
Example 1: Repairing a Broken Partition
Partition \LOCAL.$DATA02.ZSD1123U.SUEIFO00 is marked broken. To fix the
problem, turn off the audit bit, use TANDUMP to fix the problem, reset the broken bit,
and turn the audit bit back on:
mxtool FIXUP LABEL \LOCAL.$DATA02.ZSD1123U.SUEIFO00 -a=off
Determine the problem and use TANDUMP to fix it.
mxtool FIXUP LABEL \LOCAL.$DATA02.ZSD1123U.SUEIFO00 -rb
mxtool FIXUP LABEL \LOCAL.$DATA02.ZSD1123U.SUEIFO00 -a=on