16.6 Determining the size of a user LOB RDAREA
(1) Total number of pages in the directory page part
- Formula
Total number of pages in the directory page part a = Si 64,000 x 96 + 7 + 3 x (a - 1) i=1 |
- a: Number of HiRDB files that constitute the user LOB RDAREA
- 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)
(2) Total number of pages in the data page part
- Formula
Total number of pages in the data page part b = (Cj + 1,024) 8,192![[Figure]](figure/zueng010.gif) j = 1 |
- 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.
- Cj: Length of each BLOB data (bytes)