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 procedure to display the SQL statements for a CICS job.

Follow these steps:

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

   For more information about specifying monitoring criteria, see the chapter "Setting up a monitor definition."

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. Select Option 6 from the Interactive Analysis menu.

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