SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Performing Recovery Operations
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
12-37
Using GOAWAY to Delete Damaged Objects
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
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

, ALTNAME

, LABEL

, VOLNAME

INITIALIZE DISK

RENAME DISK

STOP DISK

START DISK
ABORT DISK
The ABORT DISK command puts a disk into the STOPPED state, substate
HARDDOWN, but leaves the disk process running. Do not use the stopped drive to
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.