Unix Technical Forum

foreach and open descriptor

This is a discussion on foreach and open descriptor within the Informix forums, part of the Database Server Software category; --> hi, i'm executing routines containing foreach ... end foreach instructions. it seems that after many execution onstat -g opn ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 05:33 PM
vomaringo@yahoo.com
 
Posts: n/a
Default foreach and open descriptor

hi,
i'm executing routines containing foreach ... end foreach
instructions. it seems that after many execution
onstat -g opn shows a great number of lines and my session hangs.
what's could be the linux kernel parameter that could increase the
number of available open descriptor for a session? i'm running ids10
on linux rhel 4.
thanks.
jack
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-20-2008, 05:33 PM
jprenaut@yahoo.com
 
Posts: n/a
Default Re: foreach and open descriptor

On Feb 18, 4:20 pm, vomari...@yahoo.com wrote:
> hi,
> i'm executing routines containing foreach ... end foreach
> instructions. it seems that after many execution
> onstat -g opn shows a great number of lines and my session hangs.
> what's could be the linux kernel parameter that could increase the
> number of available open descriptor for a session? i'm running ids10
> on linux rhel 4.
> thanks.
> jack


onstat -g opn doesn't list any resource that would be controlled by
the linux kernel (well technically I suppose you could say "memory"
but that's about it).

What does onstat -u, onstat -g ses <hung session id> and possibly
onstat -g stk <threadid of your hung session> show? Is your session
waiting for some resource?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-20-2008, 05:33 PM
TBP (The Big Potato)
 
Posts: n/a
Default Re: foreach and open descriptor

jprenaut@yahoo.com wrote:
> On Feb 18, 4:20 pm, vomari...@yahoo.com wrote:
>
>>hi,
>>i'm executing routines containing foreach ... end foreach
>>instructions. it seems that after many execution
>>onstat -g opn shows a great number of lines and my session hangs.
>>what's could be the linux kernel parameter that could increase the
>>number of available open descriptor for a session? i'm running ids10
>>on linux rhel 4.
>>thanks.
>>jack

>
>
> onstat -g opn doesn't list any resource that would be controlled by
> the linux kernel (well technically I suppose you could say "memory"
> but that's about it).
>
> What does onstat -u, onstat -g ses <hung session id> and possibly
> onstat -g stk <threadid of your hung session> show? Is your session
> waiting for some resource?

Post a little bit of the onstat -g opn ... perhaps you are mis-handling something :-/
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-20-2008, 05:33 PM
Fernando Nunes
 
Posts: n/a
Default Re: foreach and open descriptor

TBP (The Big Potato) wrote:
> jprenaut@yahoo.com wrote:
>> On Feb 18, 4:20 pm, vomari...@yahoo.com wrote:
>>
>>> hi,
>>> i'm executing routines containing foreach ... end foreach
>>> instructions. it seems that after many execution
>>> onstat -g opn shows a great number of lines and my session hangs.
>>> what's could be the linux kernel parameter that could increase the
>>> number of available open descriptor for a session? i'm running ids10
>>> on linux rhel 4.
>>> thanks.
>>> jack

>>
>>
>> onstat -g opn doesn't list any resource that would be controlled by
>> the linux kernel (well technically I suppose you could say "memory"
>> but that's about it).
>>
>> What does onstat -u, onstat -g ses <hung session id> and possibly
>> onstat -g stk <threadid of your hung session> show? Is your session
>> waiting for some resource?

> Post a little bit of the onstat -g opn ... perhaps you are mis-handling
> something :-/


and when you say "routines", what exactly are you doing...?

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-20-2008, 05:33 PM
vomaringo@yahoo.com
 
Posts: n/a
Default Re: foreach and open descriptor

On 18 fév, 23:39, Fernando Nunes <s...@onlinedomus.net> wrote:
> TBP (The Big Potato) wrote:
>
>
>
> > jpren...@yahoo.com wrote:
> >> On Feb 18, 4:20 pm, vomari...@yahoo.com wrote:

>
> >>> hi,
> >>> i'm executing routines containing foreach ... end foreach
> >>> instructions. it seems that after many execution
> >>> onstat -g opn shows a great number of lines and my session hangs.
> >>> what's could be the linux kernel parameter that could increase the
> >>> number of available open descriptor for a session? i'm running ids10
> >>> on linux rhel 4.
> >>> thanks.
> >>> jack

>
> >> onstat -g opn doesn't list any resource that would be controlled by
> >> the linux kernel (well technically I suppose you could say "memory"
> >> but that's about it).

>
> >> What does onstat -u, onstat -g ses <hung session id> and possibly
> >> onstat -g stk <threadid of your hung session> show? Is your session
> >> waiting for some resource?

> > Post a little bit of the onstat -g opn ... perhaps you are mis-handling
> > something :-/

>
> and when you say "routines", what exactly are you doing...?
>
> --
> Fernando Nunes
> Portugal
>
> http://informix-technology.blogspot.com
> My email works... but I don't check it frequently...


well, the 3rd columns of onstat -g opn reach 64000 for a single
session. some SP contains many nested foreach and call others SP.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 04-20-2008, 05:33 PM
Jeroen Keppens
 
Posts: n/a
Default OpenAdmin problem

Hi all,

I'm setting up a development environment on a Red Hat Enterprice 5 and
I'm running in a small problem.

I have installed IDS 11 Dev Edition (iif.11.10.UC1DE.Linux-RHEL4),
Unix ODBC 2.2.12, Zend Core for IBM 2.5. I have recompiled pdo
informix from pecl and added it - together with pdo_sqlite, gd and
soap, to the php.ini file.

I've setup my odbc and I can connect to the database trough isql.

I've followed the installation notes for Open Admin for IDS (version
2.11.01) and the installation went well... until I tried logging in:

Connection Failed:
DSN:informix:host
=
127.0.0.1
;service
=
50000
;database=sysmaster;protocol=onsoctcp;server=demo_ on;TRANSLATIONDLL=/
opt/informix/lib/esql/igo4a304.so;Driver=/opt/informix/lib/cli/
libifdmr.so;
SQLSTATE=08001, SQLDriverConnect: -1013 [IBM][CLI Driver] SQL10007N
Message "0" could not be retrieved. Reason code: "3".

I've tried to manually substititude the dsn to use the odbc one, but
that didn't work either.

I have checked my php env and I can clearly see that the environment
variables are set correctly.

Anyone an idea what the problem could be or how I can solve this?

Thanks,

Jeroen
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:59 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com