View previous topic :: View next topic
|
Author |
Message |
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
Hi,
We have a CICS-DB2 transaction that ran for 40 seconds and we are trying to determine where that 40 seconds was spent.
The transaction started on say 11:00:00 sharp it ended at 11:00:40, The CICS transaction made a DB2 call at 11:00:01 and the DB2 thread completed at 11:00:02. So we are trying to determine what was happening from 11:00:02 till 11:00:40. We have DB2 datasharing in place.
Mainview monitor for CICS and CICS SMF records show that approximately 39 seconds was spent on
RMIDBCTM - RMIDBCTL*DURATION*IN DFHRMI - 39 seconds
WTSYIOTM - SYNCPOINT*IO WAIT TIME - 39 seconds.
I am not sure what is causing these high values in SYNCPOINT. Could you please let me know where to look for the problem from here.
I was thinking to look at Coupling facility next.
Thanks & Regards, |
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
Also
USER-TASK*KEY 8*TCB DISPATCH*TIME is 39 seconds |
|
Back to top |
|
|
meykh2014
New User
Joined: 03 Jul 2014 Posts: 34 Location: munich
|
|
|
|
did you try CEDX for trace transaction running flow? |
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
Hi meykh2014,
This issue happened only during a specific interval and did not happen again. So we were unable to reproduce the same delayed response time for the transaction. |
|
Back to top |
|
|
Mark Williams
New User
Joined: 17 Jul 2018 Posts: 1 Location: USA
|
|
|
|
Any update on this issue? I'm having the same slow response on CICS/DB2 transactions. |
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
Hi Mark,
I don't remember exactly what the issue was as it was more than a year ago.
I think this was not mainframe related. I don't really remember. |
|
Back to top |
|
|
|