IDS Forum

Re: Error 104 - File descriptor...

Posted By: JACQUES RENAUT
Date: Thursday, 24 January 2013, at 12:14 p.m.

In Response To: Re: Error 104 - File descriptor... (Cesar Inacio Martins)

Original Post:

Complementing...

The way I will use to monitor the amount of this FDs , without sure if
is correct or not....

# of open Files Descriptors.
$ onstat -g opn | awk '{print $3}' | sort | uniq -c | wc -l

721

Check what FDs is + shared.....
$ onstat -g opn | awk '{print $3}' | sort | uniq -c | sort -nk2
...

Response:

You need to look at the FD's per thread id. I think the 1st command you have isn't giving you what you think, which I think you're trying to get is the total number of FD's (and by FD I mean the internal IDS FD not the OS definition of FD). However, the limit that causes the 104 error to be returned is more then 32767 FD for 1 thread. So onstat -g opn by it self gives output for all threads. You need something to then go and sum up each grouping of lines by thread id, so you can tell how many FD's each thread has. So I think it would be more something like this you'd want to run:

onstat -g opn | awk '{print $1}' | uniq -c | sort -nk2

That should get you a count of FD's per thread id. The 1st column is the number of fd's 2nd column is Thread id. (You'd still want to clean that up some as it has stuff for the blank lines separating each thread id output and stuff). But I think it's closer to what you are looking for in terms of trying to monitor if any thread is getting close to the 32767 open table limit in the serer that generates 104 errors.

Jacques Renaut
IBM Informix Advanced Support
APD Team

Messages In This Thread

• Error 104 - File descriptor...
  Cesar Inacio Martins -- Thursday, 24 January 2013, at 9:47 a.m.
  • Re: Error 104 - File descriptor...
    Cesar Inacio Martins -- Thursday, 24 January 2013, at 11:41 a.m.
    • Re: Error 104 - File descriptor...
      JACQUES RENAUT -- Thursday, 24 January 2013, at 12:14 p.m.
      • Re: Error 104 - File descriptor...
        Cesar Inacio Martins -- Thursday, 24 January 2013, at 1:07 p.m.
        • Re: Error 104 - File descriptor...
          JACQUES RENAUT -- Friday, 25 January 2013, at 11:14 a.m.
          • Re: Error 104 - File descriptor...
            Cesar Inacio Martins -- Monday, 28 January 2013, at 5:50 a.m.
      • Re: Error 104 - File descriptor...
        Cesar Inacio Martins -- Thursday, 24 January 2013, at 1:29 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.