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

Performing Recovery Operations
HP NonStop SQL/MX Installation and Management Guide—523723-004
12-15
Recovering Tables
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.