On Wed, 30 Jul 2003 15:01:59 -0400, Francisco Roldan wrote:
> Hi everybody,
> I run this every night on my server :
>
> set explain on;
> update statistics high;
>
> But everyday i found the error message in my log file :
>
> Explain set.
>
>
> 567: Cannot write sorted rows.
>
> 179: ISAM error: no free disk space for sort
>
>
> I supose that i have to enlarge my temp dbspace ? But my concern is that
> i haven't been updating statistics never,
Or set PDQPRIORITY > 2 to sort in memory and set PSORT_NPROCS to invoke
the parallel sort package (and/or set PSORT_DBTEMP to 3-5 filesystems
[not dbspaces!] to move the sort-work files out of the tempdbs). Also
you could break up the stats into separate commands for each table which
will reduce the need to sort and the amount of data sorted. Take a look
at any of the update stats utilities available on the IIUG Software
Repository which will do this for you automatically, including my own
dostats ec in the package utils2_ak which I humbly submit is the best of
the them. Do stats is written in ESQL/C but there are others in ksh and
perl that so a respectable job but have fewer options.
> Does this message mean that there was no update on the statistics? Or
> just some part of the update ?
Probably. You can check with dbschema -d<database> -hd

or query sysdistrib and look at the constructed date.

Art S. Kagel
> Thanks in advance
>
> regards
>
>
> sending to informix-list