Select the three actions on this page in order to illustrate direct read and write activities happening with LOB data.
SELECT DIRECT_READS, DIRECT_WRITES
FROM SYSIBMADM.SNAPDB
SELECT VIEW_TEXT, COLUMN_TEXT
FROM INLINELOBDATA
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.