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-19
Recovering Tables
TMF does not update or insert entries in the SQL catalog during a RECOVER
FILES operation for an SQL/MX object. As it performs the recovery, TMF will
attempt to automatically synchronize the objects’ create and redefinition
timestamps between the catalog and the file label on disk. If TMF cannot perform
this synchronization, it will display EMS Message 203 (with Subsystem Error 9038)
for each inconsistency, for example:
NonStop TMF on \PLUTO *0203* RECOVER FILES [57]
OnLineRestore Process #1 OnlineDumpMgmt: *WARNING*
TMF-9038: $DATA10.ZSDT5356.NPFH8J00: Unable to retrieve the CreateTime
and RedefTime for this object from disk. Using the values from the online
dump instead.
At the end of the recovery operation, you can use these EMS messages to
determine which files have timestamps on disk that are inconsistent with their
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).