Information written to XML for a package cache event monitor

db2_pkgcache_event

The main schema that describes a package cache 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 , 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 for 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 for 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 for 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 for 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 for 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 for 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 for 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 for more details.

Contained by: db2_pkgcache_event

Attributes:

num_executions

The number times the SQL statement has been executed. See monitor element num_executions for 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 for 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 for 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 for 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 for 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 for more details.

Contained by: db2_pkgcache_event

Element content:

stmt_type_id

Statement type identifier. See monitor element stmt_type_id for 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 for more details.

Contained by: db2_pkgcache_event

Element content:

stmt_pkg_cache_id

See monitor element stmt_pkgcache_id for more details.

Contained by: db2_pkgcache_event

Element content:

stmt_text

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

Contained by: db2_pkgcache_event

comp_env_desc

comp_env_desc

Contained by: db2_pkgcache_event

section_env

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

Contained by: db2_pkgcache_event

activity_metrics

The activity metrics for this cache entry.

Contained by: db2_pkgcache_event

Element content: ( wlm_queue_time_total , wlm_queue_assignments_total , fcm_tq_recv_wait_time , fcm_message_recv_wait_time , fcm_tq_send_wait_time , fcm_message_send_wait_time , lock_wait_time , lock_waits , direct_read_time , direct_read_reqs , direct_write_time , direct_write_reqs , log_buffer_wait_time , num_log_buffer_full , log_disk_wait_time , log_disk_waits_total , pool_write_time , pool_read_time , audit_file_write_wait_time , audit_file_writes_total , audit_subsystem_wait_time , audit_subsystem_waits_total , diaglog_write_wait_time , diaglog_writes_total , fcm_send_wait_time , fcm_recv_wait_time , total_act_wait_time , total_section_sort_proc_time , total_section_sort_time , total_section_sorts , total_act_time , rows_read , rows_modified , pool_data_l_reads , pool_index_l_reads , pool_temp_data_l_reads , pool_temp_index_l_reads , pool_xda_l_reads , pool_temp_xda_l_reads , total_cpu_time , pool_data_p_reads , pool_temp_data_p_reads , pool_xda_p_reads , pool_temp_xda_p_reads , pool_index_p_reads , pool_temp_index_p_reads , pool_data_writes , pool_xda_writes , pool_index_writes , direct_reads , direct_writes , rows_returned , deadlocks , lock_timeouts , lock_escals , fcm_sends_total , fcm_recvs_total , fcm_send_volume , fcm_recv_volume , fcm_message_sends_total , fcm_message_recvs_total , fcm_message_send_volume , fcm_message_recv_volume , fcm_tq_sends_total , fcm_tq_recvs_total , fcm_tq_send_volume , fcm_tq_recv_volume , tq_tot_send_spills , post_threshold_sorts , post_shrthreshold_sorts , sort_overflows , audit_events_total , total_sorts , stmt_exec_time , coord_stmt_exec_time {zero or one times (?)} , total_routine_non_sect_proc_time , total_routine_non_sect_time , total_section_proc_time , total_section_time , total_app_section_executions , total_routine_user_code_proc_time , total_routine_user_code_time , total_routine_time , thresh_violations , num_lw_thresh_exceeded , total_routine_invocations , ANY content ( skip ) {zero or more (*)} )

Attributes: