DSNECP10
Jim Lewandowski
does the CPU histogram look like then (i.e. tight loop or CPU spread
throughout the CSECT)? What does STROBE have as the description of the
DSN module/CSECTs? I've STROBEd a lot of CICS but not much batch so I
can't say for sure whether I ever. Normally, you see lots of CPU in DB2
INDEX Scan, etc. etc. etc.
Guido Jacobs wrote:
>
> Hi there,
>
> in my DB2-shop we have a long running batch application with about 3 hours
> of DB2-CPU time. We analyzed the running application with Strobe for 20
> minutes with the result, that 37% of CPU-time was consumed by the Module
> DSNECP10 in Section DSNAPRH. As I understand, this module handles the
> interface between the application and DB2, when the DSN command, which is
> alias of DSNECP00, is executed. I don't have much experience with Strobe,
> but I've never seen such a CPU-consumption in this module.
> Who can explain it?
>
> Guido
Venkat R. Pillay
It looks very unlikely that DSN attach will consume 37% of CPU (TOTAL
CPU ?? - 67 sec out of 180 cpu sec).
Now the question is 37% of what ?? Its really long time so I don't
remember now how STROBE calculates those percentage. I think It should be
worth finding out from STROBE manuals or from STROBE support.
It might be that 37% of total CPU used by only DSNAPRH !!!!!
Check the total CPU usage summary at the end of report, might give you more
clear understanding.
Regards
Pillay
-------------
Original Text
From: "Guido Jacobs" <duerr_...@WESTLB.DE>, on 7/23/98 12:52 PM:
James Chie
against the SQL statements. I would think you might be calling DB2 a lot
more times than you should )or perhaps expect). i.e. bad SQL
Guido Jacobs
I know exactly from Strobe and monitor, which SQL-Statements need most of
CPU.
But in my understanding DSNECP10 is only used for the connect from TSO one
time, the SQL calls are made by DSNHLI, isn't it?
Guido Jacobs