Error: DB2 - SQL0429N - The max no. of concurrent LOB locators has been exceeded
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"
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.
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.