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

refer to the DDL you saved earlier—either when the index was created or before the index
was dropped— to retrieve the Guardian names.
The saved DDL for a dropped table is stored in a file named
catalog.schema.table-yyyymmdd-hhmmss.ddl, where yyyymmdd-hhmmss is the
time when the table was dropped. In this case, the file is named
HRDATA.PERSNL.EMPLOYEE-20031114-160629.ddl. To use MXGNAMES to build the
list of files for the INFO DUMPS command, you must first transfer this file to the Guardian
space, and then use it as input to the MXGNAMES utility:
a. Retrieve the saved DDL:
/user/tandem/sqlmx/ddl: cp HRDATA.PERSNL.EMPLOYEE-
20031114-160629.ddl/G/DATA01/SUBVOLS/ddlfile
b. Use CTOEDIT to transfer this file to the Guardian space:
$DATA01 SUBVOL 15>ctoedit ddlfile,employee
c. Use MXGNAMES with the -showddl option, specifying the target Guardian file from Step
b:
$DATA01 SUBVOL 16>$system.zmxtools.mxgnames -
showddl=employee -tmf
(--Table HRDATA.PERSNL.EMPLOYEE--&
$DATA10.ZSDT5356.NG59FJ*,&
--Index XEMPNAME ON HRDATA.PERSNL.EMPLOYEE--&
$DATA10.ZSDT5356.JN9VFJ*,&
--Index XEMPDEPT ON HRDATA.PERSNL.EMPLOYEE--&
$DATA10.ZSDT5356.NPFH8J*&
--End of Table HRDATA.PERSNL.EMPLOYEE--&
)
Use this output to build the INFO DUMPS, DETAIL command as follows:
TMF 1> INFO DUMPS (--Table HRDATA.PERSNL.EMPLOYEE--&
$DATA10.ZSDT5356.NG59FJ*,&
--Index XEMPNAME ON HRDATA.PERSNL.EMPLOYEE--&
$DATA10.ZSDT5356.JN9VFJ*,&
--Index XEMPTDEPT ON HRDATA.PERSNL.EMPLOYEE--&
$DATA10.ZSDT5356.NPFH8J* &
--End of Table HRDATA.PERSNL.EMPLOYEE--&
),DETAIL
The dump entries for the data fork of the purged table (HRDATA.PERSNL.EMPLOYEE)
appear next. To conserve display space, these columns of the report are not shown: File
Name, Date-Time, Dump Type, Master, Data, and Media Type.
Dump Dump Media Media
... Serial... Status ... Status Name
------ ------- ------ -------------------------
... 70 ... invalid ... released \KRYPTON.$DATA01.ZT000070.F0000001
.
.
.
The dump status “invalid” that appears for each data fork and resource fork indicates
that the table was purged.
Similar INFO DUMPS, DETAIL commands for XEMPNAME and XEMPDEPT confirm that
they, too, were dropped.
4. Re-create the EMPLOYEE table and both of its indexes.
With the SAVE_DROPPED_TABLE_DDL attribute set ON, the script for re-creating the table is
saved in the OSS directory /usr/tandem/sqlmx/ddl in the file
HRDATA.PERSNL.EMPLOYEE-20031114-160629.ddl. Issue an MXCI OBEY command
to execute the commands in this file from a licensed MXCI process:
246 Performing Recovery Operations