Information written to XML for a package cache event monitor

db2_pkgcache_event

The main schema that describes a package cache event event in details.

Element content: ( section_type , insert_timestamp , executable_id , package_schema , package_name , package_version_id , section_number {zero or one times (?)} , effective_isolation , num_executions , num_exec_with_metrics , prep_time , last_metrics_update , num_coord_exec , num_coord_exec_with_metrics , stmt_type_id , query_cost_estimate , stmt_pkg_cache_id , stmt_text , comp_env_desc , section_env , activity_metrics , routine_id , query_data_tag_list , total_stats_fabrication_time , total_stats_fabrications , total_sync_runstats_time , total_sync_runstats , max_coord_stmt_exec_timestamp {zero or one times (?)} , max_coord_stmt_exec_time_arg {zero or more (*)} , max_coord_stmt_exec_time , stmtno , num_routines , stmtid , planid , prep_warning , prep_warning_reason , semantic_env_id , ANY content ( skip ) {zero or more (*)} )

Attributes:

section_type

The type of SQL statement processed. Possible values: D:Dynamic or S:Static. See monitor element section_type - Section type indicator monitor elementfor more details.

Contained by: db2_pkgcache_event

insert_timestamp

The time when the variation or section was inserted into the cache. See monitor element insert_timestamp - Insert timestamp monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

executable_id

A binary token generated on the data server that uniquely identifies the SQL statement section that was executed. See monitor element executable_id - Executable ID monitor elementfor more details.

Contained by: db2_pkgcache_event

package_schema

The schema name of the package associated with an SQL statement. See monitor element package_schema - Package schema monitor elementfor more details.

Contained by: db2_pkgcache_event

package_name

The name of the package that contains the SQL statement currently executing. See monitor element package_name - Package name monitor elementfor more details.

Contained by: db2_pkgcache_event

package_version_id

The package version identifies the version identifier of the package that contains the SQL statement currently executing. See monitor element package_version_id - Package version monitor elementfor more details.

Contained by: db2_pkgcache_event

section_number

The internal section number in the package for the SQL statement currently processing or most recently processed. See monitor element section_number - Section number monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

effective_isolation

The isolation value in effect for the SQL statement while it was being run. See monitor element effective_isolation - Effective isolation monitor elementfor more details.

Contained by: db2_pkgcache_event

Attributes:

num_executions

The number times the SQL statement has been executed. See monitor element num_executions - Statement executions monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

num_exec_with_metrics

The number times the SQL statement has been executed with the metrics. collected. See monitor element num_exec_with_metrics - Number of executions with metrics collected monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

prep_time

Time in milliseconds required to prepare an SQL statement if the activity is an SQL statement. See monitor element prep_time - Preparation time monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

last_metrics_update

Timestamp reflecting the last time metrics were updated for this cache entry. See monitor element last_metrics_update - Metrics last update timestamp monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

num_coord_exec

The number of times this section was executed by a coordinator agent. See monitor element num_coord_exec - Number of executions by coordinator agent monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

num_coord_exec_with_metrics

The number of times this section was executed by a coordinator agent and monitoring metrics were being captured. See monitor element num_coord_exec_with_metrics - Number of executions by coordinator agent with metrics monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

stmt_type_id

Statement type identifier. See monitor element stmt_type_id - Statement type identifier monitor elementfor more details.

Contained by: db2_pkgcache_event

Attributes:

query_cost_estimate

Estimated cost for a query, as determined by the SQL compiler. See monitor element query_cost_estimate - Query cost estimate monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

stmt_pkg_cache_id

This element shows the internal package cache identifier for a dynamic SQL statement. See monitor element stmt_pkg_cache_id - Statement package cache identifier monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

stmt_text

The text of the SQL statement. See monitor element stmt_text - SQL statement text monitor elementfor more details.

Contained by: db2_pkgcache_event

comp_env_desc

comp_env_desc - Compilation environment monitor element

Contained by: db2_pkgcache_event

section_env

A BLOB that contains the section for an SQL statement. See monitor element section_env - Section environment monitor elementfor more details.

Contained by: db2_pkgcache_event

activity_metrics

The activity metrics for this cache entry.

Contained by: db2_pkgcache_event

routine_id

For CALL statements this element stores the routine identifier associated with the stored procedure invoked. See monitor element routine_id - Routine ID monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

query_data_tag_list

The data tag list for this cache entry. See monitor element query_data_tag_list - Estimated query data tag list monitor elementfor more details.

Contained by: db2_pkgcache_event

total_stats_fabrication_time

Total time spent, in milliseconds, on statistics fabrications by real-time statistics gathering. See monitor element total_stats_fabrication_time - Total statistics fabrication time monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

total_stats_fabrications

Total number of statistics fabrications performed by real-time statistics during query compilation. See monitor element total_stats_fabrications - Total statistics fabrications monitor elementsfor more details.

Contained by: db2_pkgcache_event

Element content:

total_sync_runstats_time

Total time spent, in milliseconds, on synchronous RUNSTATS activities triggered by real-time statistics gathering. See monitor element total_sync_runstats_time - Total synchronous RUNSTATS time monitor elementsfor more details.

Contained by: db2_pkgcache_event

Element content:

total_sync_runstats

Total number of synchronous RUNSTATS activities triggered by real-time statistics gathering. See monitor element total_sync_runstats - Total synchronous RUNSTATS activities monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

max_coord_stmt_exec_timestamp

See monitor element max_coord_stmt_exec_timestamp - Maximum coordinator statement execution timestamp monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

max_coord_stmt_exec_time_arg

Describes an input variable to this statement which produced the max_coord_stmt_exec_time.

Contained by: db2_pkgcache_event

Element content: ( stmt_value_index , stmt_value_isreopt , stmt_value_isnull , stmt_value_type , stmt_value_data , ANY content ( skip ) {zero or more (*)} )

max_coord_stmt_exec_time

See monitor element max_coord_stmt_exec_time - Maximum coordinator statement execution time monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

stmtno

See monitor element stmtno - Statement number monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

num_routines

See monitor element num_routines - Number of routines monitor elementfor more details.

Contained by: db2_pkgcache_event

Element content:

stmtid

Contained by: db2_pkgcache_event

Element content:

planid

Contained by: db2_pkgcache_event

Element content:

prep_warning

Contained by: db2_pkgcache_event

Element content:

prep_warning_reason

Contained by: db2_pkgcache_event

Element content:

semantic_env_id

Contained by: db2_pkgcache_event

Element content:

stmt_value_index

The element represents the position of the input parameter marker or host variable used in the SQL statement. See monitor element stmt_value_index - Value index monitor elementfor more details.

Contained by: max_coord_stmt_exec_time_arg

stmt_value_isreopt

The element shows whether the variable was used during statement reoptimization. See monitor element stmt_value_isreopt - Variable used for statement reoptimization monitor elementfor more details.

Contained by: max_coord_stmt_exec_time_arg

Attributes:

stmt_value_isnull

The element shows whether a data value associated with the SQL statement is the NULL value. See monitor element stmt_value_isnull - Value has null value monitor elementfor more details.

Contained by: max_coord_stmt_exec_time_arg

Attributes:

stmt_value_type

stmt_value_type - Value type monitor element

Contained by: max_coord_stmt_exec_time_arg

stmt_value_data

The element contains a string representation of a data value associated with an SQL statement. See monitor element stmt_value_data - Value data monitor elementfor more details.

Contained by: max_coord_stmt_exec_time_arg