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

ManualsBrandsHP ManualsServerHP NonStop G-Series

391

392

393

394

395

396

397

398

399

400

Performing Recovery Operations

HP NonStop SQL/MX Installation and Management Guide—523723-004

12-35

Using GOAWAY to Delete Damaged Objects

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

NonStop SQL/MX MXTOOL Utility 2.0

Reserved.

Operation successfully completed

Using GOAWAY to Delete Damaged Objects

SQL/MX files consist of two physical Guardian files: data fork and resource fork.

Normally, when the data fork is dropped, DP2 automatically drops the corresponding

resource fork. In some cases, either an orphaned resource fork or data fork can exist.

mxtool GOAWAY is an OSS command-line utility run from mxtool that removes

SQL/MX format file labels for both the resource and the data forks associated with a

Guardian file.

For more information about GOAWAY, including command syntax, see the SQL/MX

Reference Manual.

Recovering From SCF Commands

Incorrect use of SCF commands can cause serious and possibly irreparable

inconsistencies in an SQL/MX database.

If your site needs to use any of these SCF commands on a volume with SQL/MX

objects, you should first carefully plan a recovery:

•

ABORT DISK

•

ALTER DISK

Note. mxtool GOAWAY does not remove corresponding metadata entries and does

not support ANSI names. Use the MXCI SHOWLABEL command to identify the

Guardian file names that correspond to ANSI object names.