CICS DB2 statement is a child component of the CICS Transaction Lifetime root component:
Program program_name|SSID db2_ssid|query_statement_type[ Stmt #number]
Identifies a program that ran in the transaction.
Is the ID of the DB2 subsystem on which the query ran.
Identifies the type of query statement.
(Optional) Is a statement number that the DB2 precompiler generates.
The number is available when the value of the CA SYSVIEW PERFORMANCE-DATA-DB2-BY-STMT option is Yes. You can change this option dynamically for one or more CICS regions through the CCONFIG or CICSSET command. You can change the option permanently by updating the option in the CNM4BPRM(CICSOPTS) member.
Note: For information about CA SYSVIEW commands, see the CA SYSVIEW online help.
Important! Setting the PERFORMANCE-DATA-DB2-BY-STMT option to Yes can potentially produce a large amount of data.
This component contains the following properties:
Is the average time spent executing the DB2 statement.
Is the maximum time spent on a single run of a DB2 statement. The time includes both suspend and dispatch timings.
Identifies the program that executed the DB2 statement.
Is the number of times the program executed the DB2 statement from the indicated statement number. (If statement numbers are disabled, this value is the number of times any DB2 statement of the indicated type was executed in the program.) If the program ran multiple times within a transaction, then this value is cumulative.
Is the ID of the DB2 subsystem on which the DB2 statements were executed.
(Optional) Is a statement number that the DB2 precompiler generates (if configured).
Identifies the type of DB2 statement.
Note: For a complete list of DB2 statements, see the IBM DB2 for z/OS SQL Reference.
Is the total time spent on all the DB2 statements executed. The time includes both suspend and dispatch timings.
|
Copyright © 2014 CA.
All rights reserved.
|
|