Google Git
Sign in
apache / trafodion / refs/tags/2.3.0rc1 / . / core / sql / sqlcomp / CmpSeabaseDDLrepos.h
blob: 7a672d4a973f8ee4fd18d8245cc922e6f68ba0e2 [file] [log] [blame]
// @@@ START COPYRIGHT @@@
//
// Licensed to the Apache Software Foundation (ASF) under one
// or more contributor license agreements. See the NOTICE file
// distributed with this work for additional information
// regarding copyright ownership. The ASF licenses this file
// to you under the Apache License, Version 2.0 (the
// "License"); you may not use this file except in compliance
// with the License. You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing,
// software distributed under the License is distributed on an
// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
// KIND, either express or implied. See the License for the
// specific language governing permissions and limitations
// under the License.
//
// @@@ END COPYRIGHT @@@
/*
********************************************************************************
*
* File: CmpSeabaseDDLrepos.h
* Description: This file describes repository tables used by Trafodion.
*
* *****************************************************************************
*/
#ifndef _CMP_SEABASE_REPOS_H_
#define _CMP_SEABASE_REPOS_H_
#define TRAF_METRIC_QUERY_VIEW "METRIC_QUERY_VIEW"
///////////////////////////////////////////////////////////////////////////////
// *** Current Definition ***
//
// Current repository tables definition for Metadata Version 2.1
// (Major version = 2, Minor version = 1)
///////////////////////////////////////////////////////////////////////////////
//----------------------------------------------------------------
//-- METRIC_QUERY_TABLE
//----------------------------------------------------------------
static const QString createMetricQueryTable[] =
{
{" create table %s.\"%s\"." REPOS_METRIC_QUERY_TABLE" "},
{" ( "},
{" instance_id integer unsigned no default not null not droppable serialized, "},
{" tenant_id integer unsigned no default not null not droppable serialized, "},
{" component_id integer unsigned default null serialized, "},
{" process_id integer default null serialized, "},
{" thread_id integer unsigned default null serialized, "},
{" node_id integer unsigned default null serialized, "},
{" pnid_id integer unsigned default null serialized, "},
{" host_id integer unsigned no default not null not droppable serialized, "},
{" ip_address_id char(32) character set iso88591 casespecific default null serialized, "},
{" sequence_number integer unsigned default null serialized, "},
{" process_name char(32) character set iso88591 casespecific default null serialized, "},
{" exec_start_utc_ts timestamp(6) no default not null not droppable not serialized, "},
{" query_id char(" MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific no default not null not droppable serialized, "},
{" query_signature_id char(" MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific default null serialized, "},
{" user_name char(256 bytes) character set utf8 casespecific default null serialized, "},
{" role_name char(256 bytes) character set utf8 casespecific default null serialized, "},
{" start_priority integer unsigned default null serialized, "},
{" master_process_id char(64) character set iso88591 casespecific default null serialized, "},
{" session_id char(108) character set iso88591 casespecific default null serialized, "},
{" client_name varchar(1024) character set iso88591 casespecific default null serialized, "},
{" application_name char(130) character set iso88591 casespecific default null serialized, "},
{" statement_id char(" MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific default null serialized, "},
{" statement_type char(36) character set iso88591 casespecific default null serialized, "},
{" statement_subtype char(36) character set iso88591 casespecific default null serialized, "},
{" submit_utc_ts timestamp(6) default null not serialized, "},
{" compile_start_utc_ts timestamp(6) default null not serialized, "},
{" compile_end_utc_ts timestamp(6) default null not serialized, "},
{" compile_elapsed_time largeint default null serialized, "},
{" cmp_affinity_num largeint default null serialized, "},
{" cmp_dop largeint default null serialized, "},
{" cmp_txn_needed largeint default null serialized, "},
{" cmp_mandatory_x_prod largeint default null serialized, "},
{" cmp_missing_stats largeint default null serialized, "},
{" cmp_num_joins largeint default null serialized, "},
{" cmp_full_scan_on_table largeint default null serialized, "},
{" cmp_rows_accessed_full_scan double precision default null not serialized, "},
{" est_accessed_rows double precision default null not serialized, "},
{" est_used_rows double precision default null not serialized, "},
{" cmp_compiler_id char(28) character set iso88591 casespecific default null serialized, "},
{" cmp_cpu_path_length largeint default null serialized, "},
{" cmp_cpu_binder largeint default null serialized, "},
{" cmp_cpu_normalizer largeint default null serialized, "},
{" cmp_cpu_analyzer largeint default null serialized, "},
{" cmp_cpu_optimizer largeint default null serialized, "},
{" cmp_cpu_generator largeint default null serialized, "},
{" cmp_metadata_cache_hits largeint default null serialized, "},
{" cmp_metadata_cache_lookups largeint default null serialized, "},
{" cmp_query_cache_status largeint default null serialized, "},
{" cmp_histogram_cache_hits largeint default null serialized, "},
{" cmp_histogram_cache_lookups largeint default null serialized, "},
{" cmp_stmt_heap_size largeint default null serialized, "},
{" cmp_context_heap_size largeint default null serialized, "},
{" cmp_optimization_tasks largeint default null serialized, "},
{" cmp_optimization_contexts largeint default null serialized, "},
{" cmp_is_recompile smallint default null serialized, "},
{" est_num_seq_ios double precision default null not serialized, "},
{" est_num_rand_ios double precision default null not serialized, "},
{" est_cost double precision default null not serialized, "},
{" est_cardinality double precision default null not serialized, "},
{" est_io_time double precision default null not serialized, "},
{" est_msg_time double precision default null not serialized, "},
{" est_idle_time double precision default null not serialized, "},
{" est_cpu_time double precision default null not serialized, "},
{" est_total_time double precision default null not serialized, "},
{" est_total_mem double precision default null not serialized, "},
{" est_resource_usage largeint default null serialized, "},
{" aggregate_option char(3) character set iso88591 casespecific default null serialized, "},
{" cmp_number_of_bmos integer default null serialized, "},
{" cmp_overflow_mode char(10) character set iso88591 casespecific default null serialized, "},
{" cmp_overflow_size largeint default null serialized, "},
{" aggregate_total largeint default null serialized, "},
{" stats_error_code integer default null serialized, "},
{" query_elapsed_time largeint default null serialized, "},
{" sql_process_busy_time largeint default null serialized, "},
{" disk_process_busy_time largeint default null serialized, "},
{" disk_ios largeint default null serialized, "},
{" num_sql_processes largeint default null serialized, "},
{" sql_space_allocated largeint default null serialized, "},
{" sql_space_used largeint default null serialized, "},
{" sql_heap_allocated largeint default null serialized, "},
{" sql_heap_used largeint default null serialized, "},
{" total_mem_alloc largeint default null serialized, "},
{" max_mem_used largeint default null serialized, "},
{" transaction_id char(25) character set iso88591 casespecific default null serialized, "},
{" num_request_msgs largeint default null serialized, "},
{" num_request_msg_bytes largeint default null serialized, "},
{" num_reply_msgs largeint default null serialized, "},
{" num_reply_msg_bytes largeint default null serialized, "},
{" first_result_return_utc_ts timestamp(6) default null not serialized, "},
{" rows_returned_to_master largeint default null serialized, "},
{" parent_query_id char(" MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific default null serialized, "},
{" parent_system_name char(128) character set iso88591 casespecific default null serialized, "},
{" exec_end_utc_ts timestamp(6) default null not serialized, "},
{" master_execution_time largeint default null serialized, "},
{" master_elapsed_time largeint default null serialized, "},
{" query_status char(21) character set utf8 casespecific default null serialized, "},
{" query_sub_status char(30) character set utf8 casespecific default null serialized, "},
{" error_code integer default null serialized, "},
{" sql_error_code integer default null serialized, "},
{" error_text varchar(2000) character set utf8 casespecific default null serialized, "},
{" query_text varchar(50000) character set utf8 casespecific default null serialized, "},
{" explain_plan varchar(" REPOS_MAX_EXPLAIN_PLAN_LEN_STR") character set iso88591 casespecific default null serialized, "},
{" last_error_before_aqr integer default null serialized, "},
{" delay_time_before_aqr_sec largeint default null serialized, "},
{" total_num_aqr_retries largeint default null serialized, "},
{" msg_bytes_to_disk largeint default null serialized, "},
{" msgs_to_disk largeint default null serialized, "},
{" rows_accessed largeint default null serialized, "},
{" rows_retrieved largeint default null serialized, "},
{" num_rows_iud largeint default null serialized, "},
{" processes_created largeint default null serialized, "},
{" process_create_busy_time largeint default null serialized, "},
{" ovf_file_count largeint default null serialized, "},
{" ovf_space_allocated largeint default null serialized, "},
{" ovf_space_used largeint default null serialized, "},
{" ovf_block_size largeint default null serialized, "},
{" ovf_write_read_count largeint default null serialized, "},
{" ovf_write_count largeint default null serialized, "},
{" ovf_buffer_blocks_written largeint default null serialized, "},
{" ovf_buffer_bytes_written largeint default null serialized, "},
{" ovf_read_count largeint default null serialized, "},
{" ovf_buffer_blocks_read largeint default null serialized, "},
{" ovf_buffer_bytes_read largeint default null serialized, "},
{" num_nodes largeint default null serialized, "},
{" udr_process_busy_time largeint default null serialized, "},
{" pertable_stats integer default null serialized, "},
{" last_updated_time timestamp(6) default null not serialized"},
{" "},
{" ) "},
{" primary key ( exec_start_utc_ts, query_id ) salt using 8 partitions on ( query_id ) "},
{" hbase_options ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'GZ' ) "},
{" attribute hbase format "},
{" ; "}
};
//----------------------------------------------------------------
// -- METRIC_SESSION_TABLE
// ----------------------------------------------------------------
static const QString createMetricSessionTable[] =
{
{" create table %s.\"%s\"." REPOS_METRIC_SESSION_TABLE" "},
{" ( "},
{" instance_id integer unsigned no default not null not droppable serialized, "},
{" tenant_id integer unsigned no default not null not droppable serialized, "},
{" component_id integer unsigned default null serialized, "},
{" process_id integer default null serialized, "},
{" thread_id integer unsigned default null serialized, "},
{" node_id integer unsigned default null serialized, "},
{" pnid_id integer unsigned default null serialized, "},
{" host_id integer unsigned no default not null not droppable serialized, "},
{" ip_address_id char(32) character set iso88591 casespecific default null serialized, "},
{" sequence_number integer unsigned default null serialized, "},
{" process_name char(32) character set iso88591 casespecific default null serialized, "},
{" session_id char(108) character set iso88591 casespecific no default not null not droppable serialized, "},
{" session_status char(5) character set iso88591 casespecific default null serialized, "},
{" session_start_utc_ts timestamp(6) no default not null not droppable not serialized, "},
{" session_end_utc_ts timestamp(6) default null not serialized, "},
{" user_id largeint default null serialized, "},
{" user_name char(256 bytes) character set utf8 casespecific default null serialized, "},
{" role_name char(256 bytes) character set utf8 casespecific default null serialized, "},
{" client_name varchar(256) character set utf8 casespecific default null serialized, "},
{" client_user_name char(256 bytes) character set utf8 casespecific default null serialized, "},
{" application_name char(130) character set iso88591 casespecific default null serialized, "},
{" profile_name varchar(130) character set utf8 casespecific default null serialized, "},
{" sla_name varchar(130) character set utf8 casespecific default null serialized, "},
{" total_execution_time largeint default null serialized, "},
{" total_elapsed_time largeint default null serialized, "},
{" total_insert_stmts_executed largeint default null serialized, "},
{" total_delete_stmts_executed largeint default null serialized, "},
{" total_update_stmts_executed largeint default null serialized, "},
{" total_select_stmts_executed largeint default null serialized, "},
{" total_catalog_stmts largeint default null serialized, "},
{" total_prepares largeint default null serialized, "},
{" total_executes largeint default null serialized, "},
{" total_fetches largeint default null serialized, "},
{" total_closes largeint default null serialized, "},
{" total_execdirects largeint default null serialized, "},
{" total_errors largeint default null serialized, "},
{" total_warnings largeint default null serialized, "},
{" total_login_elapsed_time_mcsec largeint default null serialized, "},
{" ldap_login_elapsed_time_mcsec largeint default null serialized, "},
{" sql_user_elapsed_time_mcsec largeint default null serialized, "},
{" search_connection_elapsed_time_mcsec largeint default null serialized, "},
{" search_elapsed_time_mcsec largeint default null serialized, "},
{" authentication_connection_elapsed_time_mcsec largeint default null serialized, "},
{" authentication_elapsed_time_mcsec largeint default null serialized "},
{" ) "},
{" primary key (session_start_utc_ts, session_id ) salt using 8 partitions on ( session_id ) "},
{" hbase_options ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'GZ' ) "},
{" attribute hbase format "},
{" ; "},
};
//----------------------------------------------------------------
//- METRIC_QUERY_AGGREGATION_TABLE
//----------------------------------------------------------------
static const QString createMetricQueryAggrTable[] =
{
{" create table %s.\"%s\"." REPOS_METRIC_QUERY_AGGR_TABLE" "},
{" ( "},
{" instance_id integer unsigned no default not null not droppable serialized, "},
{" tenant_id integer unsigned no default not null not droppable serialized, "},
{" component_id integer unsigned default null serialized, "},
{" process_id integer default null serialized, "},
{" thread_id integer unsigned default null serialized, "},
{" node_id integer unsigned default null serialized, "},
{" pnid_id integer unsigned default null serialized, "},
{" host_id integer unsigned no default not null not droppable serialized, "},
{" ip_address_id char(32) character set iso88591 casespecific default null serialized, "},
{" sequence_number integer unsigned default null serialized, "},
{" process_name char(32) character set iso88591 casespecific default null serialized, "},
{" session_id char(108) character set iso88591 casespecific no default not null not droppable serialized, "},
{" session_start_utc_ts timestamp(6) no default not null not droppable not serialized, "},
{" aggregation_last_update_utc_ts timestamp(6) default null not serialized, "},
{" aggregation_last_elapsed_time largeint default null serialized, "},
{" user_id largeint default null serialized, "},
{" user_name char(256 bytes) character set utf8 casespecific default null serialized, "},
{" role_name char(256 bytes) character set utf8 casespecific default null serialized, "},
{" client_name varchar(256) character set utf8 casespecific default null serialized, "},
{" client_user_name char(256 bytes) character set utf8 casespecific default null serialized, "},
{" application_name char(130) character set iso88591 casespecific default null serialized, "},
{" total_est_rows_accessed largeint default null serialized, "},
{" total_est_rows_used largeint default null serialized, "},
{" total_rows_retrieved largeint default null serialized, "},
{" total_num_rows_iud largeint default null serialized, "},
{" total_selects largeint default null serialized, "},
{" total_inserts largeint default null serialized, "},
{" total_updates largeint default null serialized, "},
{" total_deletes largeint default null serialized, "},
{" total_ddl_stmts largeint default null serialized, "},
{" total_util_stmts largeint default null serialized, "},
{" total_catalog_stmts largeint default null serialized, "},
{" total_other_stmts largeint default null serialized, "},
{" total_insert_errors largeint default null serialized, "},
{" total_delete_errors largeint default null serialized, "},
{" total_update_errors largeint default null serialized, "},
{" total_select_errors largeint default null serialized, "},
{" total_ddl_errors largeint default null serialized, "},
{" total_util_errors largeint default null serialized, "},
{" total_catalog_errors largeint default null serialized, "},
{" total_other_errors largeint default null serialized, "},
{" delta_estimated_rows_accessed largeint default null serialized, "},
{" delta_estimated_rows_used largeint default null serialized, "},
{" delta_rows_accessed largeint default null serialized, "},
{" delta_rows_retrieved largeint default null serialized, "},
{" delta_num_rows_iud largeint default null serialized, "},
{" delta_selects largeint default null serialized, "},
{" delta_inserts largeint default null serialized, "},
{" delta_updates largeint default null serialized, "},
{" delta_deletes largeint default null serialized, "},
{" delta_ddl_stmts largeint default null serialized, "},
{" delta_util_stmts largeint default null serialized, "},
{" delta_catalog_stmts largeint default null serialized, "},
{" delta_other_stmts largeint default null serialized, "},
{" delta_insert_errors largeint default null serialized, "},
{" delta_delete_errors largeint default null serialized, "},
{" delta_update_errors largeint default null serialized, "},
{" delta_select_errors largeint default null serialized, "},
{" delta_ddl_errors largeint default null serialized, "},
{" delta_util_errors largeint default null serialized, "},
{" delta_catalog_errors largeint default null serialized, "},
{" delta_other_errors largeint default null serialized, "},
{" average_response_time largeint default null serialized, "},
{" throughput_per_second largeint default null serialized "},
{" ) "},
{" primary key ( session_start_utc_ts, session_id ) salt using 8 partitions on ( session_id ) "},
{" hbase_options ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'GZ' ) "},
{" attribute hbase format "},
{" ; "}
};
//----------------------------------------------------------------
//-- METRIC_TEXT_TABLE
//----------------------------------------------------------------
static const QString createMetricTextTable[] =
{
{" create table %s.\"%s\"." REPOS_METRIC_TEXT_TABLE" "},
{" ( "},
{" query_id char(" MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific no default not null not droppable serialized, "},
{" text_type int not null serialized, "},
{" sub_id int not null serialized, "},
{" seq_num int not null serialized, "},
{" flags largeint not null serialized, "},
{" text varchar(50000 bytes) character set iso88591 not null serialized "},
{" ) "},
{" primary key (query_id, text_type, sub_id, seq_num) "},
{" attribute hbase format "},
{" ; "}
};
/////////////////////////////////////////////////////////////////////
//
// Information about changed old metadata tables from which upgrade
// is being done to the current version.
// These definitions have changed in the current version of code.
//
// Old definitions have the form (for ex for METRIC_QUERY_TABLE table):
// createOldTrafv??MetricQueryTable[]
// v?? is the old version.
//
// When definitions change, make new entries between
// START_OLD_MD_v?? and END_OLD_MD_v??.
// Do not remove older entries. We want to keep them around for
// historical purpose.
//
// Change entries in allReposUpgradeInfo[] struct in this file
// to reflect the 'old' repository tables.
//
//////////////////////////////////////////////////////////////////////
#define TRAF_METRIC_QUERY_TABLE_OLD_REPOS REPOS_METRIC_QUERY_TABLE"_OLD_REPOS"
#define TRAF_METRIC_SESSION_TABLE_OLD_REPOS REPOS_METRIC_SESSION_TABLE"_OLD_REPOS"
#define TRAF_METRIC_QUERY_AGGR_TABLE_OLD_REPOS REPOS_METRIC_QUERY_AGGR_TABLE"_OLD_REPOS"
//----------------------------------------------------------------
//-- METRIC_QUERY_TABLE
//----------------------------------------------------------------
static const QString createOldTrafv11MetricQueryTable[] =
{
{" create table %s.\"%s\"." TRAF_METRIC_QUERY_TABLE_OLD_REPOS" "},
{" ( "},
{" instance_id integer unsigned no default not null not droppable serialized, "},
{" tenant_id integer unsigned no default not null not droppable serialized, "},
{" component_id integer unsigned default null serialized, "},
{" process_id integer default null serialized, "},
{" thread_id integer unsigned default null serialized, "},
{" node_id integer unsigned default null serialized, "},
{" pnid_id integer unsigned default null serialized, "},
{" host_id integer unsigned no default not null not droppable serialized, "},
{" ip_address_id char(32) character set iso88591 casespecific default null serialized, "},
{" sequence_number integer unsigned default null serialized, "},
{" process_name char(32) character set iso88591 casespecific default null serialized, "},
{" exec_start_utc_ts timestamp(6) no default not null not droppable not serialized, "},
{" query_id char(" MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific no default not null not droppable serialized, "},
{" user_name char(256 bytes) character set utf8 casespecific default null serialized, "},
{" role_name char(256 bytes) character set utf8 casespecific default null serialized, "},
{" start_priority integer unsigned default null serialized, "},
{" master_process_id char(64) character set iso88591 casespecific default null serialized, "},
{" session_id char(108) character set iso88591 casespecific default null serialized, "},
{" client_name varchar(1024) character set iso88591 casespecific default null serialized, "},
{" application_name char(130) character set iso88591 casespecific default null serialized, "},
{" statement_id char(" MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific default null serialized, "},
{" statement_type char(36) character set iso88591 casespecific default null serialized, "},
{" statement_subtype char(36) character set iso88591 casespecific default null serialized, "},
{" submit_utc_ts timestamp(6) default null not serialized, "},
{" compile_start_utc_ts timestamp(6) default null not serialized, "},
{" compile_end_utc_ts timestamp(6) default null not serialized, "},
{" compile_elapsed_time largeint default null serialized, "},
{" cmp_affinity_num largeint default null serialized, "},
{" cmp_dop largeint default null serialized, "},
{" cmp_txn_needed largeint default null serialized, "},
{" cmp_mandatory_x_prod largeint default null serialized, "},
{" cmp_missing_stats largeint default null serialized, "},
{" cmp_num_joins largeint default null serialized, "},
{" cmp_full_scan_on_table largeint default null serialized, "},
{" cmp_rows_accessed_full_scan double precision default null not serialized, "},
{" est_accessed_rows double precision default null not serialized, "},
{" est_used_rows double precision default null not serialized, "},
{" cmp_compiler_id char(28) character set iso88591 casespecific default null serialized, "},
{" cmp_cpu_path_length largeint default null serialized, "},
{" cmp_cpu_binder largeint default null serialized, "},
{" cmp_cpu_normalizer largeint default null serialized, "},
{" cmp_cpu_analyzer largeint default null serialized, "},
{" cmp_cpu_optimizer largeint default null serialized, "},
{" cmp_cpu_generator largeint default null serialized, "},
{" cmp_metadata_cache_hits largeint default null serialized, "},
{" cmp_metadata_cache_lookups largeint default null serialized, "},
{" cmp_query_cache_status largeint default null serialized, "},
{" cmp_histogram_cache_hits largeint default null serialized, "},
{" cmp_histogram_cache_lookups largeint default null serialized, "},
{" cmp_stmt_heap_size largeint default null serialized, "},
{" cmp_context_heap_size largeint default null serialized, "},
{" cmp_optimization_tasks largeint default null serialized, "},
{" cmp_optimization_contexts largeint default null serialized, "},
{" cmp_is_recompile smallint default null serialized, "},
{" est_num_seq_ios double precision default null not serialized, "},
{" est_num_rand_ios double precision default null not serialized, "},
{" est_cost double precision default null not serialized, "},
{" est_cardinality double precision default null not serialized, "},
{" est_io_time double precision default null not serialized, "},
{" est_msg_time double precision default null not serialized, "},
{" est_idle_time double precision default null not serialized, "},
{" est_cpu_time double precision default null not serialized, "},
{" est_total_time double precision default null not serialized, "},
{" est_total_mem double precision default null not serialized, "},
{" est_resource_usage largeint default null serialized, "},
{" aggregate_option char(3) character set iso88591 casespecific default null serialized, "},
{" cmp_number_of_bmos integer default null serialized, "},
{" cmp_overflow_mode char(10) character set iso88591 casespecific default null serialized, "},
{" cmp_overflow_size largeint default null serialized, "},
{" aggregate_total largeint default null serialized, "},
{" stats_error_code integer default null serialized, "},
{" query_elapsed_time largeint default null serialized, "},
{" sql_process_busy_time largeint default null serialized, "},
{" disk_process_busy_time largeint default null serialized, "},
{" disk_ios largeint default null serialized, "},
{" num_sql_processes largeint default null serialized, "},
{" sql_space_allocated largeint default null serialized, "},
{" sql_space_used largeint default null serialized, "},
{" sql_heap_allocated largeint default null serialized, "},
{" sql_heap_used largeint default null serialized, "},
{" total_mem_alloc largeint default null serialized, "},
{" max_mem_used largeint default null serialized, "},
{" transaction_id char(25) character set iso88591 casespecific default null serialized, "},
{" num_request_msgs largeint default null serialized, "},
{" num_request_msg_bytes largeint default null serialized, "},
{" num_reply_msgs largeint default null serialized, "},
{" num_reply_msg_bytes largeint default null serialized, "},
{" first_result_return_utc_ts timestamp(6) default null not serialized, "},
{" rows_returned_to_master largeint default null serialized, "},
{" parent_query_id char(" MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific default null serialized, "},
{" parent_system_name char(128) character set iso88591 casespecific default null serialized, "},
{" exec_end_utc_ts timestamp(6) default null not serialized, "},
{" master_execution_time largeint default null serialized, "},
{" master_elapsed_time largeint default null serialized, "},
{" query_status char(21) character set utf8 casespecific default null serialized, "},
{" query_sub_status char(30) character set utf8 casespecific default null serialized, "},
{" error_code integer default null serialized, "},
{" sql_error_code integer default null serialized, "},
{" error_text varchar(2000) character set utf8 casespecific default null serialized, "},
{" query_text varchar(50000) character set utf8 casespecific default null serialized, "},
{" explain_plan varchar(200000) character set iso88591 casespecific default null serialized, "},
{" last_error_before_aqr integer default null serialized, "},
{" delay_time_before_aqr_sec largeint default null serialized, "},
{" total_num_aqr_retries largeint default null serialized, "},
{" msg_bytes_to_disk largeint default null serialized, "},
{" msgs_to_disk largeint default null serialized, "},
{" rows_accessed largeint default null serialized, "},
{" rows_retrieved largeint default null serialized, "},
{" num_rows_iud largeint default null serialized, "},
{" processes_created largeint default null serialized, "},
{" process_create_busy_time largeint default null serialized, "},
{" ovf_file_count largeint default null serialized, "},
{" ovf_space_allocated largeint default null serialized, "},
{" ovf_space_used largeint default null serialized, "},
{" ovf_block_size largeint default null serialized, "},
{" ovf_write_read_count largeint default null serialized, "},
{" ovf_write_count largeint default null serialized, "},
{" ovf_buffer_blocks_written largeint default null serialized, "},
{" ovf_buffer_bytes_written largeint default null serialized, "},
{" ovf_read_count largeint default null serialized, "},
{" ovf_buffer_blocks_read largeint default null serialized, "},
{" ovf_buffer_bytes_read largeint default null serialized, "},
{" num_nodes largeint default null serialized, "},
{" udr_process_busy_time largeint default null serialized, "},
{" pertable_stats integer default null serialized "},
{" "},
{" ) "},
{" primary key ( exec_start_utc_ts, query_id ) salt using 8 partitions on ( query_id ) "},
{" hbase_options ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'GZ' ) "},
{" ; "}
};
//----------------------------------------------------------------
// -- METRIC_SESSION_TABLE
// ----------------------------------------------------------------
static const QString createOldTrafv11MetricSessionTable[] =
{
{" create table %s.\"%s\"." TRAF_METRIC_SESSION_TABLE_OLD_REPOS" "},
{" ( "},
{" instance_id integer unsigned no default not null not droppable serialized, "},
{" tenant_id integer unsigned no default not null not droppable serialized, "},
{" component_id integer unsigned default null serialized, "},
{" process_id integer default null serialized, "},
{" thread_id integer unsigned default null serialized, "},
{" node_id integer unsigned default null serialized, "},
{" pnid_id integer unsigned default null serialized, "},
{" host_id integer unsigned no default not null not droppable serialized, "},
{" ip_address_id char(32) character set iso88591 casespecific default null serialized, "},
{" sequence_number integer unsigned default null serialized, "},
{" process_name char(32) character set iso88591 casespecific default null serialized, "},
{" session_id char(108) character set iso88591 casespecific no default not null not droppable serialized, "},
{" session_status char(5) character set iso88591 casespecific default null serialized, "},
{" session_start_utc_ts timestamp(6) no default not null not droppable not serialized, "},
{" session_end_utc_ts timestamp(6) default null not serialized, "},
{" user_id largeint default null serialized, "},
{" user_name char(256 bytes) character set utf8 casespecific default null serialized, "},
{" role_name char(256 bytes) character set utf8 casespecific default null serialized, "},
{" client_name varchar(256) character set utf8 casespecific default null serialized, "},
{" client_user_name char(256 bytes) character set utf8 casespecific default null serialized, "},
{" application_name char(130) character set iso88591 casespecific default null serialized, "},
{" total_execution_time largeint default null serialized, "},
{" total_elapsed_time largeint default null serialized, "},
{" total_insert_stmts_executed largeint default null serialized, "},
{" total_delete_stmts_executed largeint default null serialized, "},
{" total_update_stmts_executed largeint default null serialized, "},
{" total_select_stmts_executed largeint default null serialized, "},
{" total_catalog_stmts largeint default null serialized, "},
{" total_prepares largeint default null serialized, "},
{" total_executes largeint default null serialized, "},
{" total_fetches largeint default null serialized, "},
{" total_closes largeint default null serialized, "},
{" total_execdirects largeint default null serialized, "},
{" total_errors largeint default null serialized, "},
{" total_warnings largeint default null serialized, "},
{" total_login_elapsed_time_mcsec largeint default null serialized, "},
{" ldap_login_elapsed_time_mcsec largeint default null serialized, "},
{" sql_user_elapsed_time_mcsec largeint default null serialized, "},
{" search_connection_elapsed_time_mcsec largeint default null serialized, "},
{" search_elapsed_time_mcsec largeint default null serialized, "},
{" authentication_connection_elapsed_time_mcsec largeint default null serialized, "},
{" authentication_elapsed_time_mcsec largeint default null serialized "},
{" ) "},
{" primary key (session_start_utc_ts, session_id ) salt using 8 partitions on ( session_id ) "},
{" hbase_options ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'GZ' ) "},
{" ; "},
};
//----------------------------------------------------------------
//- METRIC_QUERY_AGGREGATION_TABLE
//----------------------------------------------------------------
static const QString createOldTrafv11MetricQueryAggrTable[] =
{
{" create table %s.\"%s\"." TRAF_METRIC_QUERY_AGGR_TABLE_OLD_REPOS" "},
{" ( "},
{" instance_id integer unsigned no default not null not droppable serialized, "},
{" tenant_id integer unsigned no default not null not droppable serialized, "},
{" component_id integer unsigned default null serialized, "},
{" process_id integer default null serialized, "},
{" thread_id integer unsigned default null serialized, "},
{" node_id integer unsigned default null serialized, "},
{" pnid_id integer unsigned default null serialized, "},
{" host_id integer unsigned no default not null not droppable serialized, "},
{" ip_address_id char(32) character set iso88591 casespecific default null serialized, "},
{" sequence_number integer unsigned default null serialized, "},
{" process_name char(32) character set iso88591 casespecific default null serialized, "},
{" session_id char(108) character set iso88591 casespecific no default not null not droppable serialized, "},
{" session_start_utc_ts timestamp(6) no default not null not droppable not serialized, "},
{" aggregation_last_update_utc_ts timestamp(6) default null not serialized, "},
{" aggregation_last_elapsed_time largeint default null serialized, "},
{" user_id largeint default null serialized, "},
{" user_name char(256 bytes) character set utf8 casespecific default null serialized, "},
{" role_name char(256 bytes) character set utf8 casespecific default null serialized, "},
{" client_name varchar(256) character set utf8 casespecific default null serialized, "},
{" client_user_name char(256 bytes) character set utf8 casespecific default null serialized, "},
{" application_name char(130) character set iso88591 casespecific default null serialized, "},
{" total_est_rows_accessed largeint default null serialized, "},
{" total_est_rows_used largeint default null serialized, "},
{" total_rows_retrieved largeint default null serialized, "},
{" total_num_rows_iud largeint default null serialized, "},
{" total_selects largeint default null serialized, "},
{" total_inserts largeint default null serialized, "},
{" total_updates largeint default null serialized, "},
{" total_deletes largeint default null serialized, "},
{" total_ddl_stmts largeint default null serialized, "},
{" total_util_stmts largeint default null serialized, "},
{" total_catalog_stmts largeint default null serialized, "},
{" total_other_stmts largeint default null serialized, "},
{" total_insert_errors largeint default null serialized, "},
{" total_delete_errors largeint default null serialized, "},
{" total_update_errors largeint default null serialized, "},
{" total_select_errors largeint default null serialized, "},
{" total_ddl_errors largeint default null serialized, "},
{" total_util_errors largeint default null serialized, "},
{" total_catalog_errors largeint default null serialized, "},
{" total_other_errors largeint default null serialized, "},
{" delta_estimated_rows_accessed largeint default null serialized, "},
{" delta_estimated_rows_used largeint default null serialized, "},
{" delta_rows_accessed largeint default null serialized, "},
{" delta_rows_retrieved largeint default null serialized, "},
{" delta_num_rows_iud largeint default null serialized, "},
{" delta_selects largeint default null serialized, "},
{" delta_inserts largeint default null serialized, "},
{" delta_updates largeint default null serialized, "},
{" delta_deletes largeint default null serialized, "},
{" delta_ddl_stmts largeint default null serialized, "},
{" delta_util_stmts largeint default null serialized, "},
{" delta_catalog_stmts largeint default null serialized, "},
{" delta_other_stmts largeint default null serialized, "},
{" delta_insert_errors largeint default null serialized, "},
{" delta_delete_errors largeint default null serialized, "},
{" delta_update_errors largeint default null serialized, "},
{" delta_select_errors largeint default null serialized, "},
{" delta_ddl_errors largeint default null serialized, "},
{" delta_util_errors largeint default null serialized, "},
{" delta_catalog_errors largeint default null serialized, "},
{" delta_other_errors largeint default null serialized "},
{" ) "},
{" primary key ( session_start_utc_ts, session_id ) salt using 8 partitions on ( session_id ) "},
{" hbase_options ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'GZ' ) "},
{" ; "}
};
//----------------------------------------------------------------
//-- METRIC_TEXT_TABLE
//----------------------------------------------------------------
static const QString createOldTrafv11MetricTextTable[] =
{
{" create table %s.\"%s\"." REPOS_METRIC_TEXT_TABLE" "}, // table didn't change when moving from 1.1 to 2.1
{" ( "},
{" query_id char(" MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific no default not null not droppable serialized, "},
{" text_type int not null serialized, "},
{" sub_id int not null serialized, "},
{" seq_num int not null serialized, "},
{" flags largeint not null serialized, "},
{" text varchar(50000 bytes) character set iso88591 not null serialized "},
{" ) "},
{" primary key (query_id, text_type, sub_id, seq_num) "},
{" ; "}
};
// The following are the repository definitions for Metadata version 2.3 (before we
// reset the numbering for Trafodion; 2.3 preceeds Trafodion 1.1). These are
// kept solely for historical purposes.
static const QString createOldv23ReposMetricQueryTable[] =
{
{" create table %s.\"%s\"." TRAF_METRIC_QUERY_TABLE_OLD_REPOS" "},
{" ( "},
{" instance_id integer unsigned no default not null not droppable not serialized, "},
{" tenant_id integer unsigned no default not null not droppable not serialized, "},
{" component_id integer unsigned default null not serialized, "},
{" process_id integer default null not serialized, "},
{" thread_id integer unsigned default null not serialized, "},
{" node_id integer unsigned default null not serialized, "},
{" pnid_id integer unsigned default null not serialized, "},
{" host_id integer unsigned no default not null not droppable not serialized, "},
{" ip_address_id char(32) character set iso88591 casespecific default null not serialized, "},
{" sequence_number integer unsigned default null not serialized, "},
{" process_name char(32) character set iso88591 casespecific default null not serialized, "},
{" exec_start_utc_ts timestamp(6) no default not null not droppable not serialized, "},
{" query_id char(" MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific no default not null not droppable not serialized, "},
{" user_name char(256 bytes) character set utf8 casespecific default null not serialized, "},
{" role_name char(256 bytes) character set utf8 casespecific default null not serialized, "},
{" start_priority integer unsigned default null not serialized, "},
{" master_process_id char(64) character set iso88591 casespecific default null not serialized, "},
{" session_id char(108) character set iso88591 casespecific default null not serialized, "},
{" client_name varchar(1024) character set iso88591 casespecific default null not serialized, "},
{" application_name char(130) character set iso88591 casespecific default null not serialized, "},
{" statement_id char(" MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific default null not serialized, "},
{" statement_type char(36) character set iso88591 casespecific default null not serialized, "},
{" statement_subtype char(36) character set iso88591 casespecific default null not serialized, "},
{" submit_utc_ts timestamp(6) default null not serialized, "},
{" compile_start_utc_ts timestamp(6) default null not serialized, "},
{" compile_end_utc_ts timestamp(6) default null not serialized, "},
{" compile_elapsed_time largeint default null not serialized, "},
{" cmp_affinity_num largeint default null not serialized, "},
{" cmp_dop largeint default null not serialized, "},
{" cmp_txn_needed largeint default null not serialized, "},
{" cmp_mandatory_x_prod largeint default null not serialized, "},
{" cmp_missing_stats largeint default null not serialized, "},
{" cmp_num_joins largeint default null not serialized, "},
{" cmp_full_scan_on_table largeint default null not serialized, "},
{" cmp_rows_accessed_full_scan double precision default null not serialized, "},
{" est_accessed_rows double precision default null not serialized, "},
{" est_used_rows double precision default null not serialized, "},
{" cmp_compiler_id char(28) character set iso88591 casespecific default null not serialized, "},
{" cmp_cpu_path_length largeint default null not serialized, "},
{" cmp_cpu_binder largeint default null not serialized, "},
{" cmp_cpu_normalizer largeint default null not serialized, "},
{" cmp_cpu_analyzer largeint default null not serialized, "},
{" cmp_cpu_optimizer largeint default null not serialized, "},
{" cmp_cpu_generator largeint default null not serialized, "},
{" cmp_metadata_cache_hits largeint default null not serialized, "},
{" cmp_metadata_cache_lookups largeint default null not serialized, "},
{" cmp_query_cache_status largeint default null not serialized, "},
{" cmp_histogram_cache_hits largeint default null not serialized, "},
{" cmp_histogram_cache_lookups largeint default null not serialized, "},
{" cmp_stmt_heap_size largeint default null not serialized, "},
{" cmp_context_heap_size largeint default null not serialized, "},
{" cmp_optimization_tasks largeint default null not serialized, "},
{" cmp_optimization_contexts largeint default null not serialized, "},
{" cmp_is_recompile smallint default null not serialized, "},
{" est_num_seq_ios double precision default null not serialized, "},
{" est_num_rand_ios double precision default null not serialized, "},
{" est_cost double precision default null not serialized, "},
{" est_cardinality double precision default null not serialized, "},
{" est_io_time double precision default null not serialized, "},
{" est_msg_time double precision default null not serialized, "},
{" est_idle_time double precision default null not serialized, "},
{" est_cpu_time double precision default null not serialized, "},
{" est_total_time double precision default null not serialized, "},
{" est_total_mem double precision default null not serialized, "},
{" est_resource_usage largeint default null not serialized, "},
{" aggregate_option char(3) character set iso88591 casespecific default null not serialized, "},
{" cmp_number_of_bmos integer default null not serialized, "},
{" cmp_overflow_mode char(10) character set iso88591 casespecific default null not serialized, "},
{" cmp_overflow_size largeint default null not serialized, "},
{" aggregate_total largeint default null not serialized, "},
{" stats_error_code integer default null not serialized, "},
{" query_elapsed_time largeint default null not serialized, "},
{" sql_process_busy_time largeint default null not serialized, "},
{" disk_process_busy_time largeint default null not serialized, "},
{" disk_ios largeint default null not serialized, "},
{" num_sql_processes largeint default null not serialized, "},
{" sql_space_allocated largeint default null not serialized, "},
{" sql_space_used largeint default null not serialized, "},
{" sql_heap_allocated largeint default null not serialized, "},
{" sql_heap_used largeint default null not serialized, "},
{" total_mem_alloc largeint default null not serialized, "},
{" max_mem_used largeint default null not serialized, "},
{" transaction_id char(25) character set iso88591 casespecific default null not serialized, "},
{" num_request_msgs largeint default null not serialized, "},
{" num_request_msg_bytes largeint default null not serialized, "},
{" num_reply_msgs largeint default null not serialized, "},
{" num_reply_msg_bytes largeint default null not serialized, "},
{" first_result_return_utc_ts timestamp(6) default null not serialized, "},
{" rows_returned_to_master largeint default null not serialized, "},
{" parent_query_id char(" MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific default null not serialized, "},
{" parent_system_name char(128) character set iso88591 casespecific default null not serialized, "},
{" exec_end_utc_ts timestamp(6) default null not serialized, "},
{" master_execution_time largeint default null not serialized, "},
{" master_elapsed_time largeint default null not serialized, "},
{" error_code integer default null not serialized, "},
{" sql_error_code integer default null not serialized, "},
{" error_text varchar(2000) character set utf8 casespecific default null not serialized, "},
{" query_text varchar(50000) character set utf8 casespecific default null not serialized, "},
{" explain_plan varchar(50000) character set utf8 casespecific default null not serialized, "},
{" last_error_before_aqr integer default null not serialized, "},
{" delay_time_before_aqr_sec largeint default null not serialized, "},
{" total_num_aqr_retries largeint default null not serialized, "},
{" msg_bytes_to_disk largeint default null not serialized, "},
{" msgs_to_disk largeint default null not serialized, "},
{" rows_accessed largeint default null not serialized, "},
{" rows_retrieved largeint default null not serialized, "},
{" num_rows_iud largeint default null not serialized, "},
{" processes_created largeint default null not serialized, "},
{" process_create_busy_time largeint default null not serialized, "},
{" ovf_file_count largeint default null not serialized, "},
{" ovf_space_allocated largeint default null not serialized, "},
{" ovf_space_used largeint default null not serialized, "},
{" ovf_block_size largeint default null not serialized, "},
{" ovf_write_read_count largeint default null not serialized, "},
{" ovf_write_count largeint default null not serialized, "},
{" ovf_buffer_blocks_written largeint default null not serialized, "},
{" ovf_buffer_bytes_written largeint default null not serialized, "},
{" ovf_read_count largeint default null not serialized, "},
{" ovf_buffer_blocks_read largeint default null not serialized, "},
{" ovf_buffer_bytes_read largeint default null not serialized, "},
{" num_nodes largeint default null not serialized, "},
{" udr_process_busy_time largeint default null not serialized, "},
{" pertable_stats integer default null not serialized "},
{" "},
{" ) "},
{" primary key ( exec_start_utc_ts, query_id ) "},
{" ; "}
};
static const QString createOldv23ReposMetricSessionTable[] =
{
{" create table %s.\"%s\"." TRAF_METRIC_SESSION_TABLE_OLD_REPOS" "},
{" ( "},
{" instance_id integer unsigned no default not null not droppable not serialized, "},
{" tenant_id integer unsigned no default not null not droppable not serialized, "},
{" component_id integer unsigned default null not serialized, "},
{" process_id integer default null not serialized, "},
{" thread_id integer unsigned default null not serialized, "},
{" node_id integer unsigned default null not serialized, "},
{" pnid_id integer unsigned default null not serialized, "},
{" host_id integer unsigned no default not null not droppable not serialized, "},
{" ip_address_id char(32) character set iso88591 casespecific default null not serialized, "},
{" sequence_number integer unsigned default null not serialized, "},
{" process_name char(32) character set iso88591 casespecific default null not serialized, "},
{" session_id char(108) character set iso88591 casespecific no default not null not droppable not serialized, "},
{" session_status char(5) character set iso88591 casespecific default null not serialized, "},
{" session_start_utc_ts timestamp(6) default null not serialized, "},
{" session_end_utc_ts timestamp(6) default null not serialized, "},
{" user_id largeint default null not serialized, "},
{" user_name char(256 bytes) character set utf8 casespecific default null not serialized, "},
{" role_name char(256 bytes) character set utf8 casespecific default null not serialized, "},
{" client_name varchar(256) character set utf8 casespecific default null not serialized, "},
{" client_user_name char(256 bytes) character set utf8 casespecific default null not serialized, "},
{" application_name char(130) character set iso88591 casespecific default null not serialized, "},
{" total_execution_time largeint default null not serialized, "},
{" total_elapsed_time largeint default null not serialized, "},
{" total_insert_stmts_executed largeint default null not serialized, "},
{" total_delete_stmts_executed largeint default null not serialized, "},
{" total_update_stmts_executed largeint default null not serialized, "},
{" total_select_stmts_executed largeint default null not serialized, "},
{" total_catalog_stmts largeint default null not serialized, "},
{" total_prepares largeint default null not serialized, "},
{" total_executes largeint default null not serialized, "},
{" total_fetches largeint default null not serialized, "},
{" total_closes largeint default null not serialized, "},
{" total_execdirects largeint default null not serialized, "},
{" total_errors largeint default null not serialized, "},
{" total_warnings largeint default null not serialized, "},
{" total_login_elapsed_time_mcsec largeint default null not serialized, "},
{" ldap_login_elapsed_time_mcsec largeint default null not serialized, "},
{" sql_user_elapsed_time_mcsec largeint default null not serialized, "},
{" search_connection_elapsed_time_mcsec largeint default null not serialized, "},
{" search_elapsed_time_mcsec largeint default null not serialized, "},
{" authentication_connection_elapsed_time_mcsec largeint default null not serialized, "},
{" authentication_elapsed_time_mcsec largeint default null not serialized "},
{" ) "},
{" primary key ( session_id ) salt using 8 partitions "},
{" ; "},
};
//----------------------------------------------------------------
//- Old METRIC_QUERY_AGGREGATION_TABLE
//----------------------------------------------------------------
static const QString createOldv23ReposMetricQueryAggrTable[] =
{
{" create table %s.\"%s\"." TRAF_METRIC_QUERY_AGGR_TABLE_OLD_REPOS" "},
{" ( "},
{" instance_id integer unsigned no default not null not droppable not serialized, "},
{" tenant_id integer unsigned no default not null not droppable not serialized, "},
{" component_id integer unsigned default null not serialized, "},
{" process_id integer default null not serialized, "},
{" thread_id integer unsigned default null not serialized, "},
{" node_id integer unsigned default null not serialized, "},
{" pnid_id integer unsigned default null not serialized, "},
{" host_id integer unsigned no default not null not droppable not serialized, "},
{" ip_address_id char(32) character set iso88591 casespecific default null not serialized, "},
{" sequence_number integer unsigned default null not serialized, "},
{" process_name char(32) character set iso88591 casespecific default null not serialized, "},
{" session_id char(108) character set iso88591 casespecific no default not null not droppable not serialized, "},
{" aggregation_start_utc_ts timestamp(6) no default not null not droppable not serialized, "},
{" aggregation_end_utc_ts timestamp(6) default null not serialized, "},
{" user_id largeint default null not serialized, "},
{" user_name char(256 bytes) character set utf8 casespecific default null not serialized, "},
{" role_name char(256 bytes) character set utf8 casespecific default null not serialized, "},
{" client_name varchar(256) character set utf8 casespecific default null not serialized, "},
{" client_user_name char(256 bytes) character set utf8 casespecific default null not serialized, "},
{" application_name char(130) character set iso88591 casespecific default null not serialized, "},
{" total_est_rows_accessed largeint default null not serialized, "},
{" total_est_rows_used largeint default null not serialized, "},
{" total_rows_retrieved largeint default null not serialized, "},
{" total_num_rows_iud largeint default null not serialized, "},
{" total_selects largeint default null not serialized, "},
{" total_inserts largeint default null not serialized, "},
{" total_updates largeint default null not serialized, "},
{" total_deletes largeint default null not serialized, "},
{" delta_estimated_rows_accessed largeint default null not serialized, "},
{" delta_estimated_rows_used largeint default null not serialized, "},
{" delta_rows_accessed largeint default null not serialized, "},
{" delta_rows_retrieved largeint default null not serialized, "},
{" delta_num_rows_uid largeint default null not serialized, "},
{" delta_total_selects largeint default null not serialized, "},
{" delta_total_inserts largeint default null not serialized, "},
{" delta_total_updates largeint default null not serialized, "},
{" delta_total_deletes largeint default null not serialized "},
{" ) "},
{" primary key ( aggregation_start_utc_ts, session_id ) salt using 8 partitions "},
{" ; "}
};
static const MDUpgradeInfo allReposUpgradeInfo[] = {
// TRAF_METRIC_QUERY_TABLE
{ REPOS_METRIC_QUERY_TABLE, TRAF_METRIC_QUERY_TABLE_OLD_REPOS,
createMetricQueryTable, sizeof(createMetricQueryTable),
createOldTrafv11MetricQueryTable, sizeof(createOldTrafv11MetricQueryTable),
NULL, 0,
TRUE,
// new table columns
"instance_id,"
"tenant_id,"
"component_id,"
"process_id,"
"thread_id,"
"node_id,"
"pnid_id,"
"host_id,"
"ip_address_id,"
"sequence_number,"
"process_name,"
"exec_start_utc_ts,"
"query_id,"
"query_signature_id,"
"user_name,"
"role_name,"
"start_priority,"
"master_process_id,"
"session_id,"
"client_name,"
"application_name,"
"statement_id,"
"statement_type,"
"statement_subtype,"
"submit_utc_ts,"
"compile_start_utc_ts,"
"compile_end_utc_ts,"
"compile_elapsed_time,"
"cmp_affinity_num,"
"cmp_dop,"
"cmp_txn_needed,"
"cmp_mandatory_x_prod,"
"cmp_missing_stats,"
"cmp_num_joins,"
"cmp_full_scan_on_table,"
"cmp_rows_accessed_full_scan,"
"est_accessed_rows,"
"est_used_rows,"
"cmp_compiler_id,"
"cmp_cpu_path_length,"
"cmp_cpu_binder,"
"cmp_cpu_normalizer,"
"cmp_cpu_analyzer,"
"cmp_cpu_optimizer,"
"cmp_cpu_generator,"
"cmp_metadata_cache_hits,"
"cmp_metadata_cache_lookups,"
"cmp_query_cache_status,"
"cmp_histogram_cache_hits,"
"cmp_histogram_cache_lookups,"
"cmp_stmt_heap_size,"
"cmp_context_heap_size,"
"cmp_optimization_tasks,"
"cmp_optimization_contexts,"
"cmp_is_recompile,"
"est_num_seq_ios,"
"est_num_rand_ios,"
"est_cost,"
"est_cardinality,"
"est_io_time,"
"est_msg_time,"
"est_idle_time,"
"est_cpu_time,"
"est_total_time,"
"est_total_mem,"
"est_resource_usage,"
"aggregate_option,"
"cmp_number_of_bmos,"
"cmp_overflow_mode,"
"cmp_overflow_size,"
"aggregate_total,"
"stats_error_code,"
"query_elapsed_time,"
"sql_process_busy_time,"
"disk_process_busy_time,"
"disk_ios,"
"num_sql_processes,"
"sql_space_allocated,"
"sql_space_used,"
"sql_heap_allocated,"
"sql_heap_used,"
"total_mem_alloc,"
"max_mem_used,"
"transaction_id,"
"num_request_msgs,"
"num_request_msg_bytes,"
"num_reply_msgs,"
"num_reply_msg_bytes,"
"first_result_return_utc_ts,"
"rows_returned_to_master,"
"parent_query_id,"
"parent_system_name,"
"exec_end_utc_ts,"
"master_execution_time,"
"master_elapsed_time,"
"query_status,"
"query_sub_status,"
"error_code,"
"sql_error_code,"
"error_text,"
"query_text,"
"explain_plan,"
"last_error_before_aqr,"
"delay_time_before_aqr_sec,"
"total_num_aqr_retries,"
"msg_bytes_to_disk,"
"msgs_to_disk,"
"rows_accessed,"
"rows_retrieved,"
"num_rows_iud,"
"processes_created,"
"process_create_busy_time,"
"ovf_file_count,"
"ovf_space_allocated,"
"ovf_space_used,"
"ovf_block_size,"
"ovf_write_read_count,"
"ovf_write_count,"
"ovf_buffer_blocks_written,"
"ovf_buffer_bytes_written,"
"ovf_read_count,"
"ovf_buffer_blocks_read,"
"ovf_buffer_bytes_read,"
"num_nodes,"
"udr_process_busy_time,"
"pertable_stats,"
"last_updated_time",
// values from old table to be inserted into new
"instance_id,"
"tenant_id,"
"component_id,"
"process_id,"
"thread_id,"
"node_id,"
"pnid_id,"
"host_id,"
"ip_address_id,"
"sequence_number,"
"process_name,"
"exec_start_utc_ts,"
"query_id,"
"NULL,"
"user_name,"
"role_name,"
"start_priority,"
"master_process_id,"
"session_id,"
"client_name,"
"application_name,"
"statement_id,"
"statement_type,"
"statement_subtype,"
"submit_utc_ts,"
"compile_start_utc_ts,"
"compile_end_utc_ts,"
"compile_elapsed_time,"
"cmp_affinity_num,"
"cmp_dop,"
"cmp_txn_needed,"
"cmp_mandatory_x_prod,"
"cmp_missing_stats,"
"cmp_num_joins,"
"cmp_full_scan_on_table,"
"cmp_rows_accessed_full_scan,"
"est_accessed_rows,"
"est_used_rows,"
"cmp_compiler_id,"
"cmp_cpu_path_length,"
"cmp_cpu_binder,"
"cmp_cpu_normalizer,"
"cmp_cpu_analyzer,"
"cmp_cpu_optimizer,"
"cmp_cpu_generator,"
"cmp_metadata_cache_hits,"
"cmp_metadata_cache_lookups,"
"cmp_query_cache_status,"
"cmp_histogram_cache_hits,"
"cmp_histogram_cache_lookups,"
"cmp_stmt_heap_size,"
"cmp_context_heap_size,"
"cmp_optimization_tasks,"
"cmp_optimization_contexts,"
"cmp_is_recompile,"
"est_num_seq_ios,"
"est_num_rand_ios,"
"est_cost,"
"est_cardinality,"
"est_io_time,"
"est_msg_time,"
"est_idle_time,"
"est_cpu_time,"
"est_total_time,"
"est_total_mem,"
"est_resource_usage,"
"aggregate_option,"
"cmp_number_of_bmos,"
"cmp_overflow_mode,"
"cmp_overflow_size,"
"aggregate_total,"
"stats_error_code,"
"query_elapsed_time,"
"sql_process_busy_time,"
"disk_process_busy_time,"
"disk_ios,"
"num_sql_processes,"
"sql_space_allocated,"
"sql_space_used,"
"sql_heap_allocated,"
"sql_heap_used,"
"total_mem_alloc,"
"max_mem_used,"
"transaction_id,"
"num_request_msgs,"
"num_request_msg_bytes,"
"num_reply_msgs,"
"num_reply_msg_bytes,"
"first_result_return_utc_ts,"
"rows_returned_to_master,"
"parent_query_id,"
"parent_system_name,"
"exec_end_utc_ts,"
"master_execution_time,"
"master_elapsed_time,"
"query_status,"
"query_sub_status,"
"error_code,"
"sql_error_code,"
"error_text,"
"query_text,"
"explain_plan,"
"last_error_before_aqr,"
"delay_time_before_aqr_sec,"
"total_num_aqr_retries,"
"msg_bytes_to_disk,"
"msgs_to_disk,"
"rows_accessed,"
"rows_retrieved,"
"num_rows_iud,"
"processes_created,"
"process_create_busy_time,"
"ovf_file_count,"
"ovf_space_allocated,"
"ovf_space_used,"
"ovf_block_size,"
"ovf_write_read_count,"
"ovf_write_count,"
"ovf_buffer_blocks_written,"
"ovf_buffer_bytes_written,"
"ovf_read_count,"
"ovf_buffer_blocks_read,"
"ovf_buffer_bytes_read,"
"num_nodes,"
"udr_process_busy_time,"
"pertable_stats,"
"NULL",
NULL, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE},
// REPOS_METRIC_SESSION_TABLE
{ REPOS_METRIC_SESSION_TABLE, TRAF_METRIC_SESSION_TABLE_OLD_REPOS,
createMetricSessionTable, sizeof(createMetricSessionTable),
createOldTrafv11MetricSessionTable, sizeof(createOldTrafv11MetricSessionTable),
NULL, 0,
TRUE,
// new table columns
"instance_id,"
"tenant_id,"
"component_id,"
"process_id,"
"thread_id,"
"node_id,"
"pnid_id,"
"host_id,"
"ip_address_id,"
"sequence_number,"
"process_name,"
"session_id,"
"session_status,"
"session_start_utc_ts,"
"session_end_utc_ts,"
"user_id,"
"user_name,"
"role_name,"
"client_name,"
"client_user_name,"
"application_name,"
"profile_name,"
"sla_name,"
"total_execution_time,"
"total_elapsed_time,"
"total_insert_stmts_executed,"
"total_delete_stmts_executed,"
"total_update_stmts_executed,"
"total_select_stmts_executed,"
"total_catalog_stmts,"
"total_executes,"
"total_fetches,"
"total_closes,"
"total_execdirects,"
"total_errors,"
"total_warnings,"
"total_login_elapsed_time_mcsec,"
"ldap_login_elapsed_time_mcsec,"
"sql_user_elapsed_time_mcsec,"
"search_connection_elapsed_time_mcsec,"
"search_elapsed_time_mcsec,"
"authentication_connection_elapsed_time_mcsec,"
"authentication_elapsed_time_mcsec",
// values from old table to be inserted into new
"instance_id,"
"tenant_id,"
"component_id,"
"process_id,"
"thread_id,"
"node_id,"
"pnid_id,"
"host_id,"
"ip_address_id,"
"sequence_number,"
"process_name,"
"session_id,"
"session_status,"
"session_start_utc_ts,"
"session_end_utc_ts,"
"user_id,"
"user_name,"
"role_name,"
"client_name,"
"client_user_name,"
"application_name,"
"NULL,"
"NULL,"
"total_execution_time,"
"total_elapsed_time,"
"total_insert_stmts_executed,"
"total_delete_stmts_executed,"
"total_update_stmts_executed,"
"total_select_stmts_executed,"
"total_catalog_stmts,"
"total_executes,"
"total_fetches,"
"total_closes,"
"total_execdirects,"
"total_errors,"
"total_warnings,"
"total_login_elapsed_time_mcsec,"
"ldap_login_elapsed_time_mcsec,"
"sql_user_elapsed_time_mcsec,"
"search_connection_elapsed_time_mcsec,"
"search_elapsed_time_mcsec,"
"authentication_connection_elapsed_time_mcsec,"
"authentication_elapsed_time_mcsec",
NULL, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE},
// REPOS_METRIC_QUERY_AGGR_TABLE
{ REPOS_METRIC_QUERY_AGGR_TABLE, TRAF_METRIC_QUERY_AGGR_TABLE_OLD_REPOS,
createMetricQueryAggrTable, sizeof(createMetricQueryAggrTable),
createOldTrafv11MetricQueryAggrTable, sizeof(createOldTrafv11MetricQueryAggrTable),
NULL, 0,
TRUE,
// new table columns
"instance_id, tenant_id, component_id, process_id, thread_id, node_id, pnid_id, host_id,"
"ip_address_id, sequence_number, process_name, session_id, "
"session_start_utc_ts, aggregation_last_update_utc_ts, aggregation_last_elapsed_time,"
"user_id, user_name, role_name, client_name, client_user_name,"
"application_name, total_est_rows_accessed, total_est_rows_used, total_rows_retrieved,"
"total_num_rows_iud, total_selects, total_inserts, total_updates, total_deletes,"
"total_ddl_stmts, total_util_stmts, total_catalog_stmts, total_other_stmts, "
"total_insert_errors, total_delete_errors, total_update_errors, total_select_errors, "
"total_ddl_errors, total_util_errors, total_catalog_errors, total_other_errors, "
"delta_estimated_rows_accessed, delta_estimated_rows_used, delta_rows_accessed,"
"delta_rows_retrieved, delta_num_rows_iud, "
"delta_selects, delta_inserts, delta_updates, delta_deletes,"
"delta_ddl_stmts, delta_util_stmts, delta_catalog_stmts, delta_other_stmts, "
"delta_insert_errors, delta_delete_errors, delta_update_errors, delta_select_errors, "
"delta_ddl_errors, delta_util_errors, delta_catalog_errors, delta_other_errors, "
"average_response_time, throughput_per_second ",
// values from old table to be inserted into new
"instance_id, tenant_id, component_id, process_id, thread_id, node_id, pnid_id, host_id,"
"ip_address_id, sequence_number, process_name, session_id, "
"session_start_utc_ts, aggregation_last_update_utc_ts, aggregation_last_elapsed_time,"
"user_id, user_name, role_name, client_name, client_user_name,"
"application_name, total_est_rows_accessed, total_est_rows_used, total_rows_retrieved,"
"total_num_rows_iud, total_selects, total_inserts, total_updates, total_deletes,"
"total_ddl_stmts, total_util_stmts, total_catalog_stmts, total_other_stmts, "
"total_insert_errors, total_delete_errors, total_update_errors, total_select_errors, "
"total_ddl_errors, total_util_errors, total_catalog_errors, total_other_errors, "
"delta_estimated_rows_accessed, delta_estimated_rows_used, delta_rows_accessed,"
"delta_rows_retrieved, delta_num_rows_iud, "
"delta_selects, delta_inserts, delta_updates, delta_deletes,"
"delta_ddl_stmts, delta_util_stmts, delta_catalog_stmts, delta_other_stmts, "
"delta_insert_errors, delta_delete_errors, delta_update_errors, delta_select_errors, "
"delta_ddl_errors, delta_util_errors, delta_catalog_errors, delta_other_errors, "
"NULL, NULL",
NULL, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE},
// REPOS_METRIC_TEXT_TABLE
{ REPOS_METRIC_TEXT_TABLE, NULL,
createMetricTextTable, sizeof(createMetricTextTable),
NULL, 0,
NULL, 0,
FALSE, NULL, NULL, NULL, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE}
};
#endif