Re: Why are files opened in *DFTACTGRP?

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?