> 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
