Recovering to a file

You can specify recovery to a particular image copy file (data set). If you know the image copy data set name, enter it in the Copy dataset name field. If the data set is not cataloged, enter the volume serial number, and if the recovery file is on tape, enter the file sequence number. To select a data set from a list of image copies, follow the steps in this topic.

About this task

When recovering to a file, only one image copy data set can be selected at a time.

Procedure

  1. On the Recover Utility Copy Options panel, enter Y in the Select recovery file field and press Enter.
  2. On the Recovery File Selection panel, specify selection criteria in the header fields and press Enter.
    A list of image copies for that time period and that meet the object selection criteria is displayed. The following figure shows a sample list of image copies:
    Figure 1. Sample image copies on the Recovery File Selection panel
     AUTOXPRT V1R1   -------- Recovery File Selection -------- 2023/10/20  09:41:32 
     Option  ===>                                                  Scroll ===> CSR  
     -------------------------------------------------------------------------------
     Line Commands: S - Select                                                      
     -------------------------------------------------------------------------   +> 
      Database    *         Start  2023-01-22-08.00.00.000000   Db2 Subsystem: SS01 
      Space name  *         End    2023-07-22-08.23.48.622460                       
     -------------------------------------------------------------------------------
     Cmd Database Spacenam Dsnum Timestamp                  Description             
         DBAINLOB SAINLOB1     0 2023-06-17-06.25.08.656078 COPY FULL REORG LOG(NO) 
         DBAINLOB SAINLOB1     0 2023-06-17-06.34.27.904759 COPY FULL REORG LOG(NO) 
         DBAINLOB SAINLOB1     0 2023-06-17-06.42.56.128031 COPY FULL REORG LOG(NO) 
         DBAINLOB SAINLOB1     0 2023-06-17-06.45.31.639367 COPY FULL REORG LOG(NO) 
         DBAINLOB SAINLOB2     0 2023-06-17-06.25.13.822099 COPY FULL REORG LOG(NO) 
         DBAINLOB SAINLOB2     0 2023-06-17-06.34.29.005081 COPY FULL REORG LOG(NO) 
         DBAINLOB SAINLOB2     0 2023-06-17-06.42.57.255740 COPY FULL REORG LOG(NO) 
         DBAINLOB TPAINLOB     0 2023-06-17-06.27.25.161581 COPY FULL REORG LOG(NO) 
         DBAINLOB TPAINLOB     0 2023-06-17-06.34.33.040698 COPY FULL REORG LOG(NO) 
         DBAINLOB TPAINLOB     0 2023-06-17-06.43.00.194373 COPY FULL REORG LOG(NO) 
         DBALA846 TSP          0 2023-07-09-14.22.38.537811 COPY FULL YES           
         DBALA846 TSPBG        0 2023-07-09-14.22.38.442851 COPY FULL YES           
         DBALA846 TSRP         0 2023-07-09-14.22.38.483560 COPY FULL YES           
                                                                                    
                                                                                    
    Scroll right to see information about the image copy.
  3. To select an image copy, enter S in the Cmd field next to the image copy and press Enter.
    The data set information is transferred to the Copy data set name and other copy information fields on the Recover Utility Copy Options panel, as shown in the following figure:
    Figure 2. Copy information transferred to Recover Utility Copy Options panel
     AUTOXPRT V1R1 ------- Recover Utility Copy Options ------ 2023/10/20  09:42:36 
     Option  ===>                                                                   
                                                                                    
       Creator: TWUSR      Name: SAMPLE RECOVER PROFILE           User: TWUSR       
                                                         Db2 Subsystem: SS01        
        Object event  . . . . . . . L  (L - Last, F - Full, I - Incr, blank)        
        Event generation  . . . . . 00 (00 -1  -2  -3  ...  -9)                     
                                                                                    
        Select recovery file  . . . N  (Yes/No)                                     
        Copy data set name  . . . . CSMINIA.DAJ7116.DBAINLOB.SAINLOB1               
        Copy volume serial number                                                   
        Copy file sequence number                                                   
        Copy timestamp  . . . . . : 2023-06-17-06.25.08.656078                      
                                                                                    
        Reuse existing data sets  . N  (Yes/No)                                     
                                                                                    
                                                                                    
                                                                                    

    The corresponding copy timestamp is read only. If the selected image copy data set was not cataloged, the volume serial appears in the Copy volume serial number field. If the image copy was on a tape device, the tape volume serial and file sequence number are listed on the panel.