Re: PSORT_DBTEMP and DBSPACETEMP

Hari Muthuswamy wrote: > > I am working on INFORMIX ONLINE Dynamic Server. I have come across a > problem where when I do a sort using Sequential Scan it blows up during > the weekends and sometimes during night time. ( SQL ERR:567 ISAM > ERR:28). This means the disk is full. ;-) > The PSORT_DBTEMP is pointing to the logical logs directory. When I > change it to /tmp, the sort queries work. The manual says using > PSORT_DBTEMP will definitely cause this problem. I outputted the disk > space in the logical logs directory when the problem happened, and there > was plenty of disk space. What does this mean? What is the logical logs directory? Are your logs stored in cooked files or are you setting PSORT_DBTEMP to the name of a dbspace? PSORT_DBTEMP must be set to a list of directory names. > The manual says to use DBSPACETEMP. I set up DBSPACETEMP as an > environmental variable and ran the sort queries but it would still blow > up. When I used PSORT_DBTEMP as an environmental variable, setting it to > /tmp, the queries work. DBSPACETEMP must be set to a list of dbspace names, NOT directory names. Also, PSORT_DBTEMP will over-ride the DBSPACETEMP variable. So 'unset' PSORT_DBTEMP if you want to use DBSPACETEMP. > We had this same problem sometime back when we had our configuration > variable PSORT_DBTEMP set to /tmp. Our previous DBA changed it to point > to the logical logs directory and it was working fine until recently. > Now when we set it to /tmp it seems to work fine. The bottom line here is that, which ever file system you have set PSORT_DBTEMP to hasn't got enough space for what you are trying to do. If you want to use the file system, then change the value of PSORT_DBTEMP. Otherwise, if you want to use OnLine disk space, then unset PSORT_DBTEMP and set DBSPACETEMP to dbspaces that DO have enough space. Hope that helps, -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+