Detail window
You can enter “++” (or press the enter key) on any line to open a window containing additional information.
A sample detail window for a CICS® command report is shown here:
File View Navigate Help
+----------------------------------------------------------------------------+
| |
| +--------------- The following report line was selected ---------------+ |
| | → +118E RETURN TRANSID(DNC1) 0.000 0.000 0.000 | |
| +----------------------------------------------------------------------+ |
| |
| Calculation Details |
| CICS Transaction |
| The quantities shown represent the service time for execution |
| of the indicated CICS command while processing transaction DNC1. |
| The quantities are mean times for the command for all executions |
| of the transaction and are calculated as follows: |
| |
| (1) Times command observed in txn/program 6 |
| (2) Duration of one sample interval 0.009999 |
| (3) (1) × (2) = total time for transaction 0.059994 |
| (4) NUmber of executions of transaction 327 |
| (5) (3) ÷ (4) = mean time for the command 0.000183 |
| |
| Command Attributes |
| CICS Command EXEC CICS RETURN TRANSID(DNC1) |
| Issued in Load Module PFSAMPA |
| Return offset in Module +11AE |
| Name of CSECT PFSAMPA |
| Return of Offset in CSECT +118E |
| |
| The command execution measurement counts are |
| Executing (CPU active) 5 |
| Suspended by CICS 0 |
| Delayed |
| CICS dispatch delay 0 |
| MVS delay (WAIT) 0 |
| MVS delay (Busy) 1 |
| |
+----------------------------------------------------------------------------+A sample detail window for an SQL command is shown here:
File View Navigate Help
+----------------------------------------------------------------------------+
| |
| +--------------- The following report line was selected ---------------+ |
| | → +85D8 SELECT 0.001 0.000 0.000 | |
| +----------------------------------------------------------------------+ |
| |
| Calculation Details |
| The quantities shown represent the service time for execution |
| of the indicated DB2 SQL call while processing transaction DNC1. |
| The quantities are mean times for the SQL call for all executions |
| of the transaction and are calculated as follows: |
| |
| (1) Times SQL call observed in txn/program 93 |
| (2) Duration of one sample interval 0.006003 |
| (3) (1) x (2) = total time for SQL call 0.558279 |
| (4) Number of executions of transaction 342 |
| (5) (3) ÷ (4) = mean time for the SQL call 0.001632 |
| |
| SQL Statement Information |
| Subsystem name DSN1 Attach type SASS |
| Plan name PFSAMPA Plan BIND time Nov-28-04 14:11:17 |
| |
| DBRM name PFSAMPC DBRM token 17859595 06957A24 |
| DBRM date/time Nov-25-04 14:49:42 |
| |
| Package ID PFSAMPC Location CABNETDB24 |
| Collectn name PFSAMPX1 Pkg BIND time no data |
| |
| SQL function SELECT Static/dynamic Static |
| Precmplr stmt# 3179 DBRM section# 21 |
| CSECT/module PFSAMPC in PFSAMPC Offset of call 000085D8 |
| Sample count 93 SQL req count 172 |
| SQL CPU time 0.28 Service time 0.54 |
| |
| SQL Statement SELECT * INTO : H , : H , : H : H , : H FROM DEPT |
| WHERE XRATE = : H |
| |
| |
+----------------------------------------------------------------------------+