Example report: Full point-in-time recovery

The report example shows the batch invocation of full PITR (point-in-time recovery) of both the production and duplicate database.

FRD0000I  D A T A B A S E   R E C O V E R Y   F A C I L I T Y   01/14/2025 18:59                        Page 1
                                

D A T A B A S E   R E C O V E R Y   F A C I L I T Y   C O M M A N D S / C O N T R O L   S T A T E M E N T S
 
FRD7201I DBDSN001('NEWDS.DBOVLFPC.TESTDUP')                            
FRD7201I DBDSN002('IMSTEST')                            
FRD7201I DBDSN003('IMSTEST',,%DATE)                            
FRD7201I DBDSL001(DISP(OLD))                
FRD7201I DBDSL002(DISP(NEW),DBN(MYDB1))                
FRD7201I OUTPUT(BOTH)
FRD7201I LCLTIME(Y)
FRD7201I ADD DB(DBOVLFPC) DBATRB(DBDSN(001) DBDSL(001)) 
FRX7201I ADD AREA(DEDBDD01 DD01AR0) DBATRB(DBDSN(002) DBDSL(002)) 
FRX7201I ADD AREA(DEDBJN22 DB22AR2) DBATRB(DBDSN(003) DBDSL(002)) 
FRX7201I START ERROR(STOP) RCVTIME('2020.056 10:57:28.00')


D A T A B A S E    R E C O V E R Y    F A C I L I T Y    R E C O V E R Y   P A R A M E T E R S

PROCESS : RCVBOTH                                                     RCVCOPY OPTIONS  
SOURCE  : PRI                   RCVTIME  : 2020.056 10:57:28.00
READNUM : 03,03                 TYPE     : TSR                LOGNUM : 03,03       ICNUM : 03,03
ERROR   : STOP                  CHECK    : Yes                        OUTPUT  : Pro,Dup  
RCVTOKEN: DRF1                  TIME FMT : LCL
DRFPROC : DRFS                  LBI      : No                  SPSIZE  :     1024       CACHE   : No  

----------  Sort-Related Parameters  ----------                                
                                                                                
NUM     :        1             MAINSIZE:      30                 AVGRLEN :      256
FILSZ   :    21000             HIPRMAX : OPTIMAL                 ASPREF  :      DRFI
DYNALLOC:  SYSDALL , N/A                                                           

             
D A T A B A S E   R E C O V E R Y   F A C I L I T Y   S U M M A R Y   R E P O R T

Database   DD/Area    DSID        --------- Records Read ---------     Records    Subord.     Final
Name       Name                         IC          CA         Log     Written    Reg Name    Status

DBOVLFPC   VLOSAM01    1              1001          11        1006        1001    DRFS0001    Delete/define complete
DEDBDD01   DD01AR0     1                72           5         211           5    DRFS0002    Delete/define complete
DEDBJN22   DB22AR2     3                15           2         911         725    DRFS0003    Delete/define complete

SUBORDINATE ADDRESS SPACE LIST                                                                                     
                                                                                                                     
JOBNAME  JOBID    TYPE                                                                                             
-------  -------- ----
DRFI0001 STC00385 RSS
DRFI0002 STC00386 RSS
DRFI0003 STC00387 RSS

FRD0000I  D A T A B A S E   R E C O V E R Y   F A C I L I T Y   01/14/2025 18:59                        Page 2

D A T A B A S E   R E C O V E R Y   F A C I L I T Y   R C V C O P Y   R E P O R T

Database      DD / Area      New Data Set Name                                  Records      Volume
Name          Name           --------.--------.--------.--------.--------       copied       Serial

DBOVLFPC      VLOSAM01       NEWDS.DBOVLFPC.TESTDUP                               1001       222222
DEDBDD01      DD01AR0        IMSTEST.DD01AR0                                         5       222222
DEDBJN22      DB22AR2        IMSTEST.DB@@AR2.D2020056                              725       222222
FRD0000I    D A T A B A S E    R E C O V E R Y    F A C I L I T Y       01/14/2025  18:59


D A T A B A S E   R E C O V E R Y   F A C I L I T Y   D A T A   S E T   I / O   R E P O R T   
  
Recover to point: 2020.056 10:57:28.000000                                    

Image Copy Data Set Name                        Volume     IC DS      IC      ----------- Time Stamp Range -------------
---------.---------.---------.---------.-----   Serial   Read Count  Type     1st Record                    Last Record

IMSVS.DBOVLFPC.VLOSAM01.IC.IC105637             333333        1001    STD     
IMSVS.DEDBDD01.DD01AR0.IC.IC105637              333333          72   IC EXT.
IMSVS.DEDBJN22.DB22AR2.IC.IC105627              333333          15 T  IC2     
                                                                               
Change Accum Data Set Name                      Volume     CA DS              ----------- Time Stamp Range -------------
---------.---------.---------.---------.-----   Serial   Read Count           1st Record                    Last Record
                                                                              
IMSVS.CADSN.D20056.V00                          000000         18             2020.056 10:56:04.6    2020.056 10:59:08.3

Log Data Set Name                               Volume    Log DS     IMS      ----------- Time Stamp Range ------------- 
---------.---------.---------.---------.-----   Serial  Read Count  SYSID     1st Record                    Last Record

IMSVS.SLDSP.IMS1.D20056.T1056046.V00            000000       1222  IMS1       2020.056 10:56:04.6    2020.056 10:59:08.3   
 Prilog: 2020.056 10:56:04.6
IMSVS.RLDSP.IMS1.D20056.T1056046.V00            000000        106  IMS1       2020.056 10:56:04.6    2020.056 10:59:08.3
 Prilog: 2020.056 10:56:04.6

Following is an explanation of the batch invocation of full recovery example. There are 4 sections to the report:

COMMANDS / CONTROL STATEMENTS
This section displays the images of the control statements read from the SYSIN file:
- Two control statements were read from the SYSIN file.
- Recovery was requested for three databases.
- The ERROR(CONT) parameter was specified.
RECOVERY PARAMETERS
This section lists the parameters used to direct the recovery. The recovery parameters were supplied through one of the following three mechanisms, in ascending order of selection priority:
1. The IMS Database Recovery Facility defaults.
2. Explicitly coded in the FRXDRFxx member.
  - Although the values explicitly coded in the FRXDRFxx member do not appear in the report, these values are associated with the FRD7201I messages available in the SYSPRINT output from the recovery.
3. Explicitly coded in the SYSIN control statements.
  - These values can be seen in the Control Statements part of the report:
    PROCESS: RCVBOTH
    
    A DBDS-type recovery was selected.
    
    This parameter was not specified. The recovery facility default parameter was used.
    
    SOURCE: PRI
    
    The primary log and image copy data sets are to be used as the source of input for the recovery.
    
    This parameter was not specified. The recovery facility default parameter was used.
    
    READNUM: 03,03
    
    The maximum number of total devices to be used during recovery is 03. Of these, up to 03 can be tape devices.
    
    The maximum number of total devices and the number of allowable tape devices were specified in the FRXDRFxx member.
    
    ERROR: CONT
    
    Should an error be encountered on one database during recovery, processing should continue for other databases.
    
    This parameter was not specified. The recovery facility default parameter was used.
    
    RCVTOKEN: DRFI
    
    The recovery token used during recovery is DRF.
    
    This parameter was not specified. The recovery token used during a batch recovery is the job name.
    
    RCVTIME: Not Specified
    
    A recovery time was not specified.
    
    There is no default for the recovery time.
    
    TYPE: Full
    
    A full recovery was requested.
    
    This parameter was not specified. The recovery facility default parameter was used.
    
    CHECK: Yes
    
    A check will be performed to ensure that, should a DBDS be in a recovery group, all of the DBDSs within that recovery group need to be included in the list.
    
    This parameter was not specified. The recovery facility default parameter was used.
    
    LCLTIME: Yes
    
    Local time stamps will be used in messages and reports.
SUMMARY REPORT
This section presents statistics and summarizes the results of the recovery for each of the data sets associated with each database.

The three databases included in the recovery consisted of 5 database data sets. For each of these data sets, the following information is listed:

Database Name

The database name is listed.

DD/Area Name

The DD name associated with each data set is listed. In this case, all of the databases were full-function. Had any fast path databases been included, the associated Area name or names would have been listed.

DSID

The data set id number is listed.

Records Read

The number of records read from the image copy, change accumulation, and log data sets for application in the recovery are listed. If FlashCopy, the read count will be 'N/A'.

Records Written

The number of records written to the database data set is listed.

Subord. Reg name

The name of the started task which was responsible for sorting the records being written for the indicated data set is listed.

Final Status

The status of the conclusion of the recovery is listed.

SUBORDINATE ADDRESS SPACE LIST

JOBNAME and JOBID from the recovery sort subordinate address spaces (RSS) or utility address spaces (UAS) are listed.
DATA SET I/O REPORT
As was seen in earlier sections of the report, no recovery time was specified. This fact is reflected in the Recover to Point in this section.
The data set I/O report is divided into three sections:
1. Image Copy
  For each image copy data set used during the recovery, the following information is listed:
  
  Image Copy Data Set Name
  
  The data set name is listed.
  
  Volume Serial
  
  The volume or volumes upon which the data sets were found.
  
  Read Count
  
  The number of records read from the data set is listed.
  
  IC Type
  
  The image copy type is listed. Allowable values for this field include:
  
  STD
  
  Standard Image Copy
  
  IC2
  
  Image Copy 2
  
  IC EXT
  
  Extended Image Copy
  
  HISAM UNL
  
  HISAM Unload
  
  Time Stamp Range
  
  Although this heading appears, this field has no significance for image copy data sets.
2. Change Accum
  For each change accum data set used during the recovery, the following information is listed:
  
  Change Accum Data Set Name
  
  The data set name is listed.
  
  Volume Serial
  
  The volume or volumes upon which the data sets were found.
  
  Read Count
  
  The number of records read from the data set is listed. If FlashCopy, the read count will be 'N/A'.
  
  Time Stamp Range
  
  Although this heading appears, this field has no significance for change accumulation data sets.
3. Log
  For each log data set used during the recovery, the following information is listed:
  
  Log Data Set Name
  
  The data set name is listed.
  
  Volume Serial
  
  The volume or volumes upon which the data sets were found.
  
  Read Count
  
  The number of records read from the data set is listed.
  
  IMS SYSID
  
  The SYSID associated with the IMS which created the log is listed.
  
  Time Stamp Range
  
  The range of times which are covered by the log is listed. The time stamp on the first and last records in the log is listed.
  
  PRILOG:
  
  The PRILOG time listed in RECON for the log is listed.
  
  The difference between the log records read and the log records applied values in the recovery report are due to the update records read that generate multiple output records. The IMS Database Recovery Facility creates multiple update records for expedited processing when certain internal conditions are recognized.