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
