Problem updating statistics high

Hello, I am trying to update the statistics high on a table. I get the following errors: 567: Cannot write sorted rows. 2: No such file or directory I have a Sparc Solaris 7 (11/99 build) with 128 mb ram. Onstat -d gives: INFORMIX-Universal Server Version 9.14.UC6 -- On-Line -- Up 01:31:50 -- 31584 Kbytes Dbspaces address number flags fchunk nchunks flags owner name a798148 1 2 1 1 M informix rootdbs a798c10 2 1 2 3 N informix trop_dbsp1 a798c88 3 1 5 2 N informix logspace a798d00 4 2001 7 3 N T informix tempdbs1 4 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname a7981c0 1 1 0 1000000 998016 PO- /dev/rootdbs1 a798298 1 1 0 1000000 0 MO- /dev/rootdbs2 a798550 2 2 0 1000000 995763 PO- /dev/dbspace1 a798628 3 2 0 1000000 999997 PO- /dev/dbspace2 a798700 4 2 0 1000000 999997 PO- /dev/dbspace3 a7987d8 5 3 0 1000000 349947 PO- /dev/logspace a7988b0 6 3 0 1000000 999997 PO- /dev/logspace2 a798988 7 4 0 1000000 999947 PO- /dev/tempdbs1 a798a60 8 4 0 1000000 999997 PO- /dev/tempdbs2 a798b38 9 4 0 500000 499997 PO- /opt2/informixTempSpace 9 active, 2047 maximum Looks like there is room, informix sees all of the dbspaces. File permissions are all 660, informix:informix Any ideas? Thanks -- Brian Millett Enterprise Consulting Group "Shifts in paradigms (314) 205-9030 often cause nose bleeds." bpm@ec-group.com Greg Glenn

If you have PSORT_DBTEMP set the sort-work files will be written to the filesystems listed in that variable. Also if you do not have PSORT_DBTEMP set the sort-work files are written to the dbspaces listed in DBSPACETEMP else to the rootdb. Check these areas during the update stats run. Another thing. Are you trying to UPDATE STATISTICS HIGH on the whole database at once? This takes HUGE sort space and is MUCH slower than doing all tables individually, in addition you need not do HIGH for all columns of all tables. See the recommended suite of UPDATE STATS commands in the Performance Guide or get my utility dostats or one of the other UPDATE STATS utilities available from the IIUG Software Repository. Dostats is part of the package utils2_ak which I submitted to the Repository. Art S. Kagel Brian P Millett wrote: > Hello, I am trying to update the statistics high on a table. I get the > following errors: > > 567: Cannot write sorted rows.> 2: No such file or directory > > I have a Sparc Solaris 7 (11/99 build) with 128 mb ram. Onstat -d > gives: > > INFORMIX-Universal Server Version 9.14.UC6 -- On-Line -- Up 01:31:50 > -- 31584 Kbytes > > Dbspaces > address number flags fchunk nchunks flags owner name > a798148 1 2 1 1 M informix rootdbs > a798c10 2 1 2 3 N informix > trop_dbsp1 > a798c88 3 1 5 2 N informix logspace > a798d00 4 2001 7 3 N T informix tempdbs1 > 4 active, 2047 maximum > > Chunks > address chk/dbs offset size free bpages flags pathname > a7981c0 1 1 0 1000000 998016 PO- /dev/rootdbs1 > > a798298 1 1 0 1000000 0 MO- /dev/rootdbs2 > > a798550 2 2 0 1000000 995763 PO- /dev/dbspace1 > > a798628 3 2 0 1000000 999997 PO- /dev/dbspace2 > > a798700 4 2 0 1000000 999997 PO- /dev/dbspace3 > > a7987d8 5 3 0 1000000 349947 PO- /dev/logspace > > a7988b0 6 3 0 1000000 999997 PO- > /dev/logspace2 > a798988 7 4 0 1000000 999947 PO- /dev/tempdbs1 > > a798a60 8 4 0 1000000 999997 PO- /dev/tempdbs2 > > a798b38 9 4 0 500000 499997 PO- > /opt2/informixTempSpace > 9 active, 2047 maximum > > Looks like there is room, informix sees all of the dbspaces. > > File permissions are all 660, informix:informix > > Any ideas? > > Thanks > > -- > Brian Millett > Enterprise Consulting Group "Shifts in paradigms > (314) 205-9030 often cause nose bleeds." > bpm@ec-group.com Greg Glenn