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.

    Article ID:000004650

    Software:
    • ArcMap 8 x
    • ArcMap 9 x
    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Related Information

    Discover more on this topic