English

Error: DB2 - SQL0429N - The max no. of concurrent LOB locators has been exceeded

Error Message

When using insert/fetch with BLOB data in a single transaction that has more than 31,000 rows, the following error message may occur:

"DB2 - SQL0429N - The max no. of concurrent LOB locators has been exceeded"

Cause

DB2 only supports a max of 32,000 LOB locators per unit of work.

Solution or Workaround

A fix is available in DB2 UDB Fixpack 4. It requires two settings in the db2cli.ini file.

[Database name]
PATCH2=50
LobCacheSize=1048576

This will free locators as the BLOBs are fetched and not accumulate them.

Follow this link to IBM technical support and navigate to the instructions regarding this fixpack.

    Related Information