SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-17
Considerations for GOAWAY
resource fork). If you specify!, GOAWAY does not ask for confirmation but
performs the requested operation.
If you do not specify this option, GOAWAY returns with the name of the file it plans
to drop. You must confirm (YES) or reject (NO) this action. If you specify YES, the
operation continues to the next file that matches the list of files specified in the
guardian-file. If you specify NO, the operation is aborted on the particular file,
a message is generated, and the operation proceeds to the next file that matches
the list of files specified in guardian-file.
Considerations for GOAWAY
You should use GOAWAY only when no other method of getting rid of an object works.
If you use wild card options and GOAWAY fails after removing one or more files, these
files are not rolled back. They are permanently deleted.
You must be the super ID to run GOAWAY.
For more information about using GOAWAY, see the SQL/MX Installation and
Management Guide.
Examples of GOAWAY
•
Confirm a request to drop a file:
mxtool goaway \$DATA09.ZSDLLS6G.ZDFXPR00
***WARNING[20456] The following file will be removed
\FIGARO.$DATA09.ZSDLLS6G.ZDFXPR00. Are you sure? (ENTER YES
or NO):
yes
Goaway of file: \FIGARO.$DATA09.ZSDLLS6G.ZDFXPR00
successful
Goaway of file: \FIGARO.$DATA09.ZSDLLS6G.ZDFXPR01
successful
Ansi Name: CAT.SCH.MVS USED UMD
Ansi NameSpace: TA
Object Schema Version: 1200
•
Drop a file without confirming the drop:
mxtool goaway \$DATA09.ZSDLLS6G.WKPRKR00 !
Goaway of file: \FIGARO.$DATA09.ZSDLLS6G.WKPRKR00
successful
Goaway of file: \FIGARO.$DATA09.ZSDLLS6G.WKPRKR01
successful
ANSI Name: CAT.SCH.HISTOGRAM_INTERVALS
Ansi NameSpace: TA
Object Schema Version: 1200
Note. When the GOAWAY operation is completed, you must manually change the metadata
tables to remove the associated metadata, with a licensed MXCI process.