Hi there, everything you need to do with UDB is done by agents, every agent has its own private memory part of which is dedicated to the sortheap. There is a dbm configuration parameter that set the overall maximum ammount of memory all agents can use (SHEAPTHRES) if you set it to a larger ammount of memory you can maybe solve your problem. first remember that its a threshold for the total memory allocated to sorting so it should be a multiple of the sortheap, usually you should know the average number of connected application and multiply this by sortheap. Only one more advise depending on the system you are ( I missed it) you will be able to use more or less of your 3GB but usually not all, so be carefull setting these parameters to a too large value because you could start having other memory porblem somewhere else. hope this helps Fabrizio -----Messaggio originale----- Da: Sinha, Amit [mailto:[EMAIL PROTECTED]] Inviato: Tuesday, July 03, 2001 8:51 PM A: [EMAIL PROTECTED] Oggetto: RE: DB2EUG: SQL0995C - Sort memory cannot be allocated to process the stateme nt We have 3 gb of memory and quite sure not all of it is used and was wondering if sort heap was part of any other memory increasing which we should be fine ? What's private heap ? -----Original Message----- From: Vilas, Ajith (USPC.PCT.Hopewell) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 7:57 AM To: [EMAIL PROTECTED] Subject: RE: DB2EUG: SQL0995C - Sort memory cannot be allocated to process the stateme nt Amit, If the sort heap cannot be allocated, your system don't have enough memory to start this agent (private heap). Algorithm will try for smaller sizes, if the sortheap size parameter size cannot be allocated and will finally get out throwing the message you got. So, reducing the sort heap will force all agents to allocate lesser sort heaps and you'll have room for more agents. Regards, Ajith -----Original Message----- From: Sinha, Amit [mailto:[EMAIL PROTECTED]] Sent: Monday, July 02, 2001 7:28 PM To: [EMAIL PROTECTED] Subject: DB2EUG: SQL0995C - Sort memory cannot be allocated to process the stateme nt > Hi All, > > Recently, in one of our UDB 6.1 on AIX we are having sporadic prolems with > one of the queries in the application failing with SQL0995C Sort memory > cannot be allocated to process the statement. > > The explanation says Insufficient virtual memoy is available to the > database agent for sort processing. > User response : Terminate the application on receipt of this message. > Decrease the size of the sort heap parameter(sortheap) in the > corresponding database configuration file. > > > Was confused how would decreasing the sort memory would solve the problem > ? The UDB version 2 message reference manual says to increase the sort > heap parameter. So I am confused about which is right Version 5 and 6 > message manual or version 2 manual. > > Thanks. > > Amit Sinha ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
