17.6 Determining the size of a user LOB RDAREA

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

Formula
Size of user LOB RDAREA (bytes)
={
a
[ [Figure][Figure]Si[Figure]64000[Figure][Figure]96 + 7 + 3[Figure](a - 1)]1
i=1
b
+ [ [Figure][Figure](Cj + 1024) [Figure]8192[Figure]]2
j=1
}3[Figure]81924
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.