Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006
    Posts
    2

    Unanswered: 229: Could not open or create a temporary file

    Hi everyone,

    I got an error message saying that "229: Could not open or create a temporary file" when I was runing a query with four grouping.
    I checked /tmp file system and temp dbspacees and none of them ever been touch by the query.
    This is Informix database 8.50.FC2X2. on Sun Solaris.

    Please help!!!

    Thanks,
    Hoa

  2. #2
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248
    But do you have the right access permissions for /tmp? And what is the ISAM error code?

  3. #3
    Join Date
    Nov 2006
    Posts
    1
    Check 2 things
    1)On a UNIX system, try increasing the maximum number of open files
    2) Do you have DBTEMP env set up ? Id so check the Size.

Posting Permissions

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