The following table shows the formulas for determining the file sizes required for the execution of the database condition analysis utility (pddbst):
File type | Formula (bytes) | |
---|---|---|
Work file | Physical analysis by RDAREA | 1 + 4.1 x a |
Logical analysis by RDAREA | a 1 + 4.1 x ![]() i=1 number of tables in RDAREAi + number of indexesi + number of LOB RDAREAsi) | |
Accumulating condition analysis result or reorganization time prediction# | a 1 + 4.1 x ![]() i=1 number of tables in RDAREAi + number of indexesi + number of LOB RDAREAsi) | |
Status analysis in units of tables | 1 + 4.1 x (number of storage RDAREAs) | |
Status analysis in units of indexes | 1 + 4.1 x (number of storage RDAREAs) | |
Cluster key status analysis | 1 + 4.1 x (number of storage RDAREAs) | |
Work file for sorting | Work area for sorting the above work files | Value obtained from the above formula x 2 |