Scalable Database Server, HiRDB Version 8 Installation and Design Guide
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
The following formula is used to determine the size of a user LOB RDAREA.
- Formula
Size of user LOB RDAREA (bytes)
={
a
[ ![[Figure]](FIGURE/ZUENG102.GIF) ![[Figure]](FIGURE/ZUENG010.GIF) Si![[Figure]](FIGURE/ZUENG002.GIF) 64000 ![[Figure]](FIGURE/ZUENG005.GIF) 96 + 7 + 3(a - 1)]1
i=1
b
+ [ (Cj + 1024) 8192]2
j=1
}381924 |
- a: Number of HiRDB files that constitute the user LOB RDAREA
- b: Total number of rows in LOB columns
- Count rows with a data length of 0, but do not count rows with the NULL value.
- Si: Number of segments for each HiRDB file specified with the create rdarea statement of the database initialization utility (pdinit) or database structure modification utility (pdmod)
- Cj: Length of each BLOB data (bytes)
- 1 Total number of pages in the directory pages part.
- 2 Total number of pages in the data pages part.
- 3 Total number of pages in the user LOB RDAREA.
- 4 Page length of the user LOB RDAREA.
All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.