RE: Re: Call Stack in WRKJOB -- MIDRANGE-L

Just a guess, but I would do a DSPPGM to see if the
program object is "observable" and also look to see
if it has been "compressed" for runtime...

Terry

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vinay Gavankar
Sent: Wednesday, October 04, 2017 12:54 PM
To: Midrange Systems Technical Discussion
Subject: [EXTERNAL] 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_sup
po
rt_knowledgecenter_ssw-5Fibm-5Fi-5F73_&d=DwICAg&c=TRM22a2q2ENZDxdZ_N
z-
0OCGEspXTWPuaB6Jil0RfKE&r=o-YzpsmRCPgZlWO4EB4wsOj50O0KPLUTK9BP-UzK-U
Q&
m=RM5SX1Lsv-hEkHhSgKD3A4GDiu-ANGXhUXR7RkshotU&s=SIVmqAjhspo8PHdlqAe4
pV
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-YzpsmRCPgZlWO
4E
B4wsOj50O0KPLUTK9BP-UzK-UQ&m=RM5SX1Lsv-hEkHhSgKD3A4GDiu-ANGXhUXR7Rks
ho 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-0OCGE
sp
XTWPuaB6Jil0RfKE&r=o-YzpsmRCPgZlWO4EB4wsOj50O0KPLUTK9BP-UzK-UQ&m=RM5
SX
1Lsv-hEkHhSgKD3A4GDiu-ANGXhUXR7RkshotU&s=WBe-0ygRphys4bPy3m4uQpq0rJi
En 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-YzpsmRCPgZl
WO
4EB4wsOj50O0KPLUTK9BP-UzK-UQ&m=RM5SX1Lsv-hEkHhSgKD3A4GDiu-ANGXhUXR7R
ks 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-0OCGE
sp
XTWPuaB6Jil0RfKE&r=o-YzpsmRCPgZlWO4EB4wsOj50O0KPLUTK9BP-UzK-UQ&m=RM5
SX
1Lsv-hEkHhSgKD3A4GDiu-ANGXhUXR7RkshotU&s=WBe-0ygRphys4bPy3m4uQpq0rJi
En 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-YzpsmRCPgZl
WO
4EB4wsOj50O0KPLUTK9BP-UzK-UQ&m=RM5SX1Lsv-hEkHhSgKD3A4GDiu-ANGXhUXR7R
ks 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

--
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

----------------------------------------------------------------------
Confidentiality Notice: The preceding e-mail message (including any attachments) contains information that may be confidential, protected by applicable legal privileges, or constitute non-public information. It is intended to be conveyed only to the designated recipient(s). If you are not an intended recipient of this message, please notify the sender by replying to this message and then delete it from your system. Use, dissemination, distribution or reproduction of this message by unintended recipients is not authorized and may be unlawful.