Hi All,

I am using DB2 V7.1 and Fixpak 5 server and oslevel as Aix5.2 . I am getting error in the db2diag.log as
2007-08-15-17.57.20.588710 Instance:udbprd1 Node:000
PID:69780(db2agntp (MIAMI)) Appid:0A69E41A.0955.070815153129
sort/list_services sqlsAllocateSortMemory Probe:35 Database:MIAMI

Not enough memory available for a (private) sort heap of size 25000
Trying smaller size...

so we increased the parameter sort heap threshold(SHEAPTHRES)-dbm and issued db2terminate. After executing also we faced same problem.

Any Help....

Many Thanks
Meena.s

SHEAPTHRES is a DBM level parameter. I do not remember in V7, but you might have to stop the instance (db2stop) for a change to take effect.

Andy

You must be hitting the private memory limit at the OS level. See if increasing ulimit to 256MB helps. You can also try reducing SORTHEAP and/or APPLHEAPSZ. That, obviously, would have performance implications.

Hi ,

We have restarted the instance, and we are not getting the error now, have to check with the application team. The issue is resolved now.


Thanks for all your support.


Regards
Meena.s

Hi All,

After restarting the instance, we are getting the error while connecting to the database.
db2 connect to miami
SQL0987C The application control shared memory set cannot be allocated.
SQLSTATE=57011

It seems like we need to reduce the parameters sortheap and Application heap size..

Any Help...

Thanks
Meena.s