17.2.2 Determining the size of a data dictionary RDAREA for storing database state analyzed tables and database management tables

You can use the following formula to determine the size of a data dictionary RDAREA for which datadictionary of dbmanagement is specified in the create rdarea statement:

Formula
Size of data dictionary RDAREA = ([Figure](a[Figure] 1.3) [Figure] b[Figure]) [Figure] b[Figure] 4096
(bytes)
a: Total number of pages in the data dictionary RDAREA#1
b: Segment size of the data dictionary RDAREA#2
#1
Number of table storage pages + Number of index storage pages. For details, see (1) and (2) below.
#2
Segment size specified in the create rdarea statement of the database structure modification utility (pdmod).
Organization of this subsection
(1) How to determine the number of table storage pages
(2) How to determine the number of index storage pages

(1) How to determine the number of table storage pages

The number of table storage pages is the sum of Formula 1 and Formula 2:

Formula 1[Figure]
Formula 2[Figure]
a: Number of tables to be created + 61
b: Average number of partitions in the table storage RDAREA
If the RDAREA is not partitioned, the value is 1. The average value is rounded up.
c: Number of indexes to be created + 124
e: Total number of BLOB columns defined for the tables to be created + 3
g: Total number of BLOB attributes defined for the tables to be created

(2) How to determine the number of index storage pages

Use the following formula to determine the number of index storage pages:

Number of pages for index storage for the data dictionary tables*[Figure] 2
* See 17.1.3 Calculating the number of index storage pages to determine the number of pages for index storage for the data dictionary tables. The following is the calculation condition:
  1. The ratio of unused space specified in CREATE INDEX is 0.
  2. Use the following variables in the formula:
    Key length
    (variable g*)
    Number of key types
    (variable c*)
    Average number of duplicate keys
    (variable d*)
    12(a + c + e + g) [Figure] (b + 1) + 12030
a: Number of tables to be created
b: Average number of partitions in the table storage RDAREA
c: Number of indexes to be created
e: Total number of BLOB columns defined for the tables to be created
g: Total number of BLOB attributes defined for the tables to be created
* Variables shown in (2) Variables used in formulas in 17.1.3 Calculating the number of index storage pages.