SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities

HP NonStop SQL/MX Reference Manual—540440-003

5-16

GOAWAY Operation

Considerations for GOAWAY

Examples of GOAWAY

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

files associated with an SQL/MX object.

SQL/MX files consist of two physical Guardian files, the data fork and the 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 might exist.

GOAWAY does not remove corresponding metadata entries and does not use ANSI

names.

Syntax Description of GOAWAY

guardian file

specifies the Guardian file to be removed. If guardian-file is not an SQL/MX

object, GOAWAY returns an error. You must fully qualify the file name with the

volume and subvolume name. ANSI names are not permitted.

In this four-part name, node is the name of a node of a NonStop server, $volume

is the name of a disk volume, subvol is the name of a subvolume that begins with

the letters ZSD, and filename is the automatically generated name of a Guardian

table that ends with “00” or “01” (zero zero or zero one).

If you do not specify \node, the default is the Guardian system named in your

=_DEFAULTS define. If you specify \node, it must be the local system or

GOAWAY will return an error. GOAWAY does not drop labels on remote systems.

You can use the “*” Guardian wild card in the volume, subvolume, and file name.

If guardian-file does not exist or is inaccessible, an error is returned.

If the Guardian file system encounters an error while searching for files, GOAWAY

returns an error. If guardian-file is locked, GOAWAY tries for 90 seconds, and

then returns a timeout message.

{-df | -rf | -both}

directs GOAWAY to drop a single Guardian file (either a data fork or a resource

fork), or both.

GOAWAY guardian-file [{-df | -rf | -both}] [-s] [!]

guardian-file is

[\node.]volume.subvolume.filename