19.2.10 Memory size required for the execution of the database recovery utility (pdrstr)

The following tables show the formulas for determining the memory size required for the execution of the database recovery utility (pdrstr).

Organization of this subsection
(1) HiRDB/Single Server
(2) HiRDB/Parallel Server

(1) HiRDB/Single Server

ConditionFormula for determining memory size (KB)
Single server65 + {(number of RDAREAs subject to recovery + 9) [Figure] 10} x 6
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} x 8 + 50
+ 98 + 2 x MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} x 6 + c
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} x 8 + 100
+ {(number of RDAREAs subject to recovery + 99) [Figure] 100} x 5
Add the following value if this server contains backup files:
+ 100 + 2 x MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} x 6
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} x 8 + 100 + e
If you are inputting the unload log file or system log file, add:
+ 57 + 2 x MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} x 6 + 64
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} x 8 + 100 + d
+ 0.6 x number of RDAREAs subject to recovery + size of work buffer for sorting (value of -y option)
Add the following value if differential backup files are used for recovery:
+ 32 x 2 + [Figure] (512 + 128 x number of RDAREAs subject to backup) [Figure] 32,768[Figure] x 32
+ [Figure] (256 + 128 x number of RDAREAs subject to backup + a + 8 x b) [Figure] 32,768[Figure] x 32
+ [Figure] (32 x differential backup count) [Figure] 1,024[Figure]
a: Length of the backup file name specified in the -b option (bytes). If multiple backup files are specified, this value is the total length of the file names.
b: Number of backup files specified in the -b option
c: If the write buffer size is specified, this value is MAX(64, write buffer size). If not, this value is 60.
The write buffer size is the value specified by the -Y option.
d:
  • 32-bit mode
    640 + 8 x[Figure]maximum number of concurrently executed transactions [Figure] 100[Figure]
    + 5 x[Figure]number of RDAREAs subject to recovery [Figure] 100[Figure]
    + maximum page size of RDAREAs subject to recovery x 54
    + 9 x number of transactions subject to rollback
    + 0.02 x number of RDAREA component files subject to recovery
    + [Figure](304 + 36 + 4 x (number of RDAREAs subject to recovery - 1)
    + 352 + 304 x (number of RDAREAs subject to recovery - 1)
    + 96 + 4 x (number of RDAREAs subject to recovery - 1)
    + 384 + 320 x (number of RDAREAs subject to recovery - 1) + 16) [Figure] 1,024[Figure]
  • 64-bit mode
    640 + 11 x[Figure]maximum number of concurrently executed transactions [Figure] 100[Figure]
    + 6 x[Figure]number of RDAREAs subject to recovery [Figure] 100[Figure]
    + maximum page size of RDAREAs subject to recovery x 54
    + 9 x number of transactions subject to rollback
    + 0.03 x number of RDAREA component files subject to recovery
    + [Figure](304 + 40 + 8 x (number of RDAREAs subject to recovery - 1)
    + 400 + 336 x (number of RDAREAs subject to recovery - 1)
    + 168 + 8 x (number of RDAREAs subject to recovery - 1)
    + 408 + 336 x (number of RDAREAs subject to recovery - 1) + 16) [Figure] 1,024[Figure]
e: The value specified in pd_utl_file_buff_size (round up in units of 32 kilobytes)
If pd_utl_file_buff_size is not specified, 32.

(2) HiRDB/Parallel Server

ConditionFormula for determining memory size (KB)
MGR65 + {(number of RDAREAs subject to recovery + 9) [Figure] 10} x 6
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} x 8 + 50
Add the following value if differential backup files are used for recovery:
+ 32 x 2 + [Figure] (512 + 128 x number of RDAREAs subject to backup) [Figure] 32,768[Figure] x 32
+ [Figure] (256 + 128 x number of RDAREAs subject to backup + a + 8 x b) [Figure] 32,768[Figure] x 32
+ [Figure] (32 x differential backup count) [Figure] 1,024[Figure]
DS35 + 2 x MAX(32, value of pd_utl_buff_size) + 100
+ 98 + 2 x MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} x 6 + c
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} x 8 + 100
+ {(number of RDAREAs subject to recovery + 99) [Figure] 100} x 5
If you are inputting the unload log file or system log file, add:
+ 57 + 2 x MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} x 6 + 64
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} x 8 + 100 + d
+ 0.6 x number of RDAREAs subject to recovery + size of work buffer for sorting (value of -y option)
BES98 + 2 x MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} x 6 + c
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} x 8 + 100
+ {(number of RDAREAs subject to recovery + 99) [Figure] 100} x 5
If you are inputting the unload log file or system log file, add:
+ 57 + 2 x MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} x 6 + 64
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} x 8 + 100 + d
+ 0.6 x number of RDAREAs subject to recovery + size of work buffer for sorting (value of -y option)
Server machine containing backup files100 + 2 x MAX(32, value of pd_utl_buff_size) x number of servers subject to recovery
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} x 6
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} x 8 + 100 + e
a: Length of the backup file name specified in the -b option (bytes). If multiple backup files are specified, this value is the total length of the file names.
b: Number of backup files specified in the -b option
c: If the write buffer size is specified, this value is MAX(64, write buffer size). If not, this value is 60.
The write buffer size is the value specified by the -Y option.
d:
  • 32-bit mode
    640 + 8 x[Figure]maximum number of concurrently executed transactions [Figure] 100[Figure]
    + 5 x[Figure]number of RDAREAs subject to recovery [Figure] 100[Figure]
    + maximum page size of RDAREAs subject to recovery x 54
    + 9 x number of transactions subject to rollback
    + 0.02 x number of RDAREA component files subject to recovery
    + [Figure](304 + 36 + 4 x (number of RDAREAs subject to recovery - 1)
    + 352 + 304 x (number of RDAREAs subject to recovery - 1)
    + 96 + 4 x (number of RDAREAs subject to recovery - 1)
    + 384 + 320 x (number of RDAREAs subject to recovery - 1)
    + 16 + 32 x number of RDAREAs subject to recovery) [Figure] 1,024[Figure]
  • 64-bit mode
    640 + 11 x[Figure]maximum number of concurrently executed transactions [Figure] 100[Figure]
    + 6 x[Figure]number of RDAREAs subject to recovery [Figure] 100[Figure]
    + maximum page size of RDAREAs subject to recovery x 54
    + 9 x number of transactions subject to rollback
    + 0.03 x number of RDAREA component files subject to recovery
    + [Figure](304 + 40 + 8 x (number of RDAREAs subject to recovery - 1)
    + 400 + 336 x (number of RDAREAs subject to recovery - 1)
    + 168 + 8 x (number of RDAREAs subject to recovery - 1)
    + 408 + 336 x (number of RDAREAs subject to recovery - 1)
    + 16 + 48 x number of RDAREAs subject to recovery) [Figure] 1,024[Figure]
e: The value specified in pd_utl_file_buff_size (round up in units of 32 kilobytes)
If pd_utl_file_buff_size is not specified, 32.