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

[John Rusling <JRusling@xxxxxxxxxxx>]

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>