SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

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
Example 2: Correcting Mismatched Timestamps
Several of the timestamps on table1 do not match the value on the label. To fix the problem, change
the redefinition timestamps:
mxtool FIXUP TABLE cat.sch.table1 -rt -d
Hewlett-Packard NonStop(TM) SQL/MX MXTOOL Utility 3.0
(c) Copyright 2003, 2004-2010 Hewlett-Packard Development Company, LP.
Operation successfully completed
262 Performing Recovery Operations