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-20
Recovering Tables
Verifying resource fork for partition: \KRYPTON.$DATA10.ZSDT5356.JN9V5J00
Verifying Partition Map: no partition map exists
Object verification complete for: HRDATA.PERSNL.EMPLOYEE
If no objects are identified as inconsistent, the recovery is complete and you should
go to Step 13. Otherwise, proceed to Step 10.
10. Use the mxtool FIXUP command to update the timestamps in the file labels to
reflect the values saved in the OBJECTS table in the SQL/MX metadata for all
objects identified as inconsistent in Step 9:
/USR/TANDEM/SQLMX/DDL:MXTOOL FIXUP TABLE HRDATA.PERSNL.EMPLOYEE -RT -D
NonStop SQL/MX MXTOOL Utility 2.0
(c) Copyright 2004 Hewlett-Packard Development Company, LP. All Rights
Reserved.
Operation successfully completed.
For further information about the mxtool utility, see the SQL/MX Reference
Manual.
11. Use the mxtool VERIFY utility once again, as in Step 9, to validate the entries in
the catalog against those in the file labels. If you find no mismatches, you know
that recovery of the table and its indexes is complete and your work is done.
Otherwise, return to Step 10.
/USR/TANDEM/SQLMX/DDL:MXTOOL VERIFY HRDATA.PERSNL.EMPLOYEE
NonStop SQL/MX MXTOOL Utility 2.0
(c) Copyright 2004 Hewlett-Packard Development Company, LP. All Rights
Reserved.
Verifying table: HRDATA.PERSNL.EMPLOYEE
Verifying label for partition: \KRYPTON.$DATA10.ZSDT5356.NG59FJ00
Verifying resource fork for partition: \KRYPTON.$DATA10.ZSDT5356.NG59FJ00
Verifying constraints: \KRYPTON.$DATA10.ZSDT5356.NGC59FJ00
Verifying Partition Map: no partition map exists
Verifying Index Map: \KRYPTON.$DATA10.ZSDT5356.NG59FJ00
Verifying index: HRDATA.PERSNL.XEMPDEPT
Verifying label for partition: \KRYPTON.$DATA10.ZSDT5356.NPFH8J00
Verifying resource fork for partition: \KRYPTON.$DATA10.ZSDT5356.NPFH8J00
Verifying Partition Map: no partition map exists
Verifying index: HRDATA.PERSNL.XEMPNAME
Verifying label for partition: \KRYPTON.$DATA10.ZSDT5356.JN9V5J00
Verifying resource fork for partition: \KRYPTON.$DATA10.ZSDT5356.JN9V5J00
Verifying Partition Map: no partition map exists
Object verification complete for: HRDATA.PERSNL.EMPLOYEE
12. If the CASCADE option was specified in the original DROP TABLE command, the
table’s views would also have been dropped along with the table and its indexes. If