LOB Administration in a Db2 LUW database

In this blog post, I’ll discuss space and performance considerations of large objects (LOBs) in SAP environments on Db2 for Linux, UNIX, and Windows (LUW). You will learn how to address potential issues by configuration and maintenance. Key topics are , compactness, and inlining.

Note that not all information about LOBs is easily accessible. For convenience, in SAP environments the table function LOBALLOC assists administrators of Db2 LUW databases with investigating LOB space allocation.

How can you maintain the LOB object of a table?

You have the following options:

Run a REORGModify the LOB compactnessModify the inline length

As all of these options may have considerable impact on daily operation, and since they also affect the space allocation, it is important to have some knowledge about the effect of these actions. I will demonstrate how the LOBALLOC table function can assist you.

 

​ In this blog post, I’ll discuss space and performance considerations of large objects (LOBs) in SAP environments on Db2 for Linux, UNIX, and Windows (LUW). You will learn how to address potential issues by configuration and maintenance. Key topics are , compactness, and inlining.Note that not all information about LOBs is easily accessible. For convenience, in SAP environments the table function LOBALLOC assists administrators of Db2 LUW databases with investigating LOB space allocation.How can you maintain the LOB object of a table?You have the following options:Run a REORGModify the LOB compactnessModify the inline lengthAs all of these options may have considerable impact on daily operation, and since they also affect the space allocation, it is important to have some knowledge about the effect of these actions. I will demonstrate how the LOBALLOC table function can assist you.   Read More Technology Blogs by SAP articles 

#SAP

#SAPTechnologyblog

You May Also Like

More From Author