Select the three actions on this page in order.

Increase LOB inline length

In the first step, we will increase the LOB inline length to 2000 btyes for the VIEW_TEXT column so that all LOBs in that column can be inlined. You may alter the LOB column to increase the inline length with the following command. Note that you cannot reduce the inline length.

ALTER TABLE INLINELOBDATA
      ALTER COLUMN VIEW_TEXT
        SET INLINE LENGTH 2000

Reorg table

Step two REORG table with the LONGLOBDATA option so that the new inline length can take in effect. This option converts any potential LOB descriptors into inlined LOB data.

CALL ADMIN_CMD('REORG TABLE INLINELOBDATA LONGLOBDATA')

Retrieve Inline LOB data again

The last step executes the same SQL query in the previous pages and observe the direct read and write activities.

SELECT VIEW_TEXT, COLUMN_TEXT
  FROM INLINELOBDATA

Taking the 104 direct reads overhead from TE, you should see that there is no more direct read and write activity because all LOBs in the INLINELOBDATA table are all inlined.