CICSplex Task DB2 Statistics attribute group
The CICSplex Task DB2 Statistics attributes report on the DB2 activity carried out by the transaction. The attributes provide counts and elapsed times by SQL command.
CICS Name Identifies the name of the CICS region that is being monitored.
Close cursor time Indicates the total amount of time (in seconds) used by this task for close cursor SQL commands.
Close cursors Indicates the number of times that the close cursor SQL command was issued by this task.
Db2Entry Name Indicates the name of DB2ENTRY used by the task.
Db2Plan Name Indicates the name of DB2PLAN used by the task.
Db2Tran Name Indicates the name of DB2TRAN used by the task.
Delete time Indicates the total amount of time (in seconds) used by this task for delete SQL commands.
Deletes Indicates the number of times that the delete SQL command was issued by this task.
Describe time Indicates the total amount of time (in seconds) used by this task for describe SQL commands.
Describes Indicates the number of times that the describe SQL command was issued by this task.
Elapsed time Indicates the total amount of time (in seconds) used by this task for SQL commands.
Exec immediate time Indicates the total amount of time (in seconds) used by this task for exec immediate SQL commands.
Exec immediates Indicates the number of times that the exec immediate SQL command was issued by this task.
Execute time Indicates the total amount of time (in seconds) used by this task for execute SQL commands.
Executes Indicates the number of times that the execute SQL command was issued by this task.
Fetch time Indicates the total amount of time (in seconds) used by this task for fetch SQL commands.
Fetches Indicates the number of times that the fetch SQL command was issued by this task.
Insert time Indicates the total amount of time (in seconds) used by this task for insert SQL commands.
Inserts Indicates the number of times that the insert SQL command was issued by this task.
Miscellaneous call time Indicates the total amount of time (in seconds) used by this task for misc call SQL commands.
Miscellaneous calls Indicates the number of times that the misc call SQL command was issued by this task.
Open cursor time Indicates the total amount of time (in seconds) used by this task for open cursor SQL commands.
Open cursors Indicates the number of times that the open cursor SQL command was issued by this task.
Origin Node Is the combination of z/OS System ID (SMFID) and CICS region name. The value format is a case-sensitive, alphanumeric string, maximum 32 bytes
Prepare time Indicates the total amount of time (in seconds) used by this task for prepare SQL commands.
Prepares Indicates the number of times that the prepare SQL command was issued by this task.
Select time Indicates the total amount of time (in seconds) used by this task for select SQL commands.
Selects Indicates the number of times that the select SQL command was issued by this task.
System ID Indicates the four-character name that uniquely identifies an active z/OS operating system within a given CICSplex.
Task Number Indicates the number that was sequentially assigned by CICS to uniquely identify the task.
Total requests Indicates the total number of SQL commands that were issued by this task.
Transaction ID Indicates the four-character name of the transaction.
Update time Indicates the total amount of time (in seconds) used by this task for update SQL commands.
Updates Indicates the number of times that the update SQL command was issued by this task.