RE: [ifxmaillist] Problem updating statistics high
Brian
Try ulimit -n 1024
in the environment.
Murray Wood
-----Original Message-----
From: owner-ifxmaillist@quanta.co.nz
[mailto:owner-ifxmaillist@quanta.co.nz]On Behalf Of Brian P Millett
Sent: Sunday, March 26, 2000 4:39 AM
To: informix-list@iiug.org
Subject: [ifxmaillist] 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