Problem: Loading very large BLOBs in DB2


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.