Using the Product in a CICS Environment › Analyze CICS Data

Analyze CICS Data

To analyze CICS data to the SQL statement level, use the following steps to display the SQL statements for a CICS job:

1. Set up your monitoring criteria so that the Observations Requested field contains a number in the range of 3000 to 10000.

   See the chapter"Setting up a monitor definition" for more information about specifying monitoring criteria.

2. Invoke the monitor using the Invoke line command (I).
3. Analyze the data by using one of the analysis line commands (A, AL, AA, or AW).
4. From the Interactive Analysis menu, select Option 6.

   The TranView panel displays.

    CA MAT --------------------------- TranView ----------------- Row 2 to 7 of 7
    COMMAND ===>                                                  SCROLL ===> CSR
   
    Primary commands: SELect, RECall, ADDHelp                    Profile: CICSTS32
                STC - CICS Summary Stats   IDL - CICS Idle Time  Options: NORMAL
    Line commands: T - Tag   U - Untag   D - Delay Details (Auto-Navigation)
                   C - Code Details      N - Data Details
                   P - CallerID Details  S - Additional Tran Statistics
   
    LC TRAN     T D #Trans Avg RESP Avg CPU  Actv%  Data%  Other% Total% Visual
       ________ _ _ ______ ________ ________ ______ ______ ______ ______ __________
    >------------------------------------------------------------------------------
    __ MVB2       Y      1 30.25732  0.02672  12.50   3.75   0.00  16.25 =====>
    __ MVB3       Y      1 31.57696  0.04382  11.25   1.25   3.75  16.25 =====>
    __ MVB4              1 30.19894  0.01891   5.00   0.00  10.00  15.00 =====>
    __ MVB5       Y      3 30.29251  0.01075   7.50   0.00   5.00  12.50 ====>
    __ MVB1       Y      0  0.00000  0.00000   6.25   0.00   5.00  11.25 ====>
    __ CATR              1  0.01592  0.00512   0.00   0.00   1.25   1.25
    ********************************* End of Table ********************************