The following formula is used to calculate the size of a user RDAREA.

Formula

Size of user RDAREA (bytes) = Page length of the user RDAREA1 total number of pages in the user RDAREA2

¹ This is the page length specified in the create rdarea statement for the database initialization utility or database structure modification utility.

² See (2) as follows.

The following formula is used to calculate the total number of pages in a user RDAREA.

  a
   {  Si  f  +  Si  g }
  i=1
   c
  + {  Ti  e   e}
   i=1
   d
 + { (Ii + 1)  e   e} + 6 (a + 1) + 2   20480  b 
   i=1

a: Number of HiRDB files constituting the user RDAREA

b: Page length of the user RDAREA (bytes)

c: Total number of tables in the user RDAREA

d: Total number of indexes to be stored in the user RDAREA

e: Segment size specified in the create rdarea statement for the database initialization utility (pdinit) or database structure modification utility (pdmod)

f: {b - 20} {( e 32 8) + 56}

g: (125 b) (16 f) f

S_i: Number of segments in each HiRDB file that is specified in the create rdarea statement for the database initialization utility (pdinit) or database structure modification utility (pdmod)

T_i: Number of pages required to store each table (see 16.1.2 Calculating the number of table storage pages)

I_i: Number of pages required to store each index (see 16.1.3 Calculating the number of index storage pages)