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