Information written to XML for a package cache event monitor
Information written for a package cache event monitor from the EVMON_FORMAT_UE_TO_XML table function. This is also documented in the DB2EvmonPkgCache.xsd file.
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 , active_hash_grpbys_top , active_hash_joins_top , active_olap_funcs_top , active_peas_top , active_peds_top , active_sort_consumers_top , active_sorts_top , active_col_vector_consumers_top , sort_consumer_heap_top , sort_consumer_shrheap_top , sort_heap_top , sort_shrheap_top , ANY content ( skip ) {zero or more (*)} )
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | required | |||
type | required | ||||
timestamp | xs:dateTime | required | |||
member | required | ||||
release | xs:long | required | |||
ANY attribute from ANY namespace |
section_type
The type of SQL statement processed. Possible values: D:Dynamic or S:Static. See monitor element section_type - Section type indicator monitor element 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 - Insert timestamp monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:dateTime |
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 element 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 - Package schema monitor element 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 - Package name monitor element 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 - Package version monitor element 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 - Section number monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
effective_isolation
The isolation value in effect for the SQL statement while it was being run. See monitor element effective_isolation - Effective isolation monitor element for more details.
Contained by: db2_pkgcache_event
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | optional |
num_executions
The number times the SQL statement has been executed. See monitor element num_executions - Statement executions monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
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 element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
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 element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
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 element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:dateTime |
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 element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
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 element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
stmt_type_id
Statement type identifier. See monitor element stmt_type_id - Statement type identifier monitor element for more details.
Contained by: db2_pkgcache_event
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:long | optional |
query_cost_estimate
Estimated cost for a query, as determined by the SQL compiler. See monitor element query_cost_estimate - Query cost estimate monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
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 element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
stmt_text
The text of the SQL statement. See monitor element stmt_text - SQL statement text monitor element for more details.
Contained by: db2_pkgcache_event
comp_env_desc
The element stores information about the compilation environment used when compiling the SQL statement. See monitor element comp_env_desc - Compilation environment monitor element for more details.
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 element for 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 element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
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 element for 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 element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
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 elements for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
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 elements for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
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 element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
max_coord_stmt_exec_timestamp
See monitor element max_coord_stmt_exec_timestamp - Maximum coordinator statement execution timestamp monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:dateTime |
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 element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
stmtno
See monitor element stmtno - Statement number monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:int |
num_routines
See monitor element num_routines - Number of routines monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:int |
stmtid
See monitor element stmtid - Query statement ID monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
planid
See monitor element planid - Query plan ID monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
prep_warning
See monitor element prep_warning - Prepare warning SQLCODE monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:int |
prep_warning_reason
See monitor element prep_warning_reason - Prepare warning SQLCODE reason identifier monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:int |
semantic_env_id
See monitor element semantic_env_id - Query semantic compilation environment ID monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
active_hash_grpbys_top
See monitor element active_hash_grpbys_top - Active hash GROUP BY operations high watermark monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
active_hash_joins_top
See monitor element active_hash_joins_top - Active hash join operations high watermark monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
active_olap_funcs_top
See monitor element active_olap_funcs_top - Active OLAP function operations high watermark monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
active_peas_top
See monitor element active_peas_top - Active partial early aggregation operations high watermark monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
active_peds_top
See monitor element active_peds_top - Active partial early distinct operations high watermark monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
active_sort_consumers_top
See monitor element active_sort_consumers_top - Active sort memory consumers high watermark monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
active_sorts_top
See monitor element active_sorts_top - Active sorts high watermark monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
active_col_vector_consumers_top
See monitor element active_col_vector_consumers_top - Active columnar vector memory consumers high watermark monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
sort_consumer_heap_top
See monitor element sort_consumer_heap_top - Individual private sort heap consumer high watermark monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
sort_consumer_shrheap_top
See monitor element sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
sort_heap_top
See monitor element sort_heap_top - Sort private heap high watermark monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
sort_shrheap_top
See monitor element sort_shrheap_top - Sort share heap high watermark monitor element for more details.
Contained by: db2_pkgcache_event
Element content:
Type | Facet |
---|---|
xs:long |
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 element for 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 element for more details.
Contained by: max_coord_stmt_exec_time_arg
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:int | required |
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 element for more details.
Contained by: max_coord_stmt_exec_time_arg
Attributes:
QName | Type | Fixed | Default | Use | Annotation |
---|---|---|---|---|---|
id | xs:int | required |
stmt_value_type
The element contains a string representation of the type of data value associated with an SQL statement. See monitor element stmt_value_type - Value type monitor element for more details.
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 element for more details.
Contained by: max_coord_stmt_exec_time_arg