Re: Update Statistics High Error

/cooked_file/dbs_tempT is decreasing to zero. That is the problem? How can i change the size? Regards, Paul Watson <paul@oninit.com> wrote in message news:<3F5E120F.FE9485CE@oninit.com>... > When it's running what is decreasing - that is the problem area > > Daniel Castro wrote: > > > > That's the result : > > Informix Dynamic Server Version 9.30.UC1 -- On-Line -- Up 20:02:48 -- 499764 > > Kbytes > > > > Dbspaces > > address number flags fchunk nchunks flags owner name > > 241417d0 1 0x1001 1 1 N informix rootdbs > > 241db8d0 2 0x1 2 1 N informix wpdphlog > > 241dba18 3 0x1 3 1 N informix wpdllog > > 241dbb60 4 0x11 4 1 N B informix wpdblobsmedview > > 241dbca8 5 0x1 5 5 N informix wpddados > > 241dbdf0 7 0x2001 11 1 N T informix wpdtemp1 > > 6 active, 2047 maximum > > > > Note: For BLOB chunks, the number of free pages shown is out of date. > > Run 'onstat -d update' for current stats. > > > > Chunks > > address chk/dbs offset size free bpages flags pathname > > 24141918 1 1 0 235519 32965 PO- /cooked_file/dbs_root > > P > > 24141ba0 2 2 0 301000 270947 PO- /cooked_file/dbs_plog > > P > > 24141d10 3 3 0 201000 200947 PO- /cooked_file/dbs_llog > > P > > 24141e80 4 4 0 30000 ~15000 15000 POB /cooked_file/dbs_blob > > sP > > 241db030 5 5 0 1000000 83 PO- /cooked_file/dbs_dado > > sP > > 241db1a0 6 5 0 1000000 5 PO- /cooked_file/dbs_dado > > s1P > > 241db310 7 5 0 1000000 406212 PO- /cooked_file/dbs_dado > > s2P > > 241db480 8 5 0 1000000 999997 PO- /cooked_file/dbs_dado > > s3P > > 241db5f0 9 5 0 1000000 999997 PO- /cooked_file/dbs_dado > > s4P > > 241db760 11 7 0 1000000 976255 PO- /cooked_file/dbs_temp > > P1 > > 10 active, 2047 maximum > > > > [informix@node1 informix]$ df -k > > Filesystem 1k-blocks Used Available Use% Mounted on > > /dev/sda5 4032032 399628 3427580 11% / > > /dev/sda1 77445 19115 54332 27% /boot > > none 1032420 0 1032420 0% /dev/shm > > /dev/sda3 4032064 1454544 2372696 39% /usr > > /dev/sda2 6048260 74536 5666488 2% /var > > /dev/nb0 71086676 25194920 45891756 36% /home > > > > I can't see where I need more space. > > Can you see where is the problem? > > > > Thanks a lot! > > > > Paul Watson <paul@oninit.com> wrote in message news:<3F5DE08C.402C9835@oninit.com>... > > > Set PSORT_DBTEMP to a directory with space > > > Look at DBSPACETEMP, make sure they are not filling > > > > > > If you check onstat -d and df -k you'll see where the space is needed > > > > > > Paul > > > > > > Daniel Castro wrote: > > > > > > > > When I try to execute update statistics high, I get the following > > > > error : > > > > > > > > Database selected. > > > > > > > > 564: Cannot sort rows.> > > > > > > > 179: ISAM error: no free disk space for sort> > > > > > > > Database closed. > > > > > > > > I use cron, with the user root to schedule it. > > > > > > > > Informix Version : 9.30 UC1. > > > > > > > > I also want to know if there is any good book about informix database > > > > administration. > > > > > > > > Can somebody help me ?

Use onspaces and add some more Daniel Castro wrote: > > /cooked_file/dbs_tempT is decreasing to zero. > That is the problem? > How can i change the size? > > Regards, > > Paul Watson <paul@oninit.com> wrote in message news:<3F5E120F.FE9485CE@oninit.com>... > > When it's running what is decreasing - that is the problem area > > > > Daniel Castro wrote: > > > > > > That's the result : > > > Informix Dynamic Server Version 9.30.UC1 -- On-Line -- Up 20:02:48 -- 499764 > > > Kbytes > > > > > > Dbspaces > > > address number flags fchunk nchunks flags owner name > > > 241417d0 1 0x1001 1 1 N informix rootdbs > > > 241db8d0 2 0x1 2 1 N informix wpdphlog > > > 241dba18 3 0x1 3 1 N informix wpdllog > > > 241dbb60 4 0x11 4 1 N B informix wpdblobsmedview > > > 241dbca8 5 0x1 5 5 N informix wpddados > > > 241dbdf0 7 0x2001 11 1 N T informix wpdtemp1 > > > 6 active, 2047 maximum > > > > > > Note: For BLOB chunks, the number of free pages shown is out of date. > > > Run 'onstat -d update' for current stats. > > > > > > Chunks > > > address chk/dbs offset size free bpages flags pathname > > > 24141918 1 1 0 235519 32965 PO- /cooked_file/dbs_root > > > P > > > 24141ba0 2 2 0 301000 270947 PO- /cooked_file/dbs_plog > > > P > > > 24141d10 3 3 0 201000 200947 PO- /cooked_file/dbs_llog > > > P > > > 24141e80 4 4 0 30000 ~15000 15000 POB /cooked_file/dbs_blob > > > sP > > > 241db030 5 5 0 1000000 83 PO- /cooked_file/dbs_dado > > > sP > > > 241db1a0 6 5 0 1000000 5 PO- /cooked_file/dbs_dado > > > s1P > > > 241db310 7 5 0 1000000 406212 PO- /cooked_file/dbs_dado > > > s2P > > > 241db480 8 5 0 1000000 999997 PO- /cooked_file/dbs_dado > > > s3P > > > 241db5f0 9 5 0 1000000 999997 PO- /cooked_file/dbs_dado > > > s4P > > > 241db760 11 7 0 1000000 976255 PO- /cooked_file/dbs_temp > > > P1 > > > 10 active, 2047 maximum > > > > > > [informix@node1 informix]$ df -k > > > Filesystem 1k-blocks Used Available Use% Mounted on > > > /dev/sda5 4032032 399628 3427580 11% / > > > /dev/sda1 77445 19115 54332 27% /boot > > > none 1032420 0 1032420 0% /dev/shm > > > /dev/sda3 4032064 1454544 2372696 39% /usr > > > /dev/sda2 6048260 74536 5666488 2% /var > > > /dev/nb0 71086676 25194920 45891756 36% /home > > > > > > I can't see where I need more space. > > > Can you see where is the problem? > > > > > > Thanks a lot! > > > > > > Paul Watson <paul@oninit.com> wrote in message news:<3F5DE08C.402C9835@oninit.com>... > > > > Set PSORT_DBTEMP to a directory with space > > > > Look at DBSPACETEMP, make sure they are not filling > > > > > > > > If you check onstat -d and df -k you'll see where the space is needed > > > > > > > > Paul > > > > > > > > Daniel Castro wrote: > > > > > > > > > > When I try to execute update statistics high, I get the following > > > > > error : > > > > > > > > > > Database selected. > > > > > > > > > > 564: Cannot sort rows.> > > > > > > > > > 179: ISAM error: no free disk space for sort> > > > > > > > > > Database closed. > > > > > > > > > > I use cron, with the user root to schedule it. > > > > > > > > > > Informix Version : 9.30 UC1. > > > > > > > > > > I also want to know if there is any good book about informix database > > > > > administration. > > > > > > > > > > Can somebody help me ? -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #