RE: 407: Error number zero received from the sqlexec process.

Do not run update statistics high on all tables in these circumstances. Find out what the issue is with and why. If you have very skewed data then high may help fix it - but only run it on columns. If you need to locate the problem table, locate which table has the problem by running update stats high on each table. Verify that you can reproduce it and report it to Tech Support. Post the full version of SE. Hard to help without it. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of R'gis > Sent: Monday, 26 May 2003 7:01 p.m. > To: informix-list@iiug.org > Subject: 407: Error number zero received from the sqlexec process. > > > After months with no problem, I now get this error each time > I try to launch > an "update statistics high". > It runs for about 10 minutes, and then stops with the error > message in the > subject. > After dbexport/dbimport of the database, the problem is still > the same but > occurs after more than one hour. > Update statistics medium works well in 10 minutes but I have> some queries > which take too much time to complete now. > > Error code 407 means: > > "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." > > The program software which runs "update statistics high" is > dbaccess. So, it > is compatible with the database engine. > > Some usefull informations about my system: > > Informix 7 SE on HP-UX 11 > The database is a datawarehouse. Nearly all the tables are deleted and > recreated each day. > > Some help would be usefull. > Thanks. > > Regis > >