DB2 Version 9.7 for Linux, UNIX, and Windows

lob_object_l_pages - LOB data logical pages monitor element

The number of logical pages used on disk by LOBs associated with this table.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_TABLE table function - Get table metrics	Always collected

Usage

This value might be less than the amount of space physically allocated for the object. This can happen when you use the REUSE STORAGE option of the TRUNCATE statement. This option causes storage allocated for the table to continue to be allocated, although the storage will be considered empty. In addition, the value for this monitor element might be less than the amount of space logically allocated for the object, because the total space logically allocated includes a small amount of additional meta data.
To retrieve an accurate measure of the logical or physical size of an object, use the ADMIN_GET_TAB_INFO_V97 function. This function provides more accurate information about the size of objects than you can obtain by multiplying the number of pages reported for this monitor element by the page size.