Table lob data

[Former Member]

Hi All,

We have recently migrated from DB6 to HANA.

Now post migration to SAP HANA, we have some row store tables on the master node which contain the LOB data. Now the question is that I don't think while migrating we had defined the conditions mentioned in the below link

[Former Member · Accepted solution]

HI All,

Some problem with IE 11 couldnt update the query fully.

http://help.sap.com/saphelp_hanaplatform/helpdata/en/20/d329a6751910149d5fdbc4800f92ff/content.htm?f...

Controls if LOB data should be stored in memory or not according to the following conditions:

•If <memory_threshold_value> is not provided, lob is stored in memory by default.

•If <memory_threshold_value> is provided and its LOB size is bigger than memory threshold value, LOB data is stored on disk.

•If <memory_threshold_value> is provided and its LOB size is equal or less than memory threshold value, LOB data is stored in memory.

•If <memory_threshold_value> is NULL, all LOB data is stored in memory.

•If <memory_threshold_value> is 0, all LOB data is stored in disk.

I did check the thread answered by Lars .

The problem is that we didnt define the condition for the LOB data to be unloaded during migration.

But the question is that is it default condition is that LOB data should be unloaded and loaded only upon request.

[Former Member · Accepted solution]

Got the data from M_TABLES_LOB_FILES but the question .

But all the data from the LOB resides on the disk, is this data not compressed.

Can anyone please help on this please.

[Former Member · Accepted solution]

Keeping LOB data on disk is best practice. LOB data isn't compressed, but that doesn't matter much, because it doesn't consume memory.