Database copy utility process results listing

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

 
pdcopy (VV-RR)  ***** DB COPY *****   1996-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:c:/hirdb/pdcopy/bkup01 [16]
                         c:/hirdb/pdcopy/bkup02
  FILE KIND      : u [17]
  STARTED AT     : 1996-04-24 14:08:20 [18]
  ENDED AT       : 1996-04-24 14:08:21 [19]
 
<<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     : 1996-04-24 14:08:20 [26]
  ENDED AT       : 1996-04-24 14:08:21 [27]
 
 <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 c:/hirdb/area1/rdmt06 [38]
   EXTENT COUNT :   1 [40]
 2 c:/hirdb/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  : 1996-04-24 14:08:21
  ENDED AT    : 1996-04-24 14:08:21
 
 <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 c:/hirdb/area1/rdmt08
   EXTENT COUNT :   2
 2 c:/hirdb/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  : 1996-04-24 14:08:21
  ENDED AT    : 1996-04-24 14:08:21
 <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 c:/hirdb/area1/rdmt10
   EXTENT COUNT :   2
 2 c:/hirdb/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  : 1996-04-24 14:08:21
  ENDED AT    : 1996-04-24 14:08:21
 
 <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 c:/hirdb/area1/rdmt12
   EXTENT COUNT :   2
 2 c:/hirdb/area1/rdmt13
   EXTENT COUNT :   2

Explanation

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.
HiRDB identifier
Backup acquisition mode:
EXCLUSIVE: -M x or -M r
SHARED: -M s
HiRDB identifier
Unit identifier
Log type:
sys: System log file
Server name
Server run ID (8 hexadecimal digits)
Log server run ID (8 hexadecimal digits)
Name of the system log file needed to restore the database, together with the corresponding backup file.
Generation number of the system log file in 10.
Beginning block number (up to 8 hexadecimal digits)
Number of times header has been updated (up to 8 hexadecimal digits)
Usage start time (8 hexadecimal digits)
Volume name
****** is displayed.
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 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.
Type of backup file (value specified in the -k option)
Backup start time (same format as in 1)
Backup end time (same format as in 1)
Name of the unit containing the RDAREA
Name of the server containing the RDAREA
Name of the copied RDAREA
Number of the copied RDAREA
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
Page length of the RDAREA (in bytes)
Backup start time for the RDAREA (same format as in 1)
Backup end time for the RDAREA (same format as in 1)
Number of available pages in the RDAREA (number of pages in the RDAREA where a table or index can be stored)
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
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.
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
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
Total size of the index storage pages (in bytes)
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
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
Total size of table storage pages (in bytes)
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
Names of the HiRDB files constituting the RDAREA
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).
Number of HiRDB file extents

Note: <<LOG FILE INFORMATION>> is displayed when s is specified in the -M option or when the -z option is specified.; Nos. 4-6, 8, 9, and 12-14 are displayed when the -z option is specified.

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]
 
 c:\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: c:\hirdb\pdcopy\backup\backup01
 d 2000-10-20 21:01:20,2000-10-20 21:01:38 r u host01: c:\hirdb\pdcopy\backup\backup02
 c 2000-10-21 21:05:20,2000-10-21 21:06:10 r u host01: c:\hirdb\pdcopy\backup\backup03
 b 2000-10-22 21:01:20,2000-10-22 21:01:45 r u host01: c:\hirdb\pdcopy\backup\backup04

Explanation

Date and time the pdcopy command was executed
HiRDB identifier
Name of the HiRDB file system area containing the differential backup management file
Backup group name
Date and time the backup group was created
The last update date and time for the backup group
Names of the RDAREAs belonging to the backup group
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
Backup start date and time
Backup end date and time
Backup acquisition mode:
x: Reference/update-impossible mode
r: Reference-possible mode
s: Updatable mode
Type of backup file
u: File
i: HiRDB file system area for backup files
Backup file name
The backup file name is displayed in the format host-name:backup-filename.

18.6 Database copy utility process results listing

(1) Contents of process results output file

(2) Contents of the history file for differential backups