Need Help- IDS 11.5 Stored procedures.
After upgrading from IDS 10 to IDS 11.50.FC6, the poster found that stored procedures using recursive/nested calls no longer released virtual shared memory (visible as growing blkused in onstat -g seg). Art Kagel suggested recompiling all procedures with UPDATE STATISTICS FOR PROCEDURE/FUNCTION while PDQPRIORITY was 0, since procedures compiled under a positive PDQPRIORITY can hold memory. The poster tried this and the leak persisted, so Art advised opening a PMR with IBM, as it may be a bug fixed in a later patch level. No resolution is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
After migration from IDS 10. to IDS 11.5, It observed that the stored
procedure with recursive/nested stored procedure calls working fine on IDS 10,
is not releasing the memory on new Informix Engine IDS 11.5. Could you please
help to resolve the issue. I am monitoring the onstat -g seg output, where
blkused of virtual shared memory is increased when stored procedure with
recursive/nested calls executed. What is the solution for this issue?
regards
Mahesh
Hello.
Just some questions, how is your client connecting???
CSDK?? What version??? Via oledb, odbc, jdbc???
What is your Informix architecture?
That should clarify our thoughts.... kkkkk
Best regards.
Em 17/11/2010 09:13, MAHESH ASODEKAR escreveu:
> Hi,
>
> After migration from IDS 10. to IDS 11.5, It observed that the stored
> procedure with recursive/nested stored procedure calls working fine on IDS
10,
> is not releasing the memory on new Informix Engine IDS 11.5. Could you please
> help to resolve the issue. I am monitoring the onstat -g seg output, where
> blkused of virtual shared memory is increased when stored procedure with
> recursive/nested calls executed. What is the solution for this issue?
>
> regards
> Mahesh
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Alexandre Marini
Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix
Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg>
IBM Informix Dynamic Server Certified Professional V10 / V11
Thanks for reply.. If we execute the stored procedure with recursive calls in sql script also we can see this issue. BTW we are using jdbc to connect the CSDK version is 3.50. regards Mahesh
First, what patch level release of 11.50 are you using? What platform?
Next: as part of the upgrade you should have recompiled all of your stored
procedures using UPDATE STATISTICS FOR PROCEDURE/FUNCTION.... Did you?
When you did, you should have done so making sure that PDQPRIORITY was set
to zero. If PDQPRIORITY was set to a positive number, then the procedures
are now running with the PDQPRIORITY they were compiled with and the session
running them can hold memory.
Finally, it COULD be a bug. Have you tried opening a PMR case with IBM?
Perhaps the problem is fixed in a later patch level release.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Wed, Nov 17, 2010 at 8:13 AM, MAHESH ASODEKAR
<aasodekarmahesh@gmail.com>wrote:
> Hi,
>
> After migration from IDS 10. to IDS 11.5, It observed that the stored
> procedure with recursive/nested stored procedure calls working fine on IDS
> 10,
> is not releasing the memory on new Informix Engine IDS 11.5. Could you
> please
> help to resolve the issue. I am monitoring the onstat -g seg output, where
> blkused of virtual shared memory is increased when stored procedure with
> recursive/nested calls executed. What is the solution for this issue?
>
> regards
> Mahesh
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0016e642d8bc80ac55049540765b
Hi, The IDS version IDS 11.50.FC6. I tried setting PDQPRIORITY to 0 and compile the store procedure. But problem still exists. regards Mahesh
Time to open a case with IBM. This may already be fixed in 11.50.xC7, or the fix may be scheduled for release with .xC8 (which is due out in January IB) and they can get you a patch release of .xC6 or .xC7 with that one fix to tide you over until .xC8 passes GA and is released. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Nov 18, 2010 at 6:53 AM, MAHESH ASODEKAR <aasodekarmahesh@gmail.com>wrote: > Hi, > > The IDS version IDS 11.50.FC6. I tried setting PDQPRIORITY to 0 and compile > the store procedure. But problem still exists. > > regards > Mahesh > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf30433f2a40df95049552de8b
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g