Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    200

    Unanswered: 264: Could not write to a temporary file.

    Hi all,

    I have created a database in informix 9.4 IDS,it goes fine,
    Now when I tried to run a query which needs a lot of sorting,i hit this error:

    264: Could not write to a temporary file.

    131: ISAM error: no free disk space
    Error in line 8
    Near character position 17

    I checked my dbspaces and found there is no temp dbspace.

    Actually what is the problem and how can i solve this.
    I am very new to informix ,but have some exp in oracle,i belive both are almost same.

    Please assist
    Thanks and Regards
    micky

  2. #2
    Join Date
    Apr 2004
    Location
    zxczxczxc
    Posts
    52

    264: Could not write to a temporary file.

    Hi,

    I think the sort file is written to the /tmp directory or the Directory set by PSORT_DBTEMP. To avoid writing to these directories do the following.


    1) You can create new Temporary DBSPACE using onspaces -c -d tempdb -t
    -p Path/filename -o 0 -s Size in KB. You should create the filename before you run this command and set it owner to informix and permissions to 664.

    2) Add the newly created DBSPACE to the DBSPACETEMP Config Parameter in you ONCONIFG file which is located in you $INFORMIXDIR/etc directory and restart the Engine.


    Bye.
    zxczxczc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •