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

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options