|
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://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_suppo
rt_knowledgecenter_ssw-5Fibm-5Fi-5F73_&d=DwICAg&c=TRM22a2q2ENZDxdZ_Nz-
0OCGEspXTWPuaB6Jil0RfKE&r=o-YzpsmRCPgZlWO4EB4wsOj50O0KPLUTK9BP-UzK-UQ&
m=RM5SX1Lsv-hEkHhSgKD3A4GDiu-ANGXhUXR7RkshotU&s=SIVmqAjhspo8PHdlqAe4pV
MifOqyuaxsIkSN6VroBgc&e=
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
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.dekko.com&d=Dw
ICAg&c=TRM22a2q2ENZDxdZ_Nz-0OCGEspXTWPuaB6Jil0RfKE&r=o-YzpsmRCPgZlWO4E
B4wsOj50O0KPLUTK9BP-UzK-UQ&m=RM5SX1Lsv-hEkHhSgKD3A4GDiu-ANGXhUXR7Rksho
tU&s=Td2YZ9tRbi5omSE1-sbxC4Fbshy26U7OR7XEqBiITns&e=
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://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.co
m_mailman_listinfo_midrange-2Dl&d=DwICAg&c=TRM22a2q2ENZDxdZ_Nz-0OCGEsp
XTWPuaB6Jil0RfKE&r=o-YzpsmRCPgZlWO4EB4wsOj50O0KPLUTK9BP-UzK-UQ&m=RM5SX
1Lsv-hEkHhSgKD3A4GDiu-ANGXhUXR7RkshotU&s=WBe-0ygRphys4bPy3m4uQpq0rJiEn
u6EBdbIsqGYuO0&e= or email: MIDRANGE-L-request@xxxxxxxxxxxx Before
posting, please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=TRM22a2q2ENZDxdZ_Nz-0OCGEspXTWPuaB6Jil0RfKE&r=o-YzpsmRCPgZlWO4EB4wsOj50O0KPLUTK9BP-UzK-UQ&m=RM5SX1Lsv-hEkHhSgKD3A4GDiu-ANGXhUXR7RkshotU&s=dZbiBFRrfzc7iQm0hfAe3aLJ-A1G2DLP1JXirwpWMJg&e= .
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=
DwICAg&c=TRM22a2q2ENZDxdZ_Nz-0OCGEspXTWPuaB6Jil0RfKE&r=o-YzpsmRCPgZlWO
4EB4wsOj50O0KPLUTK9BP-UzK-UQ&m=RM5SX1Lsv-hEkHhSgKD3A4GDiu-ANGXhUXR7Rks
hotU&s=d8UVX_1pKcLMEDlOYnMqp8tSFwRLy4aKh68EJ9gtknI&e=
--
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://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.co
m_mailman_listinfo_midrange-2Dl&d=DwICAg&c=TRM22a2q2ENZDxdZ_Nz-0OCGEsp
XTWPuaB6Jil0RfKE&r=o-YzpsmRCPgZlWO4EB4wsOj50O0KPLUTK9BP-UzK-UQ&m=RM5SX
1Lsv-hEkHhSgKD3A4GDiu-ANGXhUXR7RkshotU&s=WBe-0ygRphys4bPy3m4uQpq0rJiEn
u6EBdbIsqGYuO0&e= or email: MIDRANGE-L-request@xxxxxxxxxxxx Before
posting, please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=TRM22a2q2ENZDxdZ_Nz-0OCGEspXTWPuaB6Jil0RfKE&r=o-YzpsmRCPgZlWO4EB4wsOj50O0KPLUTK9BP-UzK-UQ&m=RM5SX1Lsv-hEkHhSgKD3A4GDiu-ANGXhUXR7RkshotU&s=dZbiBFRrfzc7iQm0hfAe3aLJ-A1G2DLP1JXirwpWMJg&e= .
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=
DwICAg&c=TRM22a2q2ENZDxdZ_Nz-0OCGEspXTWPuaB6Jil0RfKE&r=o-YzpsmRCPgZlWO
4EB4wsOj50O0KPLUTK9BP-UzK-UQ&m=RM5SX1Lsv-hEkHhSgKD3A4GDiu-ANGXhUXR7Rks
hotU&s=d8UVX_1pKcLMEDlOYnMqp8tSFwRLy4aKh68EJ9gtknI&e=
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
