Recovery to a point in time

You can specify to recover to a point in time by entering the log RBA/LRSN or choosing a point-in-time from a list. If you know the RBA or LRSN to which you want to recover, enter it in the Log RBA/LRSN field. To select a recovery point from a list, follow these steps.

1. On the Recover Utility Log Options panel, enter Y in the Select point-in-time field and press Enter.
2. On the Point-In-Time Selection panel, specify selection criteria in the header fields and press Enter.
   A list of RBAs or LRSNs that match your selection criteria is displayed. The RBA/LRSNs were recorded in SYSIBM.SYSCOPY and the Db2 Automation Expert SYSCOPY table in that time period. The following figure shows a sample list of recovery points:

    AUTOXPRT V1R1   -------- Point-In-Time Selection -------- 2023/10/20  09:21:57 
    Option  ===>                                                  Scroll ===> CSR  
    -------------------------------------------------------------------------------
    Line Commands: S - Select                             Row 1 of 277          +> 
    -------------------------------------------------------------------------------
     Start  2023-09-25-01.00.00.000000  Database    N*         Db2 Subsystem: SS01 
     End    2023-10-25-01.28.43.313983  Space name  TS*                            
    -------------------------------------------------------------------------------
    Cmd Timestamp                  RBA/LRSN             Database Spacenam Dsnum    
        2023-10-04-17.02.43.406244 00DDFFA9E6A0B2907000 NMHACHNG TSCHNG01     0    
        2023-10-04-17.02.43.406852 00DDFFA9E7334C2D2E00 NMHACHNG TSCHNG01     0    
        2023-10-04-17.03.31.179261 00DDFFAA145749062A00 NMHACHNG TSCHNG01     1    
        2023-10-04-17.03.31.179591 00DDFFAA145749062A00 NMHACHNG TSCHNG01     2    
        2023-10-04-17.03.31.179889 00DDFFAA145749062A00 NMHACHNG TSCHNG01     3    
        2023-10-04-17.03.31.179974 00DDFFAA145749062A00 NMHACHNG TSCHNG01     4    
        2023-10-04-17.03.31.180020 00DDFFAA14C2AB351A00 NMHACHNG TSCHNG01     1    
        2023-10-04-17.03.31.180020 00DDFFAA14C2AB351A00 NMHACHNG TSCHNG01     2    
        2023-10-04-17.03.31.180020 00DDFFAA14C2AB351A00 NMHACHNG TSCHNG01     3    
        2023-10-04-17.03.31.180020 00DDFFAA14C2AB351A00 NMHACHNG TSCHNG01     4    
        2023-10-05-13.29.56.745812 00DE00BC344EB6B13400 NMHAQA26 TSQA2602     1    
        2023-10-05-13.29.56.747659 00DE00BC344EB6B13400 NMHAQA26 TSQA2602     2    
        2023-10-05-13.29.56.747730 00DE00BC344EB6B13400 NMHAQA26 TSQA2602     3    
                                                                                   
                                                                                   

   Scroll right to see the event that caused the log entry. The Description column lists the reason for the log entry, such as QUIESCE WRITE(YES) or COPY FULL REORG LOG(NO).
3. To select an RBA or LRSN, enter S in the Cmd field next to the timestamp and press Enter.
   The recovery point information is transferred to the Log RBA/LRSN and Log timestamp fields on the Recover Utility Log Options panel, as shown in the following figure:

    AUTOXPRT V1R1 ------- Recover Utility Log Options ------- 2023/10/20  09:22:38 
    Option  ===>                                                                   
                                                                                   
      Creator: TWUSR      Name: TEST                             User: TWUSR       
                                                        Db2 Subsystem: SS01        
       Object event  . . . . . . . .    (Q - Quiesce, blank)                       
       Event generation  . . . . . . 00 (00  -1  -2  -3  ...  -9)                  
       Select point-in-time  . . . . N  (Yes/No)                                   
        Log RBA/LRSN . . . . . . . . 00DDFFA9E6A0B2907000 (blank = current)        
        Log timestamp  . . . . . . . 2023-10-04-17.02.43.406244                    
       Select RESTOREBEFORE  . . . . N  (Yes/No)                                   
        RESTOREBEFORE Log RBA/LRSN                        (blank = none)           
        RESTOREBEFORE Log timestamp                                                
       Backout . . . . . . . . . . . N   (Yes/No)                                  
       Reuse existing data sets  . . N  (Y - Yes, N - No, L - Log only)            
       Parallel object restores  . . N  (Yes/No)                                   
       Max nbr of parallel objects   0  (0 = optimal)                              
       Nbr of dynamic tape drives    0  (0 = optimal)                              
       From Dump . . . . . . . . . . N  (Yes/No)                                   
       Dump Class  . . . . . . . . .                                               
       FLASHCOPY_PPRCP . . . . . . . N  (N - No, P - Pnmo, M - pMp, R - pmR)       
                                                                                   
                                                                                   
                                                                                   

   Note that the timestamp appears as read only.

   The Backout field allows you to specify the recovery of objects to a prior point in time by a log-only backout. Enter N in this field to specify that a BACKOUT will not be started. Enter Y in this field to use the log to backout changes made since the log point that is specified in the RECOVER syntax by the TOLOGPOINT or TORBA options.