RE: Embeded SQL ODP problem

["Haas, Matt" <Matt.Haas@xxxxxxxxxxx>]

Have you tried running the job in debug mode to get more information from the 
query optimizer? It may tell you why it's not deleting the ODP.

Matt

-----Original Message-----
From: Schadd D Gray [mailto:list@xxxxxxxxxxxxx]
Sent: Tuesday, December 16, 2003 2:09 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Embeded SQL ODP problem


It is a named activation group (QILE).  I did not want to encure the
activation group startup and shutdown, as it would hinder web performance.
>From what I have read, I thought CLOSQLCSR(*ENDMOD) meant that the cursor
and all ODP's are deleted when the program ends.  I guess my question should
have been, why is this not the case here?

Thanks,
Schadd Gray
Damon Technologies, Inc.
www.damontech.com

----- Original Message ----- 
From: "DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>
To: "'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, December 16, 2003 12:51 PM
Subject: RE: Embeded SQL ODP problem


> Schadd,
>
> I'll bet your program is running in a named activation group that has not
> yet been reclaimed.  You'll need to RCLACTGRP to close out the existing
copy
> of your program.
>
> One easy fix (probably not the best way) is to recompile the program to
> ACTGRP(*NEW), which should ensure that the activation group is destroyed
> whenever the program ends.  Note that there is some overhead associated
with
> creating a new activation group, but I wouldn't expect it to be a problem
in
> most cases.
>
> Eric DeLong
> Sally Beauty Company
> MIS-Project Manager (BSG)
> 940-898-7863 or ext. 1863
>
>
>
> -----Original Message-----
> From: Schadd D Gray [mailto:list@xxxxxxxxxxxxx]
> Sent: Tuesday, December 16, 2003 12:38 PM
> To: RPG programming on the AS400 / iSeries
> Subject: Embeded SQL ODP problem
>
>
> I have a SQLRPGLE with a select statement in it.  I have compiled this
> program with CLOSQLCSR(*ENDMOD).  However, after the program finishes I
look
> at the Open Data Paths for my job and the files in the SELECT statement
are
> still open.  I close the cursor prior to exiting the program.
>
> I put the program in debug and my joblog shows the message SQL7914 "ODP
not
> deleted".
>
> The main place this is causing me issue is in JDBC calls to these SQLRPGLE
> programs, which are registered as stored procedures.  The system jobs for
> JDBC end up having 300+ ODP's.
>
> Is there a way to ensure the ODP's are deleted?
>
> By the way, this is a hard coded SELECT statement (Not a prepared
> statement).
>
> OS - V5R2
>
> Thanks,
> Schadd Gray
> Damon Technologies, Inc.
> www.damontech.com
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.