Re: dostats error

Hi Art, with the newest version of dostats compiled with csdk3.50.FC3 the error doesn't appear any more. Thanks for the great tool, though I guess that the functions are provided by the server itself since IDS 11.50. To refresh all update stats as you recommended ealier is it enough to do dostats over all tables or do one have to drop distributions explicitly? Regards, Reinhard. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Art Kagel Sent: Thursday, May 14, 2009 1:14 PM To: Habichtsberg, Reinhard Cc: Informix-List (E-Mail) Subject: Re: dostats error SQLCODE -1215 is: -1215 Value too large to fit in an INTEGER. The INTEGER or SERIAL data type can accept numbers with absolute values from 0 through 2,147,483,647 (plus or minus (2 to the 31st power) - 1). Version 1.137 is an older release. The current release, which is available from the IIUG Software Repository, is 1.153 which may relieve the problem. I looks like the number of rows in one of your tables is too large for the integer nrows. If downloading and compiling the newer version doesn't fix this for you, contact me directly. Art Art S. Kagel Oninit ( www.oninit.com <http://www.oninit.com>; ) IIUG Board of Directors ( art@iiug.org <mailto:art@iiug.org> ) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, May 14, 2009 at 6:16 AM, Habichtsberg, Reinhard < RHabichtsberg@arz-emmendingen.de <mailto:RHabichtsberg@arz-emmendingen.de> > wrote: Hi, with the command dostats -d database --f file after a couple of successful actions appears the following error: FAILED: Cannot FETCH table data (a1). SQLCODE = -1215, ISAM = 0. Statement is: SELECT a.tabid, a.partnum, a.nrows, a.tabname, a.owner,indexkeyarray_out(b.indexkeys) AS allparts, 0 FROM "informix".systables a, outer ("informix".sysindices b, outer "informix".sysobjstate s) WHERE a.tabid = b.tabid AND tabtype = 'T' AND a.tabid >= 100 AND a.tabid = s.tabid AND s.objtype = 'I' AND b.idxname = s.name <http://s.name>; AND s.state != 'D' ORDER BY 1, 3, 4, 5; dostats: Features Version 5.10, Source Revision: 1.137 ! Copyright 1996-2006 by Art S. Kagel. License for private usage (including use by commercial enterprise for its own needs) is granted. Commercial and exploitation rights are reserved. IDS 11.50.FC3, Solaris 9 The command was successful before I did "update statistics medium for table" and "update statistcs for procedure". And I killed an update stats job not sure what he did in that moment. The query above works without an error in dbaccess. Any ideas what causes the error? Regards, Reinhard _______________________________________________ Informix-list mailing list Informix-list@iiug.org <mailto:Informix-list@iiug.org> http://www.iiug.org/mailman/listinfo/informix-list <http://www.iiug.org/mailman/listinfo/informix-list>;