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
Download the Esri Support App
Related Information
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback