RE: ILE, Activation groups, and files staying open.

Thanks Gerald. Been collecting useful statements like this up for when I need them.

John

<snip>
sorry, that was my latest iteration of the SQL, this is what I found in examples in run sql scripts:

select activation_group, count(*) as activation_group_name_count
from qsys2.program_info
where program_library = 'xxxxxxxx'
and program_type = 'ILE'
group by activation_group
order by 2 desc;

On Wed, Jun 2, 2021 at 4:57 PM Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx>
wrote:

select Program_library, program_name, program_type,
create_timestamp, activation_group, shared_activation_group,
last_used_timestamp, days_used_count, created_system_version
from qsys2.program_info as a
join TABLE (QSYS2.OBJECT_STATISTICS('PROGRAMLIB', '*PGM') ) as b on
a.program_name = b.OBJNAME
where program_library = 'PROGRAMLIB'
order by activation_group, last_used_timestamp DESC;

</snip>