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