Nonstop Database, HiRDB Version 9 Installation and Design Guide
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 |
| Logical analysis by RDAREA | a 1 + 4.1 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 i=1 number of tables in RDAREAi + number of indexesi + number of LOB RDAREAsi) |
|
| Status analysis in units of tables | 1 + 4.1 |
|
| Status analysis in units of indexes | 1 + 4.1 |
|
| Cluster key status analysis | 1 + 4.1 |
|
| Work file for sorting | Work area for sorting the above work files | Value obtained from the above formula |
All Rights Reserved. Copyright (C) 2012, 2015, Hitachi, Ltd.