HP 3000 Manuals

DBChange Plus User's Guide

Recovering a Data Set 

In the previous example, you deleted the data set BINNUM-MASTER from the
ORDERS database.  To recover it, use the RECOVER SET command.

The position in the data set list where the recovered data set is placed
depends on whether the original data set was actually part of the
database or whether it was only stored in the change file.  (A data set
is only stored in the change file when it has been added by the DBCPLUS
program but DBAPLUS has not yet been used to apply it to the database.)
If the DBAPLUS program has not yet been run, then the recovered data set
is inserted at the end of the data set list.  If the original data set
was actually part of the database, then it is reinserted in its original
place in the data set list.  (If you need to change the order of the data
sets, use the REORDER SET command.  Refer to "Reordering a Data Set"
later in this chapter.)


       NOTE 

         *   Once you run the DBAPLUS program, you cannot recover a
             deleted data set.

         *   If you delete a data set and then add a new data set with
             the same name, you cannot recover the original data set.


In the following example, the data set BINNUM-MASTER is recovered.  The
DBCPLUS program returns a message confirming recovery of the deleted data
set.

     >recover set binnum-master 
      Recovery of data set accepted.

     >

Refer to "RECOVER SET" in chapter 10, "DBChange Plus Commands," for a
detailed description of the command syntax and parameters.

If you want to verify the recovery of the deleted data set, use the
REVIEW SETS command.  In the following example, the @ parameter is used
to display all the data sets in the ORDERS database.  Because the data
set BINNUM-MASTER was in the change file and the DBAPLUS program had not
been run, the data set is inserted at the end of the data set list.  The
path connecting the master data set BINNUM-MASTER to the detail data set
INVENTORY cannot be recovered.  You must specifically add a path back in
to the data set using the ADD PATH command.

     >review sets @  

     REVIEW SETS:

       Set                                Blk  Blk  Dev
       No. Data Set Name  Type Capacity   Fac  Max  Class    Security
       --------------------------------------------------------------

       1   DATE-MASTER      A  365        19   496   DISK1
       2   CUSTOMER         M  201        10   640   DISK1   (14/11,18)
       3   PRODUCT          M  300        16   498   DISK1   (13,14/12,18)
       4   SUP-MASTER       M  201        12   505   DISK1   (13/12,18)
       5   INVENTORY        D  450        15   481   DISK2   (12,14/13,18)
       6   SALES            D  500        10   371   DISK2   (11/14,18)
       7   BINNUM-MASTER    A  220        12   0     DISK1   (14/11,18)  <---- * 
           No paths defined for auto master set  (DBC 548).
           No fields defined for data set  (DBC 547).

     *data set recovered 

MPE/iX 5.0 Documentation