Re: Call Stack in WRKJOB

The PGMA and PGMB are both compiled with exactly the same options :
*srcstmt & *nodebugio, yet the PGMA shows the Statement number and PGMB
does not.

There are very few commands I can do on the production system, and using
TRCJOB or any other QAATOOL commands is not possible.

On Tue, Oct 3, 2017 at 9:33 AM, Bak, Doug (LMF) <Doug.Bak@xxxxxxxxxxxxxx>
wrote:

I pressed Help on the Statement field.. this may be applicable.

Statement - Help

The high-level language statement
identifier, machine instruction number, or offset.

The statement identifier may be
omitted if the program has no debugging tables.


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Vinay Gavankar
Sent: Tuesday, October 03, 2017 9:26 AM
To: Midrange Systems Technical Discussion
Subject: [EXTERNAL] Re: Call Stack in WRKJOB

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://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-YzpsmRCPgZlWO4EB4wsOj50O0KPLUT
K9BP-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-YzpsmRCPgZlWO4EB4wsOj50O0KPLUT
K9BP-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.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=TRM22a2q2ENZDxdZ_Nz-
0OCGEspXTWPuaB6Jil0RfKE&r=o-YzpsmRCPgZlWO4EB4wsOj50O0KPLUT
K9BP-UzK-UQ&m=RM5SX1Lsv-hEkHhSgKD3A4GDiu-ANGXhUXR7RkshotU&s=WBe-
0ygRphys4bPy3m4uQpq0rJiEnu6EBdbIsqGYuO0&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-
YzpsmRCPgZlWO4EB4wsOj50O0KPLUTK9BP-UzK-UQ&m=RM5SX1Lsv-hEkHhSgKD3A4GDiu-
ANGXhUXR7RkshotU&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://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