Update Statistics High Error

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 ?

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 #

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. Sounds like you may have PSORT_DBTEMP set to a file system that is getting full or you don't have enough TEMP DBSPACE. > 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. The Informix Handbook?

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 ?

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 ?

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 #