Update Statistics High 407 Error

IDS: 7.31.UC5 OS: HP-UX 11.0.B ERROR: 407:Error number zero received from the sqlexec process =20 I'm getting a 407 error whan attempting to run Update Statistics High =66or a particular table within dbaccess. I don't get the error when running LOW & MEDIUM statistics for the same table. According to the Error manual summary it supposedly has something to do with the library functions that are called (see below). Any ideas=3F =20 Error number zero received from the sqlexec process.=20 This internal error indicates a problem in the communication between the database server and the library functions that call it. Make sure that your program software is compatible with the database engine in use. If the error recurs, note all circumstances and contact Informix Technical Support. . Anthony Ojeda=20 Sr. Systems Administrator=20 =20 LATHAM & WATKINS LLP=20 555 W. 5th Street, Suite 800=20 Los Angeles, CA 90013-1010=20 Direct Tel: (213) 891-7211=20 =46ax: (213) 891-7123=20 E-mail: anthony.ojeda@lw.com=20 www.lw.com <http://www.lw.com/>; =20 This email may contain material that is confidential, privileged and/or = attorney work product for the sole use of the intended recipient. Any = review, reliance or distribution by others or forwarding without express = permission is strictly prohibited. If you are not the intended recipient, = please contact the sender and delete all copies. Latham & Watkins LLP

Anthony For versions of 7.31 you should be on a UD not a UC version, probably UD8 now. I would expect this to fix your problem. You can find out which table by running update statistics on each table in turn. Then check that table with oncheck -cDI. MW > -----Original Message----- > From: forum.subscriber@iiug.org > [mailto:forum.subscriber@iiug.org] On Behalf Of Anthony.Oje.... > Sent: Wednesday, 1 June 2005 2:53 a.m. > To: ids@iiug.org > Subject: Update Statistics High 407 Error [5068] > > IDS: 7.31.UC5 > OS: HP-UX 11.0.B > ERROR: 407:Error number zero received from the sqlexec > process =20 I'm getting a 407 error whan attempting to run > Update Statistics High =66or a particular table within> dbaccess. I don't get the error when running LOW & MEDIUM > statistics for the same table. According to the Error manual > summary it supposedly has something to do with the library > functions that are called (see below). Any ideas=3F =20 > Error number zero received from the sqlexec process.=20 > This internal error indicates a problem in the > communication between the database server and the library > functions that call it. > Make sure that your program software is compatible with the > database engine in use. If the error recurs, note all > circumstances and contact Informix Technical Support. > >