Hi
I am running a DB2 v9.7 Enterprise Edition 64 bit edition database on Windows 2003 server.
The following is a strange behaviour happening on the db.
- Database Manager is in running state , no connections to DB exists for an hour.
- After an hour , when I issue the DB2 connect statement , I get the error
"SQL1022C : There is not enough memory available to process the command." sqlcode: -1022 , sqlstate: 57011
IBM documentation
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.messages.sql.doc/doc/msql01022c.html
says there is no RAM to process the request.
My server has 36 GB RAM and is dedicated DB server running only DB2, no other extra processes were running at the time of issuing connect statement.
What might me the issue? I have Self Tuning Memory Manager set to ON the DB
Thanks in advance
Sree
