Re: Homegrown QINACTITV

[Bryan Dietz <bdietz400@xxxxxxxxx>]

The one I wrote utilized the Inactivity timer system value.  I had the messages sent to a message queue that was monitored by a never-ending-program.
That program makes decision on whose job to end.
Its not perfect as the messages are sent based on when the SBS started. And not actual clock time for inactivity.


Bryan


> On Mar 29, 2019, at 8:19 AM, Rob Berendt <rob@xxxxxxxxx> wrote:
>
> Let's say you're not ready to take the leap on QINACTITV.  Is there anything in the following which will tell you how long it has been sitting in DSPW?
> Select
> JOB_NAME,
> AUTHORIZATION_NAME,
> job_active_time, a.*
> from table(qsys2.active_job_info(
> RESET_STATISTICS => 'NO',
> SUBSYSTEM_LIST_FILTER => 'QINTER' ,
> JOB_NAME_FILTER => '*ALL',
> CURRENT_USER_LIST_FILTER => '',
> DETAILED_INFO => 'ALL'
> )) A
> where job_type<>'SBS'
> and job_status='DSPW'
> ORDER BY JOB_ACTIVE_TIME
> ;
> https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/QSYS2.ACTIVE_JOB_INFO%28%29%20-%20UDTF
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>          Garrett, IN 46738
> Ship to:  Dock 108
>          6928N 400E
>          Kendallville, IN 46755
> http://www.dekko.com
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com