KAIO: out of OS resource

Hi All, We are using Informix 9.4 on HPUX 11i with KAIO turned on. We are using = ESQLC Code, JDBC, Stored Procedure and dbaccess to access the database. = We have observed the following error message in the informix log file. I = have the following questions with regards to this error message: 1. What is the reason for this error message ? 2. What is the impact on database queries? Would there be some queries = that would have failed? 3. How to resolve this error message? -------------------------------------------------------------------------= ---------------------------------- 16:37:52 KAIO: out of OS resources, errno =3D 11, pid =3D 2293 16:38:34 KAIO: out of OS resources, errno =3D 11, pid =3D 2291 16:38:57 KAIO: out of OS resources, errno =3D 11, pid =3D 2291 16:40:21 KAIO: out of OS resources, errno =3D 11, pid =3D 2292 16:40:50 KAIO: out of OS resources, errno =3D 11, pid =3D 2293 -------------------------------------------------------------------------= ---------------------------------- Regards,=20 Rohit=20 =20

Kerhalkar, .... said: > Hi All, > > We are using Informix 9.4 on HPUX 11i with KAIO turned on. We are using = > ESQLC Code, JDBC, Stored Procedure and dbaccess to access the database. = > We have observed the following error message in the informix log file. I = > have the following questions with regards to this error message: > > 1. What is the reason for this error message ? You *did* read the release notes, didn't you? > 2. What is the impact on database queries? Would there be some queries = > that would have failed? You *did* read the release notes, didn't you? > 3. How to resolve this error message? You *did* read the release notes, didn't you? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco If anyone told you to be yourself they would be giving you bad advice. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed

-> -----Original Message----- -> From: Obnoxio The.... [mailto:obnoxio@serendipita.com] -> Sent: Thursday, January 20, 2005 10:59 AM -> To: ids@iiug.org -> Subject: Re: KAIO: out of OS resource [4056] -> -> -> -> Kerhalkar, .... said: -> > Hi All, -> > -> > We are using Informix 9.4 on HPUX 11i with KAIO turned on. -> We are using = -> > ESQLC Code, JDBC, Stored Procedure and dbaccess to access -> the database. = -> > We have observed the following error message in the -> informix log file. I = -> > have the following questions with regards to this error message: -> > -> > 1. What is the reason for this error message ? -> -> You *did* read the release notes, didn't you? In case you didn't An environment variable IFMX_HPKAIO_NUM_REQ is provided to specify the number of simultaneous KAIO requests that are processed by the server at one time. The value can be set in the range of 10 to 5000, the default being 1000. If the error "KAIO: out of OS resources, errno = %d, pid = %d" occurs, consider increasing the value of IFMX_HPKAIO_NUM_REQ. IFMX_HPKAIO_NUM_REQ=2300; export IFMX_HPKAIO_NUM_REQ (for Bourne or Korn Shell) setenv IFMX_HPKAIO_NUM_REQ 2300 (for C Shell) Keith -> -> > 2. What is the impact on database queries? Would there be -> some queries = -> > that would have failed? -> -> You *did* read the release notes, didn't you? -> -> > 3. How to resolve this error message? -> -> You *did* read the release notes, didn't you? -> -> -- -> -> Bye now, -> Obnoxio -> -> "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" -> - Coluche -> -> "I'm trying to see things your way, but I can't get my head -> up my ass" -> - JCH -> -> "Ogni uomo mi guarda come se fossi una testa di cazzo" -> - Marco -> -> If anyone told you to be yourself they would be giving you -> bad advice. -> -> I went to the airport to check in and they asked what I did because I -> looked like a terrorist. I said I was a comedian. They said, "Say -> something funny then." I told them I had just graduated from flying -> school. -> -> -- Ahmed Ahmed -> ******************************************************************************** ** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ******************************************************************************** **

Hello, the explanation from Keith how to resolve the error is from the relevant part of the release notes. But that does not answer question 2: 2. What is the impact on database queries? (or the database) I could not find anything about that in the release notes. Is there no impact? Or only performance? Regards, Andreas Kutsche > -----Original Message----- > From: forum.subscriber@iiug.org > [mailto:forum.subscriber@iiug.org]On Behalf Of Simmons, Keith > Sent: Thursday, January 20, 2005 2:17 PM > To: ids@iiug.org > Subject: RE: KAIO: out of OS resource [4057] > > > > > -> -----Original Message----- > -> From: Obnoxio The.... [mailto:obnoxio@serendipita.com] > -> Sent: Thursday, January 20, 2005 10:59 AM > -> To: ids@iiug.org > -> Subject: Re: KAIO: out of OS resource [4056] > -> > -> > -> > -> Kerhalkar, .... said: > -> > Hi All, > -> > > -> > We are using Informix 9.4 on HPUX 11i with KAIO turned on. > -> We are using = > -> > ESQLC Code, JDBC, Stored Procedure and dbaccess to access > -> the database. = > -> > We have observed the following error message in the > -> informix log file. I = > -> > have the following questions with regards to this error message: > -> > > -> > 1. What is the reason for this error message ? > -> > -> You *did* read the release notes, didn't you? > > In case you didn't > An environment variable IFMX_HPKAIO_NUM_REQ is provided to specify > the number of simultaneous KAIO requests that are processed by the > server at one time. The value can be set in the range of 10 to 5000, > the default being 1000. If the error > > "KAIO: out of OS resources, errno = %d, pid = %d" occurs, > consider increasing the value of IFMX_HPKAIO_NUM_REQ. > > IFMX_HPKAIO_NUM_REQ=2300; export IFMX_HPKAIO_NUM_REQ > (for Bourne or Korn Shell) > > setenv IFMX_HPKAIO_NUM_REQ 2300 (for C Shell) > > Keith > > -> > -> > 2. What is the impact on database queries? Would there be > -> some queries = > -> > that would have failed? > -> > -> You *did* read the release notes, didn't you? > -> > -> > 3. How to resolve this error message? > -> > -> You *did* read the release notes, didn't you? > -> > -> -- > -> > -> Bye now, > -> Obnoxio > -> > -> "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" > -> - Coluche > -> > -> "I'm trying to see things your way, but I can't get my head > -> up my ass" > -> - JCH > -> > -> "Ogni uomo mi guarda come se fossi una testa di cazzo" > -> - Marco > -> > -> If anyone told you to be yourself they would be giving you > -> bad advice. > -> > -> I went to the airport to check in and they asked what I > did because I > -> looked like a terrorist. I said I was a comedian. They said, "Say > -> something funny then." I told them I had just graduated from flying > -> school. > -> > -> -- Ahmed Ahmed > -> > > > ************************************************************** > ******************** > This message is sent in strict confidence for the addressee > only. It may > contain legally privileged information. The contents are not > to be disclosed > to anyone other than the addressee. Unauthorised recipients > are requested > to preserve this confidentiality and to advise the sender > immediately of any > error in transmission. > This footnote also confirms that this email message has been > swept for the > presence of computer viruses, however we cannot guarantee > that this message > is free from such problems. > ************************************************************** > ******************** > > > >

Andreas.KUT.... said: > Hello, > > the explanation from Keith how to resolve the error is from the relevant > part of the release notes. > But that does not answer question 2: 2. What is the impact on database > queries? (or the database) > > I could not find anything about that in the release notes. Is there no > impact? Or only performance? I think it just hands them off to AIO threads. I'm not sure what would happen if you didn't have any. >> -----Original Message----- >> From: forum.subscriber@iiug.org >> [mailto:forum.subscriber@iiug.org]On Behalf Of Simmons, Keith >> Sent: Thursday, January 20, 2005 2:17 PM >> To: ids@iiug.org >> Subject: RE: KAIO: out of OS resource [4057] >> >> >> >> >> -> -----Original Message----- >> -> From: Obnoxio The.... [mailto:obnoxio@serendipita.com] >> -> Sent: Thursday, January 20, 2005 10:59 AM >> -> To: ids@iiug.org >> -> Subject: Re: KAIO: out of OS resource [4056] >> -> >> -> >> -> >> -> Kerhalkar, .... said: >> -> > Hi All, >> -> > >> -> > We are using Informix 9.4 on HPUX 11i with KAIO turned on. >> -> We are using = >> -> > ESQLC Code, JDBC, Stored Procedure and dbaccess to access >> -> the database. = >> -> > We have observed the following error message in the >> -> informix log file. I = >> -> > have the following questions with regards to this error message: >> -> > >> -> > 1. What is the reason for this error message ? >> -> >> -> You *did* read the release notes, didn't you? >> >> In case you didn't >> An environment variable IFMX_HPKAIO_NUM_REQ is provided to specify >> the number of simultaneous KAIO requests that are processed by the >> server at one time. The value can be set in the range of 10 to 5000, >> the default being 1000. If the error >> >> "KAIO: out of OS resources, errno = %d, pid = %d" occurs, >> consider increasing the value of IFMX_HPKAIO_NUM_REQ. >> >> IFMX_HPKAIO_NUM_REQ=2300; export IFMX_HPKAIO_NUM_REQ >> (for Bourne or Korn Shell) >> >> setenv IFMX_HPKAIO_NUM_REQ 2300 (for C Shell) >> >> Keith >> >> -> >> -> > 2. What is the impact on database queries? Would there be >> -> some queries = >> -> > that would have failed? >> -> >> -> You *did* read the release notes, didn't you? >> -> >> -> > 3. How to resolve this error message? >> -> >> -> You *did* read the release notes, didn't you? >> -> >> -> -- >> -> >> -> Bye now, >> -> Obnoxio >> -> >> -> "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" >> -> - Coluche >> -> >> -> "I'm trying to see things your way, but I can't get my head >> -> up my ass" >> -> - JCH >> -> >> -> "Ogni uomo mi guarda come se fossi una testa di cazzo" >> -> - Marco >> -> >> -> If anyone told you to be yourself they would be giving you >> -> bad advice. >> -> >> -> I went to the airport to check in and they asked what I >> did because I >> -> looked like a terrorist. I said I was a comedian. They said, "Say >> -> something funny then." I told them I had just graduated from flying >> -> school. >> -> >> -> -- Ahmed Ahmed >> -> >> >> >> ************************************************************** >> ******************** >> This message is sent in strict confidence for the addressee >> only. It may >> contain legally privileged information. The contents are not >> to be disclosed >> to anyone other than the addressee. Unauthorised recipients >> are requested >> to preserve this confidentiality and to advise the sender >> immediately of any >> error in transmission. >> This footnote also confirms that this email message has been >> swept for the >> presence of computer viruses, however we cannot guarantee >> that this message >> is free from such problems. >> ************************************************************** >> ******************** >> >> >> >> > > -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco If anyone told you to be yourself they would be giving you bad advice. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed

First, you did not understand the question fully. Second, you didn't know the answer. Please don't bother to reply. Regards, Rohit -----Original Message----- From: Obnoxio The Chav [mailto:obnoxio@serendipita.com] Sent: Friday, January 21, 2005 2:47 AM To: Kerhalkar, Rohit Cc: ids@iiug.org Subject: RE: KAIO: out of OS resource [4057] Kerhalkar, Rohit said: > > Thanx for the help but I need a better answer. Perhaps you need to ask a better question. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco If anyone told you to be yourself they would be giving you bad advice. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed

Kerhalkar, Rohit said: > First, you did not understand the question fully. Second, you didn't know > the answer. Please don't bother to reply. Gosh, well, that's me thoroughly chastened. And I'm terribly sorry for trying to help. Won't waste your infinitely valuable time again. -- Bye now, Obnoxio "I'm trying to see things your way, but I can't get my head up my ass" - JCH