Re: Open files after programs ending

Hello,

The BMR for this is 64543 and it was passed today. This applies to V8.0
Mixed Mode only.

Thanks,

Genyphyr Novak
SSA GT

----- Original Message -----
From: "Genyphyr Novak" <novakg@xxxxxxxx>
To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
Sent: Monday, April 07, 2003 9:29 AM
Subject: Re: Open files after programs ending


> Hi Bud,
>
> I tried to respond to this a couple of weeks ago, but this and about 5
other
> postings I sent never made it into the list for some reason. I may try to
> resend some of those.
>
> This is a V8.0 only issue. There is a BMR for this - I will try to repost
> with the BMR number, but since everyone has the source for the program and
> it's incredibly easy to fix, there isn't much reason to order it.
> The simple answer is on V8.0 (not 8.1 or 8.2 or any other BPCS release)
just
> add the statement 'RCLACTGRP BPCS' to the end of the CL program BPCSMENU
so
> that this statement is executed when leaving BPCS. (The activation group
> name is 'BPCS'.)
>
> We are using a named activation group in V8.0 and unfortunately this does
> not behave as other activation groups do, in that when the program that
> started the activation group ends, the activation group stays alive, hence
> the extra open files when switching between BPCS environments on Green
> Screen (not an issue in Client/Server). V8.1 and V8.2 use a system named
> activation group, via the *NEW option upon entrance to BPCS, so this
doesn't
> affect those releases.
>
> I don't recommend changing compile options, or you will lose performance.
>
> Thanks,
>
> Genyphyr Novak
> SSA GT
> ----- Original Message -----
> From: "Bud North" <bnorth@xxxxxxxxxxxxxxxx>
> To: <bpcs-l@xxxxxxxxxxxx>
> Sent: Friday, April 04, 2003 8:03 AM
> Subject: Re: Open files after programs ending
>
> >
> > Today's Topics:
> >
> >    1. Re: Open files after programs ending (Frank.Kolmann@xxxxxxxxxx)
> >
> >
> > ----------------------------------------------------------------------
> >
> > message: 1
> > date: Thu, 27 Mar 2003 10:11:11 +1000
> > from: Frank.Kolmann@xxxxxxxxxx
> > subject: Re: Open files after programs ending
> >
> > I searched the BPCS archives and found an old post I put up
> > with some selected replies.  What I want to know is can I
> > safely compile AS/SET programs using the CLOSQLCSR(*ENDMOD)
> > parameter on the compile.
> >
> > ========================================================
> > MORE DETAIL FOLLOWS
> >
> > We recently upgraded BPCS from 6.0.04G to 6.1.02.
> > We also upgraded AS/SET to V8. We had some minor issues with
> > AS/SET using the V6 repository but in the end it works OK.
> > The V8 version of AS/SET creates ILE programs and some of the
> > issues we had with modifying large AS/SET programs have been
> > addressed.
> >
> > I am getting more problems than ever with things going wrong
> > due to files being left open.
> >
> > The issue I am presently having is the requirement to use
> > CLOSQLCSR(*ENDACTGRP) on the AS/SET compiles.  It is all well
> > and good to leave files open with the goal (hope?) that
> > performance will improve on subsequent reuses of the opens,but
> >
> > There are however 2 MAJOR CASES where the reuse fails.
> >
> > 1.  Where a progam is closed and an OVRDBF is issued to
> >     open the file in a different library then the when program
> >     is called again the previous open is used and
> >     you get the wrong file.
> > 2.  Where the program is closed, then the library list is changed
> >     and the program is called again, if the previous open is
> >     reused again you have the wrong file.
> >
> > This I believe is really an AS400/OS400 issue caused by the
> > reuse logic NOT detecting that the object is needed from
> > a DIFFERENT library.
> >
> > If Activation Groups were used as designed then closing the
> > AG will close the 'useless' open files, but BPCS does not use
> > AGs.
> >
> > I simply want to know can I use CLOSQLCSR(*ENDMOD) on the BPCS
> > programs.  I see no reason why not, but I want to avoid jeopardising
> > our Production system simply because I recompiled programs.
> >
> > I tried to get this info from OGS without any success.
> >
> > Regards
> > Frank Kolmann
> >
> > PS. I am old enough to be aware to close files properly etc etc
> >     I dont need instruction on proper coding techniques.
> >     The issue I have is the OS is keeping files open.
>
>