DB2 SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH203 0X5359534C564C3031

database db2 sqlcode
Manu picture Manu · Feb 3, 2014 · Viewed 48.7k times · Source

I am getting this error below :

 com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH203 0X5359534C564C3031, DRIVER=3.58.81

in the execution of application after a certain point of time. Not got any fruitful answer on the web.

Answer

Burhan Khalid picture Burhan Khalid · Feb 3, 2014

This is an indication that the application is running out of resources; possibly due to not closing connections (too many prepared statements or other such poor programming).

If you have access to the application, consider making sure the connections are released when not needed. Otherwise, you need to reduce the constraints on the application. Try increasing APPLHEAPSZ and MAXAPPLS but really you should investigate this from the application side.

Related questions

DB2 Error SQLERRMC:DECFLOAT... sometimes

This one really has me scratching my head. This statement: SELECT CODE FROM CODES_TABLE WHERE STATUS = 0 AND PERCENT = 30 works just fine, but this one: SELECT CODE FROM CODES_TABLE WHERE STATUS = 0 AND PERCENT = 20 Gives me the DB2 SQL Error: …

Read More
DB2 Logfile Limitation, SQLCODE: -964

I have tried a huge insert query in DB2. INSERT INTO MY_TABLE_COPY ( SELECT * FROM MY_TABLE); Before that, I set the followings: UPDATE DATABASE CONFIGURATION FOR MY_DB USING LOGFILSIZ 70000; UPDATE DATABASE CONFIGURATION FOR MY_DB USING LOGPRIMARY 50; …

Read More
Difference between CLOB and BLOB from DB2 and Oracle Perspective?

I have been pretty much fascinated by these two data types. According to Oracle Docs, they are presented as follows : BLOB : Variable-length binary large object string that can be up to 2GB (2,147,483,647) long. Primarily intended to hold non-traditional data, such …

Read More