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

Performing Recovery Operations
HP NonStop SQL/MX Installation and Management Guide—544536-007
12-20
Recovering Tables
timestamps in the SQL catalog. You must then manually perform the
synchronization for these objects, as explained in Step 10.
Alternatively, you can use the mxtool VERIFY utility to list the inconsistencies
between the object descriptions in the file labels and in the SQL/MX metadata:
/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
Inconsistency found:
*** ERROR[20760] The redefinition timestamp (211935615169948888) defined
on the label does not match the time (211935867787362245) defined in the
metadata for Guardian file (\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
Inconsistency found:
*** ERROR[20760] The redefinition timestamp (211935615168385004) defined
on the label does not match the time (211935867783457892) defined in the
metadata for Guardian file (\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
Inconsistency found:
*** ERROR[20760] The redefinition timestamp (211935615169978573) defined
on the label does not match the time (211935867787362245) defined in the
metadata for Guardian file (\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
If no objects are identified as inconsistent, the recovery is complete and you should
go to Step 14. 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