20.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} [Figure] 6
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} [Figure] 8 + 50
+ 98 + 2 [Figure] MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} [Figure] 6 + c
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} [Figure] 8 + 100
+ {(number of RDAREAs subject to recovery + 99) [Figure] 100} [Figure] 5
Add the following value if this server contains backup files:
+ 100 + 2 [Figure] MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} [Figure] 6
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} [Figure] 8 + 100
Add the following value if unload log files are to be input:
+ 57 + 2 [Figure] MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} [Figure] 6 + 64
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} [Figure] 8 + 100
+ {(maximum number of concurrently executable transactions + 99) [Figure] 100} [Figure] 5
+ (maximum page size for RDAREA subject to recovery) [Figure] 50
+ 0.6 [Figure] 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 [Figure] 2 + [Figure] (512 + 128 [Figure] number of RDAREAs subject to backup) [Figure] 32768[Figure][Figure] 32
+ [Figure] (256 + 128 [Figure] number of RDAREAs subject to backup + a + 8 [Figure] b) [Figure] 32768[Figure][Figure] 32
+ [Figure] (32 [Figure] differential backup count) [Figure] 1024[Figure]
Utility special unit100 + 2 [Figure] MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} [Figure] 6
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} [Figure] 8 + 100
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.

(2) HiRDB/Parallel Server

ConditionFormula for determining memory size (KB)
MGR65 + {(number of RDAREAs subject to recovery + 9) [Figure] 10} [Figure] 6
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} [Figure] 8 + 50
Add the following value if differential backup files are used for recovery:
+ 32 [Figure] 2 + [Figure] (512 + 128 [Figure] number of RDAREAs subject to backup) [Figure] 32768[Figure][Figure] 32
+ [Figure] (256 + 128 [Figure] number of RDAREAs subject to backup + a + 8 [Figure] b) [Figure] 32768[Figure][Figure] 32
+ [Figure] (32 [Figure] differential backup count) [Figure] 1024[Figure]
DS35 + 2 [Figure] MAX(32, value of pd_utl_buff_size) + 100
+ 98 + 2 [Figure] MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} [Figure] 6 + c
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} [Figure] 8 + 100
+ {(number of RDAREAs subject to recovery + 99) [Figure] 100} [Figure] 5
Add the following value if this server contains backup files:
+ 100 + 2 [Figure] MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} [Figure] 6
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} [Figure] 8 + 100
Add the following value if unload log files are to be input:
+ 57 + 2 [Figure] MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} [Figure] 6 + 64
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} [Figure] 8 + 100
+ {(maximum number of concurrently executable transactions + 99) [Figure] 100} [Figure] 5
+ (maximum page size for RDAREAs subject to recovery) [Figure] 50
+ 0.6 [Figure] number of RDAREAs subject to recovery + size of work buffer for sorting (value of -y option)
BES98 + 2 [Figure] MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} [Figure] 6 + c
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} [Figure] 8 + 100
+ {(number of RDAREAs subject to recovery + 99) [Figure] 100} [Figure] 5
Add the following value if this server contains backup files:
+ 100 + 2 [Figure] MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} [Figure] 6
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} [Figure] 8 + 100
Add the following value if unload log files are to be input:
+ 57 + 2 [Figure] MAX(32, value of pd_utl_buff_size)
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} [Figure] 6 + 64
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} [Figure] 8 + 100
+ {(maximum number of concurrently executable transactions + 99) [Figure] 100} [Figure] 5
+ (maximum page size for RDAREAs subject to recovery) [Figure] 50
+ 0.6 [Figure] number of RDAREAs subject to recovery + size of work buffer for sorting (value of -y option)
Server machine containing backup files100 + 2 [Figure] MAX(32, value of pd_utl_buff_size) [Figure] number of servers subject to recovery
+ {(number of RDAREAs subject to recovery + 9) [Figure] 10} [Figure] 6
+ {(number of RDAREA component files subject to recovery + 25) [Figure] 16} [Figure] 8 + 100
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.