Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Resource Govenor for 'Prepared Statements' exceeded help

4 posts in General Discussion Last posting was on 2005-01-10 15:26:25.0Z
Mark Posted on 2004-12-10 13:46:19.0Z
From: "Mark" <mchristy@tds.net>
Newsgroups: ianywhere.public.general
Subject: Resource Govenor for 'Prepared Statements' exceeded help
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: h69-128-201-220.69-128.unk.tds.net
Message-ID: <41b9a8a7$1@forums-2-dub>
X-Original-Trace: 10 Dec 2004 05:46:15 -0800, h69-128-201-220.69-128.unk.tds.net
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 10 Dec 2004 05:46:16 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 10 Dec 2004 05:46:19 -0800
X-Trace: forums-1-dub 1102686379 10.22.108.75 (10 Dec 2004 05:46:19 -0800)
X-Original-Trace: 10 Dec 2004 05:46:19 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3961
Article PK: 7856

We are getting the message Resource Govenor for 'Prepared Statements'
exceeded after long sessions in our application. I assume this is because
one of the prepared statements is not being "unprepared". I have issued the
following statement to see the prepared statement count grow: "call
sa_conn_properties_by_conn('prepstmt')", but would like to know if there is
a way I can determine which statement is not being "unprepared".

Thank you in advance.

Mark Christy


Chris Keating (iAnywhere Solutions) Posted on 2004-12-10 14:49:57.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <Spam_NoThanks_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <41b9a8a7$1@forums-2-dub>
Subject: Re: Resource Govenor for 'Prepared Statements' exceeded help
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: keating-xp2.sybase.com
Message-ID: <41b9b790$1@forums-2-dub>
X-Original-Trace: 10 Dec 2004 06:49:52 -0800, keating-xp2.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 10 Dec 2004 06:49:53 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 10 Dec 2004 06:49:57 -0800
X-Trace: forums-1-dub 1102690197 10.22.108.75 (10 Dec 2004 06:49:57 -0800)
X-Original-Trace: 10 Dec 2004 06:49:57 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3963
Article PK: 7853

Please refrain from crossposting.

"Mark" <mchristy@tds.net> wrote in message news:41b9a8a7$1@forums-2-dub...
> We are getting the message Resource Govenor for 'Prepared Statements'
> exceeded after long sessions in our application. I assume this is
> because
> one of the prepared statements is not being "unprepared". I have issued
> the
> following statement to see the prepared statement count grow: "call
> sa_conn_properties_by_conn('prepstmt')", but would like to know if there
> is
> a way I can determine which statement is not being "unprepared".
>
> Thank you in advance.
>
> Mark Christy
>
>


Lorraine Ford Posted on 2005-01-07 18:05:25.0Z
Reply-To: "Lorraine Ford" <lford@ttisoftware.com>
From: "Lorraine Ford" <lford@ttisoftware.com>
Newsgroups: ianywhere.public.general
References: <41b9a8a7$1@forums-2-dub> <41b9b790$1@forums-2-dub>
Subject: Re: Resource Govenor for 'Prepared Statements' exceeded help
Lines: 32
Organization: Transportation Technologies Inc.
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4942.400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4942.400
NNTP-Posting-Host: h-69-3-43-2.phlapafg.covad.net
X-Original-NNTP-Posting-Host: h-69-3-43-2.phlapafg.covad.net
Message-ID: <41decf65$1@forums-1-dub>
Date: 7 Jan 2005 10:05:25 -0800
X-Trace: forums-1-dub 1105121125 69.3.43.2 (7 Jan 2005 10:05:25 -0800)
X-Original-Trace: 7 Jan 2005 10:05:25 -0800, h-69-3-43-2.phlapafg.covad.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4032
Article PK: 7923

Mark,
I can't tell if this was answered in another group, but when we had that
issue, it had to do with the database MAX_STATEMENT_COUNT and MAX_CURSOR_COUNT
being set to 50 by default. To remove the limit, go into ISQL on the database in
question, and set the options for these two options to 0 which will mean no
limit. This solved the problem for us.
Lorraine

"Chris Keating (iAnywhere Solutions)" <Spam_NoThanks_keating@iAnywhere.com>

wrote in message news:41b9b790$1@forums-2-dub...
> Please refrain from crossposting.
>
>
> "Mark" <mchristy@tds.net> wrote in message news:41b9a8a7$1@forums-2-dub...
> > We are getting the message Resource Govenor for 'Prepared Statements'
> > exceeded after long sessions in our application. I assume this is
> > because
> > one of the prepared statements is not being "unprepared". I have issued
> > the
> > following statement to see the prepared statement count grow: "call
> > sa_conn_properties_by_conn('prepstmt')", but would like to know if there
> > is
> > a way I can determine which statement is not being "unprepared".
> >
> > Thank you in advance.
> >
> > Mark Christy
> >
> >
>
>


John Smirnios Posted on 2005-01-10 15:26:25.0Z
From: John Smirnios <smirnios_at_sybase_dot_com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5b) Gecko/20030723 Thunderbird/0.1
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Resource Govenor for 'Prepared Statements' exceeded help
References: <41b9a8a7$1@forums-2-dub> <41b9b790$1@forums-2-dub> <41decf65$1@forums-1-dub>
In-Reply-To: <41decf65$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: smirnios-pc.sybase.com
X-Original-NNTP-Posting-Host: smirnios-pc.sybase.com
Message-ID: <41e29ea1$1@forums-1-dub>
Date: 10 Jan 2005 07:26:25 -0800
X-Trace: forums-1-dub 1105370785 10.25.107.220 (10 Jan 2005 07:26:25 -0800)
X-Original-Trace: 10 Jan 2005 07:26:25 -0800, smirnios-pc.sybase.com
Lines: 53
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4038
Article PK: 7925

Usually the resource governor limits are hit because you have a
statement or cursor leak in the application and not because you need
more than 50 statements or cursors prepared on one connection at a time.
Disabling the governor means that your application may be causing an
unbounded memory leak in the server's cache.

-john.

Lorraine Ford wrote:
> Mark,
> I can't tell if this was answered in another group, but when we had that
> issue, it had to do with the database MAX_STATEMENT_COUNT and MAX_CURSOR_COUNT
> being set to 50 by default. To remove the limit, go into ISQL on the database in
> question, and set the options for these two options to 0 which will mean no
> limit. This solved the problem for us.
> Lorraine
>
> "Chris Keating (iAnywhere Solutions)" <Spam_NoThanks_keating@iAnywhere.com>
> wrote in message news:41b9b790$1@forums-2-dub...
>
>>Please refrain from crossposting.
>>
>>
>>"Mark" <mchristy@tds.net> wrote in message news:41b9a8a7$1@forums-2-dub...
>>
>>>We are getting the message Resource Govenor for 'Prepared Statements'
>>>exceeded after long sessions in our application. I assume this is
>>>because
>>>one of the prepared statements is not being "unprepared". I have issued
>>>the
>>>following statement to see the prepared statement count grow: "call
>>>sa_conn_properties_by_conn('prepstmt')", but would like to know if there
>>>is
>>>a way I can determine which statement is not being "unprepared".
>>>
>>>Thank you in advance.
>>>
>>>Mark Christy
>>>
>>>
>>
>>
>

--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer