19.6 Database recovery utility process results listing

The following shows an example of the process results output files for the database recovery utility.

pdrstr(VV-RR)     ***** DB RECOVERY *****   1995-05-16 11:35:35 [1] utl3 [2]
*** DB RECOVERY INFORMATION LIST ***
---------------------------------------------------------
<<RDAREA INFORMATION>>
 UNIT NAME  :      un16 [3] SERVER NAME:sds [4]
 RDAREA NAME: pdbuser01 [5]
 RDAREA ID :          4 [6] ATTRIBUTE : USER [7]      PAGE SIZE :  4096 [8]
 RECOVERY STARTED AT : 1995-05-16 11:34:19 [9]
 RECOVERY ENDED AT   : 1995-05-16 11:34:46 [10]
<REPLICA RDAREA INFORMATION>
 ORIGINAL RDAREA NAME : pdbuser01 [19]
 REPLICA RDAREA GENERATION NO : 0 [20]
<<BACKUP INFORMATION>>
 BACKUP STARTED AT : 1995-05-16 11:11:42 [11]
 BACKUP ENDED AT   : 1995-05-16 11:11:42 [12]
<<LOG INFORMATION>>
 1ST LOG    : 1995-05-16 10:57:48 [13]
 LAST LOG   : 1995-05-16 10:58:26 [14]
 LOG COUNT  :         42 [15]
<FILE INFORMATION>
1 /dbarea/area1/rdmt06 [16]
  EXTENT COUNT :   2 [18]
  PAGE NUMBER  :    124 [17]
2 /dbarea/area1/rdmt07 [16]
  EXTENT COUNT :   2 [18]
  PAGE NUMBER  :    108 [17]
--------------------------------------------------------
<<RDAREA INFORMATION>>
 UNIT NAME  :      un16 SERVER NAME:sds
 RDAREA NAME: pdbuser03
 RDAREA ID :           5 ATTRIBUTE : USER            PAGE SIZE :  4096
 RECOVERY STARTED AT : 1995-05-16 11:34:46
 RECOVERY ENDED AT   : 1995-05-16 11:35:10
<REPLICA RDAREA INFORMATION>
 ORIGINAL RDAREA NAME : pdbuser03
 REPLICA RDAREA GENERATION NO : 0
<<BACKUP INFORMATION>>
 BACKUP STARTED AT : 1995-05-16 11:11:42
 BACKUP ENDED AT   : 1995-05-16 11:11:43
<<LOG INFORMATION>>
 1ST LOG    : 1995-05-16 10:59:50
 LAST LOG   : 1995-05-16 11:02:35
 LOG COUNT  :         42
<FILE INFORMATION>
1 /dbarea/area1/rdmt08
  EXTENT COUNT :   2
  PAGE NUMBER  :    124
2 /dbarea/area1/rdmt09
  EXTENT COUNT :   2
  PAGE NUMBER  :    108
--------------------------------------------------------
<<RDAREA INFORMATION>>
 UNIT NAME  :      un16 SERVER NAME:sds
 RDAREA NAME: pdbuser05
 RDAREA ID :           6 ATTRIBUTE : USER            PAGE SIZE :  4096
 RECOVERY STARTED AT : 1995-05-16 11:35:10
 RECOVERY ENDED AT   : 1995-05-16 11:35:34
<REPLICA RDAREA INFORMATION>
 ORIGINAL RDAREA NAME : pdbuser05
 REPLICA RDAREA GENERATION NO : 0
<<BACKUP INFORMATION>>
 BACKUP STARTED AT : 1995-05-16 11:11:43
 BACKUP ENDED AT   : 1995-05-16 11:11:43
<<LOG INFORMATION>>
 1ST LOG    : 1995-05-16 11:03:21
 LAST LOG   : 1995-05-16 11:08:47
 LOG COUNT  :         42
<FILE INFORMATION>
1 /dbarea/area1/rdmt10
  EXTENT COUNT :   2
  PAGE NUMBER  :    124
2 /dbarea/area1/rdmt11
  EXTENT COUNT :   2
  PAGE NUMBER  :    108
--------------------------------------------------------

Explanation
  1. Date and time the database recovery utility was executed (in the format YYYY/MM/DD hh:mm:ss).
    YYYY: Year. MM: Month. DD: Date. hh: Hour. mm: Minute. ss: Second.
  2. HiRDB identifier
  3. Name of the unit containing an RDAREA
  4. Name of the unit containing an RDAREA
  5. Name of the recovered RDAREA
  6. Number of the recovered RDAREA
  7. Type of RDAREA:
    MASTERDIRECTORY: Master directory RDAREA
    DATADIRECTORY: Data directory RDAREA
    DATADICTIONARY: Data dictionary RDAREA
    SYSTEM_LOB: Data dictionary LOB RDAREA
    USER: User RDAREA
    USER_LOB: User LOB RDAREA
    REG: Registry RDAREA
    REG_LOB: Registry LOB RDAREA
  8. Page length of the RDAREA (in bytes)
  9. Recovery start time of the RDAREA (format is the same as in 1)
  10. Recovery end time of the RDAREA (format is the same as in 1)
  11. Backup start time of the RDAREA (format is the same as in 1)
  12. Backup end time of the RDAREA (format is the same as in 1)
  13. Time the first log record was output during recovery processing (format is the same as in 1)
  14. Time the last log record was output during recovery processing (format is the same as in 1)
  15. Number of updated log records used during recovery processing
  16. Name of a HiRDB file constituting the RDAREA
  17. Number of pages allocated to the HiRDB file
  18. Number of extents in the HiRDB file
  19. Name of the original RDAREA
  20. Generation number of the replica RDAREA
Notes
  1. If there is no data to be restored, the utility displays No data for recovery at 9, and displays nothing at 8-15.
  2. If there is no backup file, the utility does not display 11 or 12.
  3. If there are no log records for an RDAREA, the utility does not display 13 or 14.
  4. 19 and 20 are output if the inner replica facility is used.