Art's dostats crashing with a large table
Guys, and most specifically Art,
I tried running dostats on a table that is 1046 bytes wide with 9.5 billion
(yes, Billion) records, and it failed with error 1215. Error 1215 complaints
about the value being too large to fit in an integer, so I'd say the nrows is
in play... Please find my output and dostats version below.
Just wondering where to make the change from int to int8...
Ramon AKA Darth FanDeLaU
$> dostats -d <DBNAME> -t <TABNAME> -f-
Writing commands to: stdout
Working on database: <DBNAME>.
DATABASE <DBNAME>;
SET PDQPRIORITY 0;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 AND s.state != 'D' AND a.tabname
MATCHES '<TABNAME>' ORDER BY 1, 3, 4, 5;
$> dostats -V
dostats: Features Version 5.10, Source Revision: 1.146 !
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.
Very old version. The most recent fixed the last place where brows was not
handled by a bigint. Download the latest and let me know. You want
dostats_ng.ex from the latest utils2_ak package.
Art
On Mar 7, 2012 6:53 PM, "RAMON REY" <rrey@ipac.caltech.edu> wrote:
> Guys, and most specifically Art,
> I tried running dostats on a table that is 1046 bytes wide with 9.5 billion
> (yes, Billion) records, and it failed with error 1215. Error 1215
> complaints
> about the value being too large to fit in an integer, so I'd say the nrows
> is
> in play... Please find my output and dostats version below.
> Just wondering where to make the change from int to int8...
>
> Ramon AKA Darth FanDeLaU
>
> $> dostats -d <DBNAME> -t <TABNAME> -f-
> Writing commands to: stdout
>
> Working on database: <DBNAME>.
> DATABASE <DBNAME>;
> SET PDQPRIORITY 0;> 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 AND s.state != 'D' AND a.tabname
> MATCHES '<TABNAME>' ORDER BY 1, 3, 4, 5;
>
> $> dostats -V
>
> dostats: Features Version 5.10, Source Revision: 1.146 !
>
> 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.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f646abfff6e7d04bab06ac4