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.049     0.000    0.009   |   |
| +----------------------------------------------------------------------+   |
|                                                                            |
| Calculation Details                                                        |
|    CICS Transaction                 DNC1                                   |
|    The quantities shown represent the service time for execution of the    |
|    indicated CICS command while processing this transaction. The           |
|    quantities are total times for all executions of the command within     |
|    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                |
|                                                                            |
| 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 ---------------+   |
| |   → +6E9c    SELECT                       1.189     0.000    0.129   |   |
| +----------------------------------------------------------------------+   |
|                                                                            |
| Calculation Details                                                        |
|    CICS Transaction                 DNC1                                   |
|    The quantities shown represent the service time for execution of the    |
|    indicated DB2 SQL call while processing this transaction. The           |
|    quantities are total times for all executions of the command within     |
|    the transaction and are calculated as follows:                          |
|                                                                            |
|      (1) Times SQL call observed in txn/program    132                     |
|      (2) Duration of one sample interval           0.009999                |
|      (3) (1) x (2) = total time for SQL call       1.319868                |
|                                                                            |
| SQL Statement Information                                                  |
|    DBRM name        PFSAMPC                                                |
|    DBRM Token       17652081 1C3E933C                                      |
|    Precmplr stmt#   3179                                                   |
|    SQL Call Module  PFSAMPC                                                |
|    SQL Call CSECT   PFSAMPC                                                |
|    SQL Call Offset  00006E9C                                               |
|    SQL Function     SELECT                                                 |
|    Subsystem name   DSN1                                                   |
|    Connection Type  SASS                                                   |
|    Package/Plan:                                                           |
|      Location       CABNETDB21                                             |
|      Collectn Name  PFSAMPC6                                               |
|      Package ID     PFSAMPC                                                |
|      Plan Name      PFSAMPA                                                |
|                                                                            |
|    SQL Req Count:   105                                                    |
|                                                                            |
|    SQL Statement:                                                          |
|                     SELECT *                                               |
|                     INTO : H ,                                             |
|                     : H  : H ,                                             |
|                     : H  : H                                               |
|                     FROM DEP                                               |
|                     WHERE XRATE = : H                                      |
|                                                                            |
|                                                                            |
+----------------------------------------------------------------------------+