Need help with SQL error 406

Hi I need some advice on How to resolve the SQL error 406. We are using HP_UX 10.20 with Informix Dynamic server 7.24. I would like to know what kernel parameters I may increase to provide more memory for the transactions. I get this error intermittently, when the application is requesting some records to be retrieved from the database. Any help would be very much appreciated. Shankar *****Confidentiality Notice***** This message is confidential. If you are not the intended recipient, you may not copy or otherwise disclose the contents of this message to any other person. If you have received this message in error, please contact the sender immediately by return e-mail. Thank you.

Have a look at onstat -g seg. What are the SHM parameters in your onconfig? What is your OS shared memory configuration / limits? How much of the memory is allocated on your server? MW > -----Original Message----- > From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On > Behalf Of Yoganathan,.... > Sent: Tuesday, 16 September 2003 3:58 a.m. > To: ids@iiug.org > Subject: Need help with SQL error 406 [1876] > > > Hi > > I need some advice on How to resolve the SQL error 406. > > We are using HP_UX 10.20 with Informix Dynamic server 7.24. I > would like to know > what kernel parameters I may increase to provide more memory for the > transactions. > > I get this error intermittently, when the application is > requesting some records > to be retrieved from the database. > > Any help would be very much appreciated. > > Shankar > > > *****Confidentiality Notice***** > This message is confidential. If you are not the intended > recipient, you may not > copy or otherwise disclose the contents of this message to > any other person. If > you have received this message in error, please contact the > sender immediately > by return e-mail. Thank you. > > > > >