SQL/MP Installation and Management Guide

Performing Recovery Operations
HP NonStop SQL/MP Installation and Management Guide—523353-004
11-20
Recovery Example
copy of a FILEINFO, DETAIL statement for partitioned files, together with a copy of an
INVOKE statement, after the most recent change.
After you have re-created the partitions and recovered them with TMF, the timestamps
in the catalogs might be wrong for every partition. Because the redefinition timestamp
is the same for all partitions, you can use a single UPDATE statement for each catalog
involved.
If a mismatch is identified, however, you must update the creation timestamp
individually. Use care when updating because earlier versions of VERIFY do not name
the partitions having the mismatched timestamp. If you are using an earlier version,
follow the method described in Step 8 of the Recovery Example.
Recovery Example
For example, suppose that you have defined a table named EMPLOYEE on the
subvolume \HIL3.$DATA.PERSNL. A SQLCI DISPLAY USE OF command lists the
EMPLOYEE table and its dependent objects: EMPLIST (a protection view), MGRLIST
and ORDREP (two shorthand views), and XEMPDEPT and XEMPNAME (two
indexes):
>>DISPLAY USE OF $DATA.PERSNL.EMPLOYEE;
Object Name Type S P Owner Name Secure
-------------------------- ---- - - ----------- ------
Catalog Name
---------------------
0 \HIL3.$DATA.PERSNL.EMPLOYEE TA TEG .SAM GG00
$DATA.PERSNL
1 \HIL3.$DATA.PERSNL.EMPLIST PV TEG .SAM GG00
$DATA.PERSNL
1 \HIL3.$DATA.PERSNL.MGRLIST SV TEG .SAM GG00
$DATA.PERSNL
1 \HIL3.$DATA.PERSNL.XEMPDEPT IN TEG .SAM GG00
$DATA.PERSNL
1 \HIL3.$DATA.PERSNL.XEMPNAME IN TEG .SAM GG00
$DATA.PERSNL
1 \HIL3.$DATA.SALES.ORDREP SV TEG .SAM GG00
$DATA.SALES
U = Undefined node N = Node unavailable T = Unsupported type
@ = Node not in list * = Previously displayed ? = System error
Number of unique dependencies : 5
Number of direct dependencies : 5
Later, you discover that someone has issued a SQLCI DROP TABLE command that
purged the EMPLOYEE table:
>>DROP TABLE $DATA.PERSNL.EMPLOYEE;
---SQL operation complete.
You determine that this table was dropped inadvertently. To recover it:
1. Verify that the EMPLOYEE table has been removed from the database by
entering the SQLCI DISPLAY USE OF command:
>> DISPLAY USE OF EMPLOYEE;
*** ERROR from SQL [-1220]: The label of \HIL3.$DATA.PERSNL.EMPLOYEE