Select the three actions on this page in order to illustrate direct read and write activities happening with LOB data.

Collect direct read and write statistics

The first step collects direct read and write statistics before inline LOB data is retrieved.

SELECT DIRECT_READS, DIRECT_WRITES
  FROM SYSIBMADM.SNAPDB

Retrieve Inline LOB data

The second step executes a SQL query to retrieve inline LOB data in the VIEW_TEXT and COLUMN_TEXT columns.

SELECT VIEW_TEXT, COLUMN_TEXT
  FROM INLINELOBDATA

Compare direct read and write statistics

The third step compares the direct read and write statistics before and after the execution of the query. Please note that there is a 104 direct reads overhead generated by the Technology Explorer. If the same SQL statements run on the DB2 command, you will not see the overhead.