Re: Why are files opened in *DFTACTGRP?

[CRPence <CRPbottle@xxxxxxxxx>]

  I can not explain why, but I will suggest why that effect should not 
matter to the query.  The first file [often called the primary file] of 
a query ODP is the /name/ of the query ODP.  That ODP is properly scoped 
to the activation group; i.e. the name POSMVEP in library QS36F is 
identified as the open file member.  The UNION query must open the other 
files in the query.  All of the other files [tracked to the ODP] are 
closed by the Query feature when the query ODP is closed, whether they 
were opened for physical row data or only for their access path.

  Even so, I do not specifically recall that effect; though I also do 
not recall that the other files should be [shown] scoped the same as the 
primary.  And while that effect alone is of no consequence to the query 
for normal activity...

  I might verify after ensuring that the ODP was pseudo-closed, that a 
RCLRSC issued in the default activation group has no effect on those 
open files.  I might also verify after ensuring that the ODP was 
pseudo-closed, that a RCLACTGRP of a named activation group has no 
effect on those other open files if the SQL query program had been run 
in that named activation group; i.e. assuming these other opens were 
scoped to the named instead of the default activation group.  If in 
either case the other files are closed, the issue would seem to be a 
problem, and would presumably be exposed by the effects from a re-use.

Regards, Chuck

On 10 Jan 2013 12:52, Robert Rogerson wrote:
> I'm a little stumped here. I'm debugging a program and when I look at
> the job's open files (14. Display open files, if active) there are
> files being opened in the *DFTACTGRP.
>
> I'm calling an SQLRPGLE program and the program's Activation Group
> Attribute is QILE. So my understanding is that files which are
> opened will be in the QILE activation group (there are no OVRDBF
> in the job stream and in fact only this program is called from the
> command line)
>
> <<SNIP>>  But when I execute the following SQL statement
>
>     Exec SQL
>       SELECT <<SNIP>>
>         FROM ( SELECT MIN(veendt) AS FirstDate
>                FROM posmvep <<SNIP>
>               UNION ALL
>                SELECT MIN(dhindt) AS FirstDate
>                FROM dsthstp <<SNIP>>
>               UNION ALL
>                SELECT DateToDecimalDate(MIN(rodate)) AS FirstDate
>                FROM roshstp <<SNIP>>
>              ) AS a;
>
>     the open files are
>     File       Library    Device     Scope      Activation Group
>      <<SNIP>>
>     POSMVEP    QS36F      POSMVEP    *ACTGRPDFN QILE       0000000013
>     DSTHSTP    QS36F      DSTHSTP    *ACTGRPDFN *DFTACTGRP 0000000002
>     ROSHSTP    TESTAM247  ROSHSTP    *ACTGRPDFN *DFTACTGRP 0000000002
>     POSMVEL11  QS36F      POSMVEL11  *ACTGRPDFN *DFTACTGRP 0000000002
>     DSTPALU1   QS36F      DSTPALU1   *ACTGRPDFN *DFTACTGRP 0000000002
>      <<SNIP>>
>
> I checked (15. Display file overrides, if active) and there are no
> overrides.
>
> Can someone explain why these new files show the *DFTACTGRP?