Results 1 to 3 of 3

Thread: error -229

  1. #1
    Join Date
    Sep 2002
    Location
    Zimbabwe
    Posts
    2

    Unanswered: error -229

    hi all,
    we are running IDS 9.21 on HP-UX11.0.
    there are loads of ISQL reports which have never given any problems untill about a month ago, when one of them generated the error message:
    Error -229. Cannot open or create a tempoarary file.
    But the rest of the reports ran fine , untill a few days ago when three more reports generated the same error message.

    It sounds like there's no disk space...?

    I've checked and changed ownership and permissions of directories where the reports sit, and where their data is output to.
    I've tried adding a DBTEMP environment variable in the home directories of the various users. (Apparently IDS does NOT use the DBTEMP variable???)
    the manual says that by default /tmp will be used if DBTEMP is not set.
    So I deleted all unused files from /tmp.

    .... no success at all! Boo hoo blubb blubb.

    Anyone had the same problem?

    Thanks

    MIke

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534

    Re: error -229

    Hi,

    A few possibilities here:

    Try increasing you maximum open files on the Unix OS.
    DBTEMP is not used by IDS, Do you have a temporary Dbspace?
    What is the value of DBSPACETEMP in your $INFORMIXDIR/etc/$ONCONFIG file?
    What are the permissions on /tmp?
    Who is the owner of the oninit process?
    rws

  3. #3
    Join Date
    Mar 2002
    Posts
    112

    re

    use command onstat -d and find for your dbspace that you want to be temp space if you don't see flag 'T' you have to drop and recreate it for temp space
    Last edited by dananio; 10-08-02 at 06:50.

Posting Permissions

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