Loading very large BLOBs in DB2

Last Published: April 25, 2020


You must consider the BLOB size when loading BLOBs into DB2.


If the size of the BLOB is greater than or equal to 2 GB, then it will be overwritten with the dbtune parameter LOB_SIZE, which has a default value of 1 MB.

If the BLOB size is significantly larger than 1 GB, then the LOB_OPTION parameter in the dbtune file will be overwritten with "NOT LOGGED".

Solution or Workaround

Turn off logging for BLOBs greater than 1 GB.

Article ID:000003084

  • Legacy Products
  • ArcMap 9 x
  • ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic