The following table shows the formulas for determining the file sizes required for the execution of the database copy utility (pdcopy):
File type | Formula (bytes) |
---|---|
Backup file# Full backup file# | a![]() i = 1 + 88 x a + 220 x b |
Differential backup file# | w x size of full backup file |
Differential backup management file | (1 + j + m) x 32,768 |
Log point information file | 1,024 |
|
Condition | Value added to Xi | ||
---|---|---|---|
Tables | Row length < di | Deleted rows are distributed over the entire table | MIN(number of deleted rows, number of table pages used) |
Deleted rows are concentrated on a few pages | MIN(number of deleted rows ![]() | ||
Row length > di | MIN(number of deleted rows x number of pages required to store 1 row, number of table pages used) | ||
Indexes | Updated keys are distributed over the entire index | MIN(number of update keys + ![]() | |
Updated keys are concentrated on a few pages | MIN(number of update keys ![]() ![]() |
Condition | Value added to Xi | ||
---|---|---|---|
Tables | Update column length < di | Updated rows are distributed over the entire table | MIN(number of updated rows, number of table pages used) |
Updated rows are concentrated on a few pages | MIN(number of updated rows ![]() | ||
Update column length > di | MIN(number of updated rows x number of pages required to store updated columns, number of table pages used) | ||
Indexes | Updated keys are distributed over the entire index | MIN(number of update keys x 2 + ![]() | |
Updated keys are concentrated on a few pages | MIN(number of update keys x 2 ![]() ![]() |