Re: Call Stack in WRKJOB

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