Re: dostats error
Depending on the version you upgraded from it may or may not be necessary to
drop distributions. To be on the safe side, I recommend to our clients that
one always should after an upgrade. When Oninit performs an upgrade for a
client we always drop distributions and recreate them into an empty
sysdistrib table.
Dostats still has features that 11.50 and OAT do not incorporate in the AUS
code.
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (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 9:08 AM, Habichtsberg, Reinhard <
RHabichtsberg@arz-emmendingen.de> wrote:
> 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>;
>
>
>
>