Re: Call Stack in WRKJOB

[Vinay Gavankar <vinaygav@xxxxxxxxx>]

So I guess no one has any idea what it means when the Program in the jobs's
call stack has no Statement number against it.

On Mon, Oct 2, 2017 at 12:22 PM, Rob Berendt <rob@xxxxxxxxx> wrote:

> Most of the time when reviewing batch jobs which seem to take an
> inordinate amount of time the goal is to reduce I/O's.
> My best example was a developer who coded this
>
> Clear summary file;
> Read detail file
>   Try to update row in summary file, if update fails try write
> next
>
> Extreme numbers of I/O to summary file.  Changed to
>
> Read detail file in order of desired summary rows;
>   sum total in memory
>   at control break time write out the total to summary file
>
> Shaved off an hour.
>
> In your case you could look at a number of things.
> TRCJOB for one.
>
> Another thing to look at is
> select system_table_schema, system_table, system_table_member,
> open_operations, close_operations, insert_operations, update_operations,
> delete_operations,
> ...
> from qsys2.syspartitionstat
> where system_table in ('FROMFILE', 'TOFILE')
> https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/
> db2/rbafzcatsyspstat.htm
> Run that before and after the batch job.
>
>
> 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
>
>
>
>
>
> From:   Vinay Gavankar <vinaygav@xxxxxxxxx>
> To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Date:   10/02/2017 11:34 AM
> Subject:        Call Stack in WRKJOB
> Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
>
>
>
> Hi,
>
> We have a monthly batch job which is being looked at to make it more
> efficient. I don't have easy access to Performance Tools on production
> system, so was trying to use very unscientific (but which I have found to
> be very useful) method of looking at the Call Stack hitting F5 frequently.
>
> Usually I find statements which show up more often than others, telling me
> where the job is spending more time.
>
> In this job, I did find that about 50% of the time it is PGMA at the
> statement calling PGMB, but for PGMB in the call stack, the Statement
> column is blank. I never saw any Statement number under PGMB.
>
> Any ideas about why this should be the case?
>
> PGMB is not setting on LR when returning and the number of Open Data Paths
> (when looking at Open FIles) does not change in the job.
>
> TIA
> Vinay
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> 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: http://amzn.to/2dEadiD
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> 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: http://amzn.to/2dEadiD