The following formula is used to determine the size of the registry RDAREA.
Registry RDAREA size (bytes) = registry RDAREA page length# x total number of registry RDAREA pages x 1.3 |
Total number of registry RDAREA pages (pages) a = ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() i=1 + number of pages storing registry management tables + number of pages storing indexes of registry management table |
Each table or index is allocated in segments. The value obtained for each table or index is rounded up in segments.
![]() |
Number of pages storing registry management table indexes (pages) = number of pages storing indexes of SQL_REGISTRY_CONTEXT tables + number of pages storing indexes of SQL_REGISTRY_KEY tables |
For details about the number of pages storing indexes of SQL_REGISTRY_CONTEXT tables and the number of pages storing indexes of SQL_REGISTRY_KEY tables, see 16.1.3 Calculating the number of index storage pages. However, calculate the formula using 30% as the percentage of unused areas specified in the CREATE INDEX statement.
The following table lists the values used in the formula for the number of pages storing indexes.
Name of table | Type | Key length | Key type | Average duplication level |
---|---|---|---|---|
SQL_REGISTRY_CONTEXT | 72 | a + 1 | Number of context names (number of registry management table contexts) | 1 |
SQL_REGISTRY_KEY | 73 | f + 6 | Number of key values (number of registry management table key values) | 1 |