Nonstop Database, HiRDB Version 9 Command Reference

[Contents][Index][Back][Next]

18.6 Database copy utility process results listing

Organization of this section
(1) Contents of process results output file
(2) Contents of the history file for differential backups

(1) Contents of process results output file

The following shows the contents of the process results output files for the database copy utility.

 
pdcopy (VV-RR)  ***** DB COPY *****   2007-04-24 14:08:20 [1] utl3 [2]
-----------------------------------------------------------------
*** DB BACKUP INFORMATION LIST ***       BACKUPMODE : SHARED [3]
<<LOG FILE INFORMATION>>
  SYSTEM ID      : utl13 [4]
  UNIT ID        : sds1  [5]
  TYPE           : sys   [6]
  SERVER NAME    : sds   [7]
  SERVER RUN ID  : 455d67c7 [8]
  LOG SERVER RUN ID : 455d67c7 [9]
  FILE NAME      : logfg01 [10]
  GENERATION NO  : 1 [11]
  BLOCK NO       : d2 [12]
  HEADER WRITE COUNTER : 3 [13]
  HEADER WRITE TIME : 455d68d2 [14]
<<BACKUP FILE INFORMATION>>
  VOL NAME       : vol1,vol2 [15]
  FILE NAME      : host1:/usr/bkup01 [16]
                         /usr/bkup02
  FILE KIND      : u [17]
  STARTED AT     : 2007-04-24 14:08:20 [18]
  ENDED AT       : 2007-04-24 14:08:21 [19]
 <REPLICA BACKUP INFORMATION>
  REPLICA BACKUP GENERATION NO : 0 [43]
 
<<RDAREA INFORMATION>>
  UNIT NAME      :un16 [20] SERVER NAME : sds [21]
 
  RDAREA NAME    :USER1[22][23]           [24]                      [25]
  RDAREA ID      :          4 ATTRIBUTE : USER          PAGE SIZE : 4096
  STARTED AT     : 2007-04-24 14:08:20 [26]
  ENDED AT       : 2007-04-24 14:08:21 [27]
  IN-MEMORY DB-SYNC TIME   :2007-04-24 14:04:26 [42]
 <REPLICA RDAREA INFORMATION>
  ORIGINAL RDAREA NAME : USER1 [44]
  REPLICA RDAREA GENERATION NO : 0 [45]
 <RDAREA STATUS>      [28]
 TOTAL PAGE:           200 USED PAGE(RATE)   :        3   ( 1.5%) [29]
                           FREE SPACE        :       10.8         [30]
                           UNUSED PAGE(RATE) :      197   (98.5%) [31]
                               [32]
  INDEX PAGE(RATE) :            1( 33.3%) TOTAL SPACE :  4.0k      [33]
                           FREE SPACE(RATE)  :        3.8k( 94.7%) [34]
                               [35]
  DATA PAGE(RATE)  :            2( 66.7%) TOTAL SPACE :  8.0k      [36]
                           FREE SPACE(RATE)  :        7.0k( 87.6%) [37]
 <FILE INFORMATION>
 1 /dbarea/area1/rdmt06 [38]
   EXTENT COUNT :   1 [40]
 2 /dbarea/area1/rdmt07
   EXTENT COUNT :   1
<<RDAREA INFORMATION>>
  UNIT NAME   : un16        SERVER NAME : sds
 
  RDAREA NAME : USER2
  RDAREA ID   :            5 ATTRIBUTE  : USER             PAGE SIZE : 4096
  STARTED AT  : 2007-04-24 14:08:21
  ENDED AT    : 2007-04-24 14:08:21
  IN-MEMORY DB-SYNC TIME   :2007-04-24 14:04:26
 <REPLICA RDAREA INFORMATION>
  ORIGINAL RDAREA NAME : USER2
  REPLICA RDAREA GENERATION NO : 0
 <RDAREA STATUS>
 TOTAL PAGE:           200 USED PAGE(RATE)   :        3   ( 1.5%)
                           FREE SPACE        :       10.8
                           UNUSED PAGE(RATE) :      197   (98.5%)
  INDEX PAGE(RATE) :            1( 33.3%) TOTAL SPACE :  4.0k
                           FREE SPACE(RATE)  :        3.8k( 94.7%)
  DATE PAGE(RATE)  :            2( 66.7%) TOTAL SPACE :  8.0k
                           FREE SPACE(RATE)  :        7.0k( 87.6%)
 <FILE INFORMATION>
 1 /dbarea/area1/rdmt08
   EXTENT COUNT :   2
 2 /dbarea/area1/rdmt09
   EXTENT COUNT :   2
 
<<RDAREA INFORMATION>>
  UNIT NAME   : un16        SERVER NAME : sds
 
  RDAREA NAME : USER3
  RDAREA ID   :            6 ATTRIBUTE  : USER            PAGE SIZE : 4096  
  STARTED AT  : 2007-04-24 14:08:21
  ENDED AT    : 2007-04-24 14:08:21
  IN-MEMORY DB-SYNC TIME   :2007-04-24 14:04:12 
 <REPLICA RDAREA INFORMATION>
  ORIGINAL RDAREA NAME : USER3
  REPLICA RDAREA GENERATION NO : 0
 <RDAREA STATUS>
  TOTAL PAGE:        200 USED PAGE(RATE)   :          3   (  1.5%)
                         FREE SPACE        :         10.8
                         UNUSED PAGE(RATE) :        197   ( 98.5%)
  INDEX PAGE(RATE) :          1( 33.3%) TOTAL SPACE :    4.0k
                         FREE SPACE(RATE)  :          3.8k( 94.7%)
  DATA PAGE(RATE)  :          2( 66.7%) TOTAL SPACE :    8.0k
                         FREE SPACE(RATE)  :          7.0k( 87.6%)
 <FILE INFORMATION>
 1 /dbarea/area1/rdmt10
   EXTENT COUNT :   2
 2 /dbarea/area1/rdmt11
   EXTENT COUNT :   2
<<RDAREA INFORMATION>>
  UNIT NAME : un16     SERVER NAME : sds
 
  RDAREA NAME : USER_LOB1
  RDAREA ID   :         31  ATTRIBUTE : USER_LOB       PAGE SIZE : 8192
  STARTED AT  : 2007-04-24 14:08:21
  ENDED AT    : 2007-04-24 14:08:21
  IN-MEMORY DB-SYNC TIME   :2007-04-24 14:04:55
 <REPLICA RDAREA INFORMATION>
  ORIGINAL RDAREA NAME : USER_LOB1
  REPLICA RDAREA GENERATION NO : 0
 <RDAREA STATUS>
  TOTAL PAGE:     75000  USED PAGE(RATE)   :      30000   ( 40.0%)
                         UNUSED PAGE(RATE) :      45000   ( 60.0%)
 
  DISORDERED LOB DIRECTORY RATIO :   0% [39]
 <FILE INFORMATION>
 1 /dbarea/area1/rdmt12
   EXTENT COUNT :   2
 2 /dbarea/area1/rdmt13
   EXTENT COUNT :   2
 
<<ERROR SKIPPED INFORMATION>>
  RDAREA NAME : USER04,USER05,USER06,USER07,USER08,
                USER09 [41]
-----------------------------------------------------------------
 

Explanation
  1. Date and time the database copy 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. Backup acquisition mode:
    EXCLUSIVE: -M x or -M r
    SHARED: -M s
  4. HiRDB identifier
  5. Unit identifier
  6. Log type:
    sys: System log file
  7. Server name
  8. Server run ID (8 hexadecimal digits)
  9. Log server run ID (8 hexadecimal digits)
  10. Name of the system log file needed to restore the database, together with the corresponding backup file.
  11. Generation number of the system log file in 10.
  12. Beginning block number (up to 8 hexadecimal digits)
  13. Number of times header has been updated (up to 8 hexadecimal digits)
  14. Usage start time (8 hexadecimal digits)
  15. Volume name
    When e or m is specified in the -k option, the utility displays the value specified in the -v option; if the -v option was omitted, the utility displays ******.
  16. Backup file name (displayed as host-name:path-name*).
    If multiple file names were specified, the utility displays only the names of those files that were used.
    If -k e or -k m was specified, the utility displays the value specified in the -N option. If the -N option was omitted, the utility displays ******.
    If -k n was specified, the header becomes POLICY NAME, not FILE NAME. In this case, the utility displays the policy name specified with NetBackup.
    * If the system switchover facility is used, the utility displays the host name of the primary system.
  17. Type of backup file (value specified in the -k option)
  18. Backup start time (same format as in 1)
  19. Backup end time (same format as in 1)
  20. Name of the unit containing the RDAREA
  21. Name of the server containing the RDAREA
  22. Name of the copied RDAREA
  23. Number of the copied RDAREA
  24. 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
  25. Page length of the RDAREA (in bytes)
  26. Backup start time for the RDAREA (same format as in 1)
  27. Backup end time for the RDAREA (same format as in 1)
  28. Number of available pages in the RDAREA (number of pages in the RDAREA where a table or index can be stored)
  29. Number of used pages (number of pages in the RDAREA that already contains a table or index), and the percentage ratio of the number of used pages to the number of available pages
  30. Size of free space in the pages used (in bytes)
    This information is displayed in the following format:
    ZZZ9 (applicable from 0 to less than 1 KB)
    ZZZ9.9K (applicable from 1 KB to less than 1 MB)
    ZZZ9.9M (applicable from 1 MB to less than 1 GB)
    ZZZ9.9G (applicable to 1 GB or greater)
    Note: Z is omitted if the value is 0; 9 is never omitted, even if the value is 0.
  31. Number of unused pages (of all available pages in the RDAREA, the number of pages that has not yet been used), and the ratio of the number of unused pages to the number of available pages
  32. Number of index storage pages (of all the used pages, the number of pages used to store an index), and the percentage ratio of the number of index storage pages to the number of used pages
  33. Total size of the index storage pages (in bytes)
  34. Total size of the free space in the index storage pages (in bytes), and the ratio of this size to the total size of the index storage pages
  35. Number of table storage pages (of all the used pages, the number of pages used to store a table), and the percentage ratio of the number of table storage pages to the number of used pages
  36. Total size of table storage pages (in bytes)
  37. Total size of the free space in the table storage pages (in bytes), and the ratio of this size to the total size of the table storage pages
  38. Names of the HiRDB files constituting the RDAREA
  39. Access performance deteriorates if the system information disorganization ratio for a data dictionary LOB RDAREA or user LOB RDAREA is 1% or greater. In this case, reorganize the RDAREA using the database reorganization utility. For a data dictionary LOB RDAREA, reorganize the dictionary tables related to stored procedures (SQL_ROUTINES, SQL_ROUTINE_RESOURCES, and SQL_ROUTINE_PARAMS).
  40. Number of HiRDB file extents
  41. Name of RDAREA whose processing was skipped
    If there are multiple RDAREAs whose processing was skipped, the utility uses the comma to delimit the RDAREA names and displays 5 RDAREA names per line. If there are no RDAREAs whose processing was skipped, ***** is displayed. For the causes of the errors, see the messages output to the syslogfile. For details about the messages output to the syslogfile, see 18.4.2(9) -J.
  42. Time at which in-memory data buffer and in-memory RDAREA were synchronized
    The most recent synchronization time is displayed. This information is displayed when a backup of an in-memory RDAREA was made.
  43. Generation number specified in the -q option
  44. Name of original RDAREA
  45. Generation number of replica RDAREA
Note
<<LOG FILE INFORMATION>> is displayed when s is specified in the -M option or when the -z option is specified.
Nos. 4 to 6, 8, 9, and 12 to 14 are displayed when the -z option is specified.
No. 41 is displayed when the -J option is specified.
Nos. 43 and 44 are displayed when the inner replica facility is used.

(2) Contents of the history file for differential backups

The following shows the contents of the differential backups history file provided by the database copy utility:

 
 pdcopy (VV-RR) ***** DB COPY *****  2000-10-26 21:30:20[1] utl3[2]
 
 /hirdb/pdcopy/admfile[3]
 backupg1[4]
 2000-10-19 21:00:20[5]
 2000-10-26 21:18:20[6]
 RDAREA NAME :rdarea01,rdarea02[7]
[8]          [9]                 [10]    [11][12]           [13]
 a 2000-10-19 21:08:20,2000-10-19 21:09:25 r u host01: /hirdb/pdcopy/backup/backup01
 d 2000-10-20 21:01:20,2000-10-20 21:01:38 r u host01: /hirdb/pdcopy/backup/backup02
 c 2000-10-21 21:05:20,2000-10-21 21:06:10 r u host01: /hirdb/pdcopy/backup/backup03
 b 2000-10-22 21:01:20,2000-10-22 21:01:45 r u host01: /hirdb/pdcopy/backup/backup04
 

Explanation
  1. Date and time the pdcopy command was executed
  2. HiRDB identifier
  3. Name of the HiRDB file system area containing the differential backup management file
  4. Backup group name
  5. Date and time the backup group was created
  6. The last update date and time for the backup group
  7. Names of the RDAREAs belonging to the backup group
  8. Type of backup:
    a: Full backup
    b: Accumulation-differential backup from the most recent full backup
    c: Accumulation-differential backup from the previous accumulation-differential backup or previous full backup, whichever is more recent
    d: Differential backup
  9. Backup start date and time
  10. Backup end date and time
  11. Backup acquisition mode:
    x: Reference/update-impossible mode
    r: Reference-possible mode
    s: Updatable mode
  12. Type of backup file
    u: Regular File
    i: HiRDB file system area for backup files
  13. Backup file name
    The backup file name is displayed in the format host-name:backup-filename.