Migrating multidimensional clustered (MDC) tables

Multidimensional clustering (MDC) provides an efficient method for clustering data in tables along multiple dimensions in a flexible, continuous, and automatic way. MDC can significantly improve the query performance of the console repository. This improvement is available from Db2® Data Management Console version 3.1.5.1 and higher.

About this task

This task is about migrating the data from the source tables to MDC tables.

Procedure

  1. Stop the service of IBM® Db2 Data Management Console. 
    /ibm-datamgmtconsole/bin/stop.sh
  2. Ensure that the following MDC tables are created in the repository.
    Db2 Data Management Console v3.1.5.1
    {schema}.BUFFERPOOL_MDC 
{schema}."tableperformance_mdc" 
{schema}.EVENT_ACTIVITY_MDC 
{schema}.TABLESPACE_MDC
    Db2 Data Management Console v3.1.6
    {schema}."sessions_mdc"
{schema}.LOCKS_MDC
{schema}.TABLESTORAGE_MDC
{schema}.SQL_FACT_MDC
    Db2 Data Management Console v3.1.7
    {schema}."unitsOfWorks"
    Note: When you upgrade Db2 Data Management Console to version 3.1.5.1 from 3.1.5 or earlier versions or migrate from Data Server Manager, the MDC tables are automatically created. When you perform new installation of Db2 Data Management Console 3.1.5.1 or later and manually configure the repository database that has the schema definition of the earlier version of Db2 Data Management Console, MDC tables might not be created.
    If MDC tables are not created after upgrading to Db2 Data Management Console 3.1.5.1 or later, you can manually upgrade the repository by running the following command:
    sh ./dsutil/bin/setupRepo.sh -c setupRepo --external
  3. If you do not have historical data that needs to be migrated from Db2 Data Management Console 3.1.5 or earlier versions to MDC table, you can skip this step.
    Use the following sql scripts to clone data from the source table to MDC-related table.
    Note: After you clone the data from the source table to MDC-related table, you can safely truncate the data in the non-MDC copies of the tables.
    connect to <dmc_repository>;
CALL SYSPROC.ADMIN_CMD('LOAD FROM (select DBCONN_INT, COLLECTED, timestamp, LEVEL_TAG, TABSCHEMA, TABNAME, TAB_TYPE, TBSP_NAME, TABLE_SCANS, ROWS_READ, ROWS_INSERTED, ROWS_UPDATED, ROWS_DELETED, LOGICAL_READS, PHYSICAL_READS, LBP_PAGES_FOUND, DATA_OBJECT_L_PAGES, INDEX_OBJECT_L_PAGES, XDA_OBJECT_L_PAGES, LOB_OBJECT_L_PAGES, LONG_OBJECT_L_PAGES, MEMBER, ACCESSES, OVERFLOW_ACCESSES, OVERFLOW_CREATES, COL_OBJECT_L_PAGES, TOTAL_PHYSICAL_SIZE_KB, LASTUSED from <repository_schema_name>."tableperformance" WITH UR ) OF CURSOR REPLACE INTO <repository_schema_name>."tableperformance_mdc"(DBCONN_INT, COLLECTED, timestamp, LEVEL_TAG, TABSCHEMA, TABNAME, TAB_TYPE, TBSP_NAME, TABLE_SCANS, ROWS_READ, ROWS_INSERTED, ROWS_UPDATED, ROWS_DELETED, LOGICAL_READS, PHYSICAL_READS, LBP_PAGES_FOUND, DATA_OBJECT_L_PAGES, INDEX_OBJECT_L_PAGES, XDA_OBJECT_L_PAGES, LOB_OBJECT_L_PAGES, LONG_OBJECT_L_PAGES, MEMBER, ACCESSES, OVERFLOW_ACCESSES, OVERFLOW_CREATES, COL_OBJECT_L_PAGES, TOTAL_PHYSICAL_SIZE_KB, LASTUSED) NONRECOVERABLE');
CALL SYSPROC.ADMIN_CMD('LOAD FROM (select dbconn_int, timestamp, level_tag, startbatchcollected, bp_name, member, pool_data_l_reads, pool_data_p_reads, pool_temp_data_l_reads, pool_temp_data_p_reads, pool_index_l_reads, pool_index_p_reads, pool_temp_index_l_reads, pool_temp_index_p_reads, pool_xda_l_reads, pool_xda_p_reads, pool_temp_xda_l_reads, pool_temp_xda_p_reads, pool_data_writes, pool_xda_writes, pool_index_writes, direct_read_time, direct_write_time, pool_async_data_reads, pool_async_index_reads, pool_async_xda_reads, direct_reads, direct_writes, pool_data_lbp_pages_found, pool_index_lbp_pages_found, pool_async_data_lbp_pages_found, pool_async_index_lbp_pages_found, pool_xda_lbp_pages_found, pool_async_xda_lbp_pages_found, pool_col_l_reads, pool_col_p_reads, pool_temp_col_l_reads, pool_temp_col_p_reads, pool_col_lbp_pages_found, pool_async_col_lbp_pages_found, pool_col_writes, bp_cur_buffsz, unread_prefetch_pages, prefetch_wait_time, prefetch_waits, pool_async_col_reads, pool_read_time, pool_async_data_writes, pool_async_index_writes, pool_async_xda_writes, pool_async_col_writes, bp_hit_ratio, async_read_ratio, pagesize, self_tuning_enabled, pool_queued_async_data_pages, pool_queued_async_index_pages, pool_queued_async_xda_pages, pool_queued_async_col_pages, pool_queued_async_temp_data_pages, pool_queued_async_temp_index_pages, pool_queued_async_temp_xda_pages, pool_queued_async_temp_col_pages, pool_queued_async_data_reqs, pool_queued_async_index_reqs, pool_queued_async_xda_reqs, pool_queued_async_col_reqs, pool_queued_async_temp_data_reqs, pool_queued_async_temp_index_reqs, pool_queued_async_temp_xda_reqs, pool_queued_async_temp_col_reqs from <repository_schema_name>.BUFFERPOOL WITH UR ) OF CURSOR REPLACE INTO <repository_schema_name>.BUFFERPOOL_MDC(dbconn_int, timestamp, level_tag, startbatchcollected, bp_name, member, pool_data_l_reads, pool_data_p_reads, pool_temp_data_l_reads, pool_temp_data_p_reads, pool_index_l_reads, pool_index_p_reads, pool_temp_index_l_reads, pool_temp_index_p_reads, pool_xda_l_reads, pool_xda_p_reads, pool_temp_xda_l_reads, pool_temp_xda_p_reads, pool_data_writes, pool_xda_writes, pool_index_writes, direct_read_time, direct_write_time, pool_async_data_reads, pool_async_index_reads, pool_async_xda_reads, direct_reads, direct_writes, pool_data_lbp_pages_found, pool_index_lbp_pages_found, pool_async_data_lbp_pages_found, pool_async_index_lbp_pages_found, pool_xda_lbp_pages_found, pool_async_xda_lbp_pages_found, pool_col_l_reads, pool_col_p_reads, pool_temp_col_l_reads, pool_temp_col_p_reads, pool_col_lbp_pages_found, pool_async_col_lbp_pages_found, pool_col_writes, bp_cur_buffsz, unread_prefetch_pages, prefetch_wait_time, prefetch_waits, pool_async_col_reads, pool_read_time, pool_async_data_writes, pool_async_index_writes, pool_async_xda_writes, pool_async_col_writes, bp_hit_ratio, async_read_ratio, pagesize, self_tuning_enabled, pool_queued_async_data_pages, pool_queued_async_index_pages, pool_queued_async_xda_pages, pool_queued_async_col_pages, pool_queued_async_temp_data_pages, pool_queued_async_temp_index_pages, pool_queued_async_temp_xda_pages, pool_queued_async_temp_col_pages, pool_queued_async_data_reqs, pool_queued_async_index_reqs, pool_queued_async_xda_reqs, pool_queued_async_col_reqs, pool_queued_async_temp_data_reqs, pool_queued_async_temp_index_reqs, pool_queued_async_temp_xda_reqs, pool_queued_async_temp_col_reqs) NONRECOVERABLE');
CALL SYSPROC.ADMIN_CMD('LOAD FROM (select dbconn_int, collected, timestamp, level_tag, sql_hash_id, sql_text_summary, activity_id, activity_secondary_id, agent_id, uow_id, member, appl_id, planid, appl_name, session_auth_id, tpmon_acc_str, tpmon_client_app, tpmon_client_userid, tpmon_client_wkstn, address, time_started, time_completed, wlm_queue_assignments_total, wlm_queue_time_total, rows_read, rows_returned, rows_modified, pool_data_l_reads, pool_index_l_reads, pool_xda_l_reads, pool_col_l_reads, pool_temp_data_l_reads, pool_temp_index_l_reads, pool_temp_xda_l_reads, pool_temp_col_l_reads, pool_data_p_reads, pool_index_p_reads, pool_xda_p_reads, pool_col_p_reads, pool_temp_data_p_reads, pool_temp_index_p_reads, pool_temp_xda_p_reads, pool_temp_col_p_reads, query_cost_estimate, query_card_estimate, query_actual_degree, workload_id, service_superclass_name, service_subclass_name, sc_work_action_set_id, sc_work_class_id, db_work_action_set_id, db_work_class_id, sqlcode, sqlwarn, activity_type, post_shrthreshold_sorts, post_threshold_sorts, total_routine_invocations, total_sorts, total_hash_joins, total_hash_loops, hash_join_overflows, hash_join_small_overflows, post_shrthreshold_hash_joins, post_threshold_hash_joins, total_olap_funcs, olap_func_overflows, coord_partition_num, partial_record, direct_reads, direct_write_time, direct_writes, executable_id, fcm_recv_volume, fcm_recv_wait_time, fcm_send_volume, fcm_send_wait_time, fcm_tq_recvs_total, fcm_tq_sends_total, lock_escals, lock_timeouts, lock_wait_time, lock_waits, log_buffer_wait_time, log_disk_wait_time, log_disk_waits_total, pool_data_writes, pool_index_writes, pool_read_time, pool_xda_writes, prep_time, routine_id, sort_overflows, stmt_exec_time, stmt_isolation, thresh_violations, total_act_wait_time, total_cpu_time, total_routine_user_code_proc_time, total_section_proc_time, total_section_sort_proc_time, total_section_sort_time, tq_tot_send_spills, workloadname, fed_wait_time, fed_rows_deleted, fed_rows_inserted, fed_rows_updated, fed_rows_read, fed_waits_total, stmtid, semantic_env_id, adm_resource_actuals, adm_bypassed, effective_query_degree, estimated_runtime, estimated_sort_shrheap_top, sort_shrheap_top, client_idle_wait_time, post_threshold_col_vector_consumers, pool_write_time, prefetch_wait_time, coord_stmt_exec_time, num_agents, agents_top, package_name, package_schema, section_number, COMPILATION_SCHEMA, stmt_type from <repository_schema_name>.event_activity WITH UR ) OF CURSOR REPLACE INTO <repository_schema_name>.event_activity_mdc(dbconn_int, collected, timestamp, level_tag, sql_hash_id, sql_text_summary, activity_id, activity_secondary_id, agent_id, uow_id, member, appl_id, planid, appl_name, session_auth_id, tpmon_acc_str, tpmon_client_app, tpmon_client_userid, tpmon_client_wkstn, address, time_started, time_completed, wlm_queue_assignments_total, wlm_queue_time_total, rows_read, rows_returned, rows_modified, pool_data_l_reads, pool_index_l_reads, pool_xda_l_reads, pool_col_l_reads, pool_temp_data_l_reads, pool_temp_index_l_reads, pool_temp_xda_l_reads, pool_temp_col_l_reads, pool_data_p_reads, pool_index_p_reads, pool_xda_p_reads, pool_col_p_reads, pool_temp_data_p_reads, pool_temp_index_p_reads, pool_temp_xda_p_reads, pool_temp_col_p_reads, query_cost_estimate, query_card_estimate, query_actual_degree, workload_id, service_superclass_name, service_subclass_name, sc_work_action_set_id, sc_work_class_id, db_work_action_set_id, db_work_class_id, sqlcode, sqlwarn, activity_type, post_shrthreshold_sorts, post_threshold_sorts, total_routine_invocations, total_sorts, total_hash_joins, total_hash_loops, hash_join_overflows, hash_join_small_overflows, post_shrthreshold_hash_joins, post_threshold_hash_joins, total_olap_funcs, olap_func_overflows, coord_partition_num, partial_record, direct_reads, direct_write_time, direct_writes, executable_id, fcm_recv_volume, fcm_recv_wait_time, fcm_send_volume, fcm_send_wait_time, fcm_tq_recvs_total, fcm_tq_sends_total, lock_escals, lock_timeouts, lock_wait_time, lock_waits, log_buffer_wait_time, log_disk_wait_time, log_disk_waits_total, pool_data_writes, pool_index_writes, pool_read_time, pool_xda_writes, prep_time, routine_id, sort_overflows, stmt_exec_time, stmt_isolation, thresh_violations, total_act_wait_time, total_cpu_time, total_routine_user_code_proc_time, total_section_proc_time, total_section_sort_proc_time, total_section_sort_time, tq_tot_send_spills, workloadname, fed_wait_time, fed_rows_deleted, fed_rows_inserted, fed_rows_updated, fed_rows_read, fed_waits_total, stmtid, semantic_env_id, adm_resource_actuals, adm_bypassed, effective_query_degree, estimated_runtime, estimated_sort_shrheap_top, sort_shrheap_top, client_idle_wait_time, post_threshold_col_vector_consumers, pool_write_time, prefetch_wait_time, coord_stmt_exec_time, num_agents, agents_top, package_name, package_schema, section_number, COMPILATION_SCHEMA, stmt_type) NONRECOVERABLE');
CALL SYSPROC.ADMIN_CMD('LOAD FROM (select DBCONN_INT, TIMESTAMP, LEVEL_TAG, STARTBATCHCOLLECTED, TBSP_NAME, MEMBER, POOL_DATA_L_READS, POOL_DATA_P_READS, POOL_TEMP_DATA_L_READS, POOL_TEMP_DATA_P_READS, POOL_INDEX_L_READS, POOL_INDEX_P_READS, POOL_TEMP_INDEX_L_READS, POOL_TEMP_INDEX_P_READS, POOL_XDA_L_READS, POOL_XDA_P_READS, POOL_TEMP_XDA_L_READS, POOL_TEMP_XDA_P_READS, POOL_DATA_WRITES, POOL_XDA_WRITES, POOL_INDEX_WRITES, DIRECT_READ_TIME, DIRECT_WRITE_TIME, POOL_ASYNC_DATA_READS, POOL_ASYNC_INDEX_READS, POOL_ASYNC_XDA_READS, DIRECT_READS, DIRECT_WRITES, POOL_DATA_LBP_PAGES_FOUND, POOL_INDEX_LBP_PAGES_FOUND, POOL_ASYNC_DATA_LBP_PAGES_FOUND, POOL_ASYNC_INDEX_LBP_PAGES_FOUND, POOL_XDA_LBP_PAGES_FOUND, POOL_ASYNC_XDA_LBP_PAGES_FOUND, POOL_QUEUED_ASYNC_DATA_PAGES, POOL_QUEUED_ASYNC_INDEX_PAGES, POOL_QUEUED_ASYNC_XDA_PAGES, POOL_QUEUED_ASYNC_COL_PAGES, POOL_QUEUED_ASYNC_TEMP_DATA_PAGES, POOL_QUEUED_ASYNC_TEMP_INDEX_PAGES, POOL_QUEUED_ASYNC_TEMP_XDA_PAGES, POOL_QUEUED_ASYNC_TEMP_COL_PAGES, POOL_QUEUED_ASYNC_DATA_REQS, POOL_QUEUED_ASYNC_INDEX_REQS, POOL_QUEUED_ASYNC_XDA_REQS, POOL_QUEUED_ASYNC_COL_REQS, POOL_QUEUED_ASYNC_TEMP_DATA_REQS, POOL_QUEUED_ASYNC_TEMP_INDEX_REQS, POOL_QUEUED_ASYNC_TEMP_XDA_REQS, POOL_QUEUED_ASYNC_TEMP_COL_REQS, POOL_COL_L_READS, POOL_COL_P_READS, POOL_TEMP_COL_L_READS, POOL_TEMP_COL_P_READS, POOL_COL_LBP_PAGES_FOUND, POOL_ASYNC_COL_LBP_PAGES_FOUND, POOL_COL_WRITES, BP_NAME, UNREAD_PREFETCH_PAGES, PREFETCH_WAIT_TIME, PREFETCH_WAITS, POOL_ASYNC_COL_READS, POOL_ASYNC_DATA_WRITES, POOL_ASYNC_INDEX_WRITES, POOL_ASYNC_XDA_WRITES, POOL_ASYNC_COL_WRITES, STORAGE_GROUP_NAME from <repository_schema_name>.TABLESPACE WITH UR ) OF CURSOR REPLACE INTO <repository_schema_name>.TABLESPACE_MDC(DBCONN_INT, TIMESTAMP, LEVEL_TAG, STARTBATCHCOLLECTED, TBSP_NAME, MEMBER, POOL_DATA_L_READS, POOL_DATA_P_READS, POOL_TEMP_DATA_L_READS, POOL_TEMP_DATA_P_READS, POOL_INDEX_L_READS, POOL_INDEX_P_READS, POOL_TEMP_INDEX_L_READS, POOL_TEMP_INDEX_P_READS, POOL_XDA_L_READS, POOL_XDA_P_READS, POOL_TEMP_XDA_L_READS, POOL_TEMP_XDA_P_READS, POOL_DATA_WRITES, POOL_XDA_WRITES, POOL_INDEX_WRITES, DIRECT_READ_TIME, DIRECT_WRITE_TIME, POOL_ASYNC_DATA_READS, POOL_ASYNC_INDEX_READS, POOL_ASYNC_XDA_READS, DIRECT_READS, DIRECT_WRITES, POOL_DATA_LBP_PAGES_FOUND, POOL_INDEX_LBP_PAGES_FOUND, POOL_ASYNC_DATA_LBP_PAGES_FOUND, POOL_ASYNC_INDEX_LBP_PAGES_FOUND, POOL_XDA_LBP_PAGES_FOUND, POOL_ASYNC_XDA_LBP_PAGES_FOUND, POOL_QUEUED_ASYNC_DATA_PAGES, POOL_QUEUED_ASYNC_INDEX_PAGES, POOL_QUEUED_ASYNC_XDA_PAGES, POOL_QUEUED_ASYNC_COL_PAGES, POOL_QUEUED_ASYNC_TEMP_DATA_PAGES, POOL_QUEUED_ASYNC_TEMP_INDEX_PAGES, POOL_QUEUED_ASYNC_TEMP_XDA_PAGES, POOL_QUEUED_ASYNC_TEMP_COL_PAGES, POOL_QUEUED_ASYNC_DATA_REQS, POOL_QUEUED_ASYNC_INDEX_REQS, POOL_QUEUED_ASYNC_XDA_REQS, POOL_QUEUED_ASYNC_COL_REQS, POOL_QUEUED_ASYNC_TEMP_DATA_REQS, POOL_QUEUED_ASYNC_TEMP_INDEX_REQS, POOL_QUEUED_ASYNC_TEMP_XDA_REQS, POOL_QUEUED_ASYNC_TEMP_COL_REQS, POOL_COL_L_READS, POOL_COL_P_READS, POOL_TEMP_COL_L_READS, POOL_TEMP_COL_P_READS, POOL_COL_LBP_PAGES_FOUND, POOL_ASYNC_COL_LBP_PAGES_FOUND, POOL_COL_WRITES, BP_NAME, UNREAD_PREFETCH_PAGES, PREFETCH_WAIT_TIME, PREFETCH_WAITS, POOL_ASYNC_COL_READS, POOL_ASYNC_DATA_WRITES, POOL_ASYNC_INDEX_WRITES, POOL_ASYNC_XDA_WRITES, POOL_ASYNC_COL_WRITES, STORAGE_GROUP_NAME) NONRECOVERABLE');
CALL SYSPROC.ADMIN_CMD('LOAD FROM (select DBCONN_INT, COLLECTED, TIMESTAMP, LEVEL_TAG, CURRENT_TIME_UC, APPLICATION_HANDLE, COORD_MEMBER, MEMBER, CONNECTION_START_TIME, UOW_START_TIME, UOW_STOP_TIME, WORKLOAD_OCCURRENCE_STATE, WORKLOAD_NAME, THRESH_VIOLATIONS, WLM_QUEUE_ASSIGNMENTS_TOTAL, MEMORY_POOL_USED, APPLICATION_ID, CLIENT_IPADDR, APPLICATION_NAME, SYSTEM_AUTH_ID, SESSION_AUTH_ID, CLIENT_APPLNAME, CLIENT_WRKSTNNAME, CLIENT_ACCTNG, CLIENT_USERID, CLIENT_HOSTNAME, CLIENT_PID, CLIENT_PLATFORM, CLIENT_PRDID, CLIENT_PORT_NUMBER, SERVICE_SUPERCLASS_NAME, SERVICE_SUBCLASS_NAME, TOTAL_CPU_TIME, TOTAL_ROUTINE_INVOCATIONS, TOTAL_COMPILATIONS, FCM_RECVS_TOTAL, FCM_SENDS_TOTAL, TOTAL_LOADS, TOTAL_REORGS, TOTAL_RUNSTATS, COMPLEX_OPERATIONS, ALL_OVERFLOWS, TOTAL_SORTS, SORT_OVERFLOWS, SORT_SHRHEAP_ALLOCATED_PAGES, MAX_SHRHEAP_ALLOCATED_PER_PART_PERCENT, ESTIMATED_SORT_SHRHEAP_TOP_PAGES, MAX_ESTIMATED_SHRHEAP_PER_PART_PERCENT, SORT_SHRHEAP_TOP_PAGES, MAX_SHRHEAP_PEAK_PER_PART_PERCENT, TOTAL_APP_COMMITS, TOTAL_APP_ROLLBACKS, ACT_COMPLETED_TOTAL, ACT_ABORTED_TOTAL, ACT_REJECTED_TOTAL, DYNAMIC_SQL_STMTS, STATIC_SQL_STMTS, FAILED_SQL_STMTS, SELECT_SQL_STMTS, UID_SQL_STMTS, DDL_SQL_STMTS, MERGE_SQL_STMTS, XQUERY_STMTS, CALL_SQL_STMTS, ROWS_READ, ROWS_MODIFIED, ROWS_RETURNED, LOCK_WAITS, LOCK_WAITS_GLOBAL, LOCK_ESCALS, LOCK_ESCALS_GLOBAL, DEADLOCKS, LOCK_TIMEOUTS, LOCK_TIMEOUTS_GLOBAL, NUM_LOCKS_HELD, CF_WAITS, LOG_DISK_WAITS_TOTAL, NUM_LOG_BUFFER_FULL, UOW_LOG_SPACE_USED, DIRECT_READS, DIRECT_WRITES, FCM_VOLUME, POOL_DATA_L_READS, POOL_INDEX_L_READS, POOL_XDA_L_READS, POOL_COL_L_READS, POOL_DATA_P_READS, POOL_INDEX_P_READS, POOL_XDA_P_READS, POOL_COL_P_READS, POOL_TEMP_DATA_L_READS, POOL_TEMP_INDEX_L_READS, POOL_TEMP_XDA_L_READS, POOL_TEMP_COL_L_READS, POOL_TEMP_DATA_P_READS, POOL_TEMP_INDEX_P_READS, POOL_TEMP_XDA_P_READS, POOL_TEMP_COL_P_READS, POOL_DATA_WRITES, POOL_INDEX_WRITES, POOL_XDA_WRITES, POOL_COL_WRITES, FED_ROWS_DELETED, FED_ROWS_INSERTED, FED_ROWS_UPDATED, FED_ROWS_READ, FED_WAITS_TOTAL, EXT_TABLE_READ_VOLUME, EXT_TABLE_WRITE_VOLUME, EXT_TABLE_SEND_VOLUME, EXT_TABLE_RECV_VOLUME, CLIENT_IDLE_WAIT_TIME, TOTAL_RQST_TIME, TOTAL_COMPILE_PROC_TIME, TOTAL_SECTION_PROC_TIME, TOTAL_SECTION_SORT_PROC_TIME, TOTAL_COL_PROC_TIME, TOTAL_COMMIT_PROC_TIME, TOTAL_ROLLBACK_PROC_TIME, TOTAL_RUNSTATS_PROC_TIME, TOTAL_REORG_PROC_TIME, TOTAL_LOAD_PROC_TIME, TOTAL_WAIT_TIME, AGENT_WAIT_TIME, WLM_QUEUE_TIME_TOTAL, LOCK_WAIT_TIME, LOCK_WAIT_TIME_GLOBAL, LOG_BUFFER_WAIT_TIME, LOG_DISK_WAIT_TIME, TCPIP_WAIT_TIME, FCM_WAIT_TIME, CF_WAIT_TIME, FED_WAIT_TIME, EXT_TABLE_WAIT_TIME, TOTAL_EXTENDED_LATCH_WAIT_TIME, POOL_READ_TIME, POOL_WRITE_TIME, DIRECT_READ_TIME, DIRECT_WRITE_TIME, PREFETCH_WAIT_TIME, TOTAL_COMMIT_TIME, SORT_SHRHEAP_ALLOCATED, NUM_ASSOC_AGENTS, TOTAL_HASH_GRPBYS, TOTAL_HASH_JOINS, TOTAL_OLAP_FUNCS, TOTAL_COL_VECTOR_CONSUMERS, POST_THRESHOLD_HASH_GRPBYS, POST_THRESHOLD_HASH_JOINS, POST_THRESHOLD_OLAP_FUNCS, POST_THRESHOLD_SORTS, POST_THRESHOLD_COL_VECTOR_CONSUMERS, HASH_GRPBY_OVERFLOWS, HASH_JOIN_OVERFLOWS, OLAP_FUNC_OVERFLOWS, COL_VECTOR_CONSUMER_OVERFLOWS, ROWS_INSERTED, ROWS_UPDATED, ROWS_DELETED, DIRECT_READ_REQS, DIRECT_WRITE_REQS, FCM_SEND_VOLUME, FCM_RECV_VOLUME, FCM_MESSAGE_SEND_VOLUME, FCM_MESSAGE_RECV_VOLUME, FCM_TQ_SEND_VOLUME, FCM_TQ_RECV_VOLUME, TQ_TOT_SEND_SPILLS, APP_RQSTS_COMPLETED_TOTAL, TOTAL_ROLLBACK_TIME, TOTAL_DISP_RUN_QUEUE_TIME, TOTAL_ACT_TIME, TOTAL_ACT_WAIT_TIME, LAST_EXECUTABLE_ID, ASSOCIATED_AGENTS_TOP, TCPIP_RECV_WAIT_TIME, TCPIP_SEND_WAIT_TIME, IPC_RECV_WAIT_TIME, IPC_SEND_WAIT_TIME, FCM_RECV_WAIT_TIME, FCM_TQ_RECV_WAIT_TIME, FCM_MESSAGE_RECV_WAIT_TIME, FCM_SEND_WAIT_TIME, FCM_TQ_SEND_WAIT_TIME, FCM_MESSAGE_SEND_WAIT_TIME, AUDIT_SUBSYSTEM_WAIT_TIME, AUDIT_FILE_WRITE_WAIT_TIME, DIAGLOG_WRITE_WAIT_TIME, EVMON_WAIT_TIME, COMM_EXIT_WAIT_TIME, IDA_SEND_WAIT_TIME, IDA_RECV_WAIT_TIME, RECLAIM_WAIT_TIME, SPACEMAPPAGE_RECLAIM_WAIT_TIME, EXT_TABLE_RECV_WAIT_TIME, EXT_TABLE_SEND_WAIT_TIME, LOB_PREFETCH_WAIT_TIME, POOL_CACHING_TIER_PAGE_READ_TIME, POOL_CACHING_TIER_PAGE_WRITE_TIME, TOTAL_SYNC_RUNSTATS_PROC_TIME, TOTAL_STATS_FABRICATION_PROC_TIME, TOTAL_IMPLICIT_COMPILE_PROC_TIME, TOTAL_ROUTINE_USER_CODE_PROC_TIME, TOTAL_COL_SYNOPSIS_PROC_TIME, TOTAL_BACKUP_PROC_TIME, TOTAL_INDEX_BUILD_PROC_TIME, TOTAL_CONNECT_REQUEST_PROC_TIME, TOTAL_CONNECT_AUTHENTICATION_PROC_TIME, SORT_HEAP_ALLOCATED, POST_SHRTHRESHOLD_SORTS, POST_SHRTHRESHOLD_HASH_JOINS, INT_COMMITS, INT_ROLLBACKS from <repository_schema_name>."sessions" WITH UR ) OF CURSOR REPLACE INTO <repository_schema_name>."sessions_mdc"(DBCONN_INT, COLLECTED, TIMESTAMP, LEVEL_TAG, CURRENT_TIME_UC, APPLICATION_HANDLE, COORD_MEMBER, MEMBER, CONNECTION_START_TIME, UOW_START_TIME, UOW_STOP_TIME, WORKLOAD_OCCURRENCE_STATE, WORKLOAD_NAME, THRESH_VIOLATIONS, WLM_QUEUE_ASSIGNMENTS_TOTAL, MEMORY_POOL_USED, APPLICATION_ID, CLIENT_IPADDR, APPLICATION_NAME, SYSTEM_AUTH_ID, SESSION_AUTH_ID, CLIENT_APPLNAME, CLIENT_WRKSTNNAME, CLIENT_ACCTNG, CLIENT_USERID, CLIENT_HOSTNAME, CLIENT_PID, CLIENT_PLATFORM, CLIENT_PRDID, CLIENT_PORT_NUMBER, SERVICE_SUPERCLASS_NAME, SERVICE_SUBCLASS_NAME, TOTAL_CPU_TIME, TOTAL_ROUTINE_INVOCATIONS, TOTAL_COMPILATIONS, FCM_RECVS_TOTAL, FCM_SENDS_TOTAL, TOTAL_LOADS, TOTAL_REORGS, TOTAL_RUNSTATS, COMPLEX_OPERATIONS, ALL_OVERFLOWS, TOTAL_SORTS, SORT_OVERFLOWS, SORT_SHRHEAP_ALLOCATED_PAGES, MAX_SHRHEAP_ALLOCATED_PER_PART_PERCENT, ESTIMATED_SORT_SHRHEAP_TOP_PAGES, MAX_ESTIMATED_SHRHEAP_PER_PART_PERCENT, SORT_SHRHEAP_TOP_PAGES, MAX_SHRHEAP_PEAK_PER_PART_PERCENT, TOTAL_APP_COMMITS, TOTAL_APP_ROLLBACKS, ACT_COMPLETED_TOTAL, ACT_ABORTED_TOTAL, ACT_REJECTED_TOTAL, DYNAMIC_SQL_STMTS, STATIC_SQL_STMTS, FAILED_SQL_STMTS, SELECT_SQL_STMTS, UID_SQL_STMTS, DDL_SQL_STMTS, MERGE_SQL_STMTS, XQUERY_STMTS, CALL_SQL_STMTS, ROWS_READ, ROWS_MODIFIED, ROWS_RETURNED, LOCK_WAITS, LOCK_WAITS_GLOBAL, LOCK_ESCALS, LOCK_ESCALS_GLOBAL, DEADLOCKS, LOCK_TIMEOUTS, LOCK_TIMEOUTS_GLOBAL, NUM_LOCKS_HELD, CF_WAITS, LOG_DISK_WAITS_TOTAL, NUM_LOG_BUFFER_FULL, UOW_LOG_SPACE_USED, DIRECT_READS, DIRECT_WRITES, FCM_VOLUME, POOL_DATA_L_READS, POOL_INDEX_L_READS, POOL_XDA_L_READS, POOL_COL_L_READS, POOL_DATA_P_READS, POOL_INDEX_P_READS, POOL_XDA_P_READS, POOL_COL_P_READS, POOL_TEMP_DATA_L_READS, POOL_TEMP_INDEX_L_READS, POOL_TEMP_XDA_L_READS, POOL_TEMP_COL_L_READS, POOL_TEMP_DATA_P_READS, POOL_TEMP_INDEX_P_READS, POOL_TEMP_XDA_P_READS, POOL_TEMP_COL_P_READS, POOL_DATA_WRITES, POOL_INDEX_WRITES, POOL_XDA_WRITES, POOL_COL_WRITES, FED_ROWS_DELETED, FED_ROWS_INSERTED, FED_ROWS_UPDATED, FED_ROWS_READ, FED_WAITS_TOTAL, EXT_TABLE_READ_VOLUME, EXT_TABLE_WRITE_VOLUME, EXT_TABLE_SEND_VOLUME, EXT_TABLE_RECV_VOLUME, CLIENT_IDLE_WAIT_TIME, TOTAL_RQST_TIME, TOTAL_COMPILE_PROC_TIME, TOTAL_SECTION_PROC_TIME, TOTAL_SECTION_SORT_PROC_TIME, TOTAL_COL_PROC_TIME, TOTAL_COMMIT_PROC_TIME, TOTAL_ROLLBACK_PROC_TIME, TOTAL_RUNSTATS_PROC_TIME, TOTAL_REORG_PROC_TIME, TOTAL_LOAD_PROC_TIME, TOTAL_WAIT_TIME, AGENT_WAIT_TIME, WLM_QUEUE_TIME_TOTAL, LOCK_WAIT_TIME, LOCK_WAIT_TIME_GLOBAL, LOG_BUFFER_WAIT_TIME, LOG_DISK_WAIT_TIME, TCPIP_WAIT_TIME, FCM_WAIT_TIME, CF_WAIT_TIME, FED_WAIT_TIME, EXT_TABLE_WAIT_TIME, TOTAL_EXTENDED_LATCH_WAIT_TIME, POOL_READ_TIME, POOL_WRITE_TIME, DIRECT_READ_TIME, DIRECT_WRITE_TIME, PREFETCH_WAIT_TIME, TOTAL_COMMIT_TIME, SORT_SHRHEAP_ALLOCATED, NUM_ASSOC_AGENTS, TOTAL_HASH_GRPBYS, TOTAL_HASH_JOINS, TOTAL_OLAP_FUNCS, TOTAL_COL_VECTOR_CONSUMERS, POST_THRESHOLD_HASH_GRPBYS, POST_THRESHOLD_HASH_JOINS, POST_THRESHOLD_OLAP_FUNCS, POST_THRESHOLD_SORTS, POST_THRESHOLD_COL_VECTOR_CONSUMERS, HASH_GRPBY_OVERFLOWS, HASH_JOIN_OVERFLOWS, OLAP_FUNC_OVERFLOWS, COL_VECTOR_CONSUMER_OVERFLOWS, ROWS_INSERTED, ROWS_UPDATED, ROWS_DELETED, DIRECT_READ_REQS, DIRECT_WRITE_REQS, FCM_SEND_VOLUME, FCM_RECV_VOLUME, FCM_MESSAGE_SEND_VOLUME, FCM_MESSAGE_RECV_VOLUME, FCM_TQ_SEND_VOLUME, FCM_TQ_RECV_VOLUME, TQ_TOT_SEND_SPILLS, APP_RQSTS_COMPLETED_TOTAL, TOTAL_ROLLBACK_TIME, TOTAL_DISP_RUN_QUEUE_TIME, TOTAL_ACT_TIME, TOTAL_ACT_WAIT_TIME, LAST_EXECUTABLE_ID, ASSOCIATED_AGENTS_TOP, TCPIP_RECV_WAIT_TIME, TCPIP_SEND_WAIT_TIME, IPC_RECV_WAIT_TIME, IPC_SEND_WAIT_TIME, FCM_RECV_WAIT_TIME, FCM_TQ_RECV_WAIT_TIME, FCM_MESSAGE_RECV_WAIT_TIME, FCM_SEND_WAIT_TIME, FCM_TQ_SEND_WAIT_TIME, FCM_MESSAGE_SEND_WAIT_TIME, AUDIT_SUBSYSTEM_WAIT_TIME, AUDIT_FILE_WRITE_WAIT_TIME, DIAGLOG_WRITE_WAIT_TIME, EVMON_WAIT_TIME, COMM_EXIT_WAIT_TIME, IDA_SEND_WAIT_TIME, IDA_RECV_WAIT_TIME, RECLAIM_WAIT_TIME, SPACEMAPPAGE_RECLAIM_WAIT_TIME, EXT_TABLE_RECV_WAIT_TIME, EXT_TABLE_SEND_WAIT_TIME, LOB_PREFETCH_WAIT_TIME, POOL_CACHING_TIER_PAGE_READ_TIME, POOL_CACHING_TIER_PAGE_WRITE_TIME, TOTAL_SYNC_RUNSTATS_PROC_TIME, TOTAL_STATS_FABRICATION_PROC_TIME, TOTAL_IMPLICIT_COMPILE_PROC_TIME, TOTAL_ROUTINE_USER_CODE_PROC_TIME, TOTAL_COL_SYNOPSIS_PROC_TIME, TOTAL_BACKUP_PROC_TIME, TOTAL_INDEX_BUILD_PROC_TIME, TOTAL_CONNECT_REQUEST_PROC_TIME, TOTAL_CONNECT_AUTHENTICATION_PROC_TIME, SORT_HEAP_ALLOCATED, POST_SHRTHRESHOLD_SORTS, POST_SHRTHRESHOLD_HASH_JOINS, INT_COMMITS, INT_ROLLBACKS) NONRECOVERABLE');
CALL SYSPROC.ADMIN_CMD('LOAD FROM (select DBCONN_INT, TIMESTAMP, COLLECTED, LEVEL_TAG, APPLICATION_HANDLE, MEMBER, SESSION_AUTH_ID, APPLICATION_NAME, WORKLOAD_OCCURRENCE_STATE, LOCK_STATUS, LOCK_MODE, LOCK_NAME, LOCK_OBJECT_TYPE, LOCK_CURRENT_MODE, NUM_LOCKS_HELD, LOCK_WAITS, LOCK_WAIT_TIME, STMT_TEXT_SUMMARY, SQL_HASH_ID, TABSCHEMA, TABNAME, DATA_PARTITION_ID from <repository_schema_name>.LOCKS WITH UR ) OF CURSOR REPLACE INTO <repository_schema_name>.LOCKS_MDC(DBCONN_INT, TIMESTAMP, COLLECTED, LEVEL_TAG, APPLICATION_HANDLE, MEMBER, SESSION_AUTH_ID, APPLICATION_NAME, WORKLOAD_OCCURRENCE_STATE, LOCK_STATUS, LOCK_MODE, LOCK_NAME, LOCK_OBJECT_TYPE, LOCK_CURRENT_MODE, NUM_LOCKS_HELD, LOCK_WAITS, LOCK_WAIT_TIME, STMT_TEXT_SUMMARY, SQL_HASH_ID, TABSCHEMA, TABNAME, DATA_PARTITION_ID) NONRECOVERABLE');
CALL SYSPROC.ADMIN_CMD('LOAD FROM (select DBCONN_INT, TABSCHEMA, TABNAME, TIMESTAMP, LEVEL_TAG, TOTAL_LOGICAL_SIZE_KB, LASTUSED, XML_PHYSICAL_SIZE_KB, DATA_LOGICAL_SIZE_KB, ROWCOMPMODE, DATA_PHYSICAL_SIZE_KB, LONG_PHYSICAL_SIZE_KB, TYPE, LONG_LOGICAL_SIZE_KB, ESTIMATED_RECLAIM_SIZE_KB, LOB_PHYSICAL_SIZE_KB, TOTAL_PHYSICAL_SIZE_KB, LOB_LOGICAL_SIZE_KB, COLUMN_ORGANIZED_DATA_LOGICAL_SIZE_KB, INDEX_LOGICAL_SIZE_KB, INDEX_PHYSICAL_SIZE_KB, XML_LOGICAL_SIZE_KB, COLUMN_ORGANIZED_DATA_PHYSICAL_SIZE_KB, PCTPAGESSAVED_CURRENT, PCTPAGESSAVED_STATIC, PCTPAGESSAVED_ADAPTIVE, PART_SIZE_KB from <repository_schema_name>.TABLESTORAGE WITH UR ) OF CURSOR REPLACE INTO <repository_schema_name>.TABLESTORAGE_MDC(DBCONN_INT, TABSCHEMA, TABNAME, TIMESTAMP, LEVEL_TAG, TOTAL_LOGICAL_SIZE_KB, LASTUSED, XML_PHYSICAL_SIZE_KB, DATA_LOGICAL_SIZE_KB, ROWCOMPMODE, DATA_PHYSICAL_SIZE_KB, LONG_PHYSICAL_SIZE_KB, TYPE, LONG_LOGICAL_SIZE_KB, ESTIMATED_RECLAIM_SIZE_KB, LOB_PHYSICAL_SIZE_KB, TOTAL_PHYSICAL_SIZE_KB, LOB_LOGICAL_SIZE_KB, COLUMN_ORGANIZED_DATA_LOGICAL_SIZE_KB, INDEX_LOGICAL_SIZE_KB, INDEX_PHYSICAL_SIZE_KB, XML_LOGICAL_SIZE_KB, COLUMN_ORGANIZED_DATA_PHYSICAL_SIZE_KB, PCTPAGESSAVED_CURRENT, PCTPAGESSAVED_STATIC, PCTPAGESSAVED_ADAPTIVE, PART_SIZE_KB) NONRECOVERABLE');
CALL SYSPROC.ADMIN_CMD('LOAD FROM (select DBCONN_INT, COLLECTED, TIMESTAMP, SQL_HASH_ID, SQL_TEXT_SUMMARY, DELTA_MSEC, NUM_EXEC_WITH_METRICS, STMT_EXEC_TIME, TOTAL_CPU_TIME, ROWS_READ, ROWS_RETURNED, TOTAL_ACT_WAIT_TIME, LOCK_WAIT_TIME, SORT_OVERFLOWS, LOGICAL_READS, PHYSICAL_READS, TEMP_READS, POOL_DATA_L_READS, POOL_INDEX_L_READS, LOCK_ESCALS, STMT_TYPE_INT, SYSTEM_QUERY, FED_WAIT_TIME, FED_ROWS_DELETED, FED_ROWS_INSERTED, FED_ROWS_UPDATED, FED_ROWS_READ, FED_WAITS_TOTAL, LOCK_WAITS, ROWS_MODIFIED, LEVEL_TAG, INSERT_TS, CURRENT_TS, LAST_METRICS_UPDATE_TS, EXECUTABLE_ID, STMTID, PLANID, SEMANTIC_ENV_ID, STMT_TYPE_ID, COORD_STMT_EXEC_TIME, ESTIMATED_RUNTIME, ESTIMATED_SORT_SHRHEAP_TOP, SORT_SHRHEAP_TOP, HASH_JOIN_OVERFLOWS, HASH_GRPBY_OVERFLOWS, OLAP_FUNC_OVERFLOWS, COL_VECTOR_CONSUMER_OVERFLOWS, POST_THRESHOLD_SORTS, POST_THRESHOLD_HASH_JOINS, POST_THRESHOLD_OLAP_FUNCS, POST_THRESHOLD_HASH_GRPBYS, POST_THRESHOLD_COL_VECTOR_CONSUMERS, POOL_READ_TIME, POOL_WRITE_TIME, PREFETCH_WAIT_TIME, POOL_WRITES, EXT_TABLE_READ_VOLUME, EXT_TABLE_WRITE_VOLUME, EXT_TABLE_SEND_VOLUME, EXT_TABLE_RECV_VOLUME, TOTAL_SECTION_PROC_TIME, TOTAL_ROUTINE_USER_CODE_PROC_TIME, DIRECT_READ_TIME, DIRECT_WRITE_TIME, LOG_BUFFER_WAIT_TIME, LOG_DISK_WAIT_TIME, AUDIT_SUBSYSTEM_WAIT_TIME, AUDIT_FILE_WRITE_WAIT_TIME, DIAGLOG_WRITE_WAIT_TIME, EVMON_WAIT_TIME, TOTAL_EXTENDED_LATCH_WAIT_TIME, RECLAIM_WAIT_TIME, SPACEMAPPAGE_RECLAIM_WAIT_TIME, COMM_EXIT_WAIT_TIME, LOCK_WAIT_TIME_GLOBAL, FCM_RECV_WAIT_TIME, CF_WAIT_TIME, WLM_QUEUE_TIME_TOTAIL, FCM_WAIT_TIME, TOTAL_ACT_TIME, PACKAGE_NAME, PACKAGE_VERSION_ID, PACKAGE_SCHEMA, SECTION_NUMBER, NUM_EXECUTIONS, NUM_EXEC_WITH_ERROR, NUM_EXEC_WITH_WARNING, MAX_ESTIMATED_SHRHEAP_PER_PART_PERCENT, MAX_SHRHEAP_PEAK_PER_PART_PERCENT, AGENTS_TOP, ADM_BYPASS_ACT_TOTAL, QUERY_COST_ESTIMATE, LAST_EXEC_ERROR, LAST_EXEC_ERROR_SQLERRMC, LAST_EXEC_ERROR_TIMESTAMP, TOTAL_HASH_GRPBYS, TOTAL_HASH_JOINS, TOTAL_OLAP_FUNCS, TOTAL_SORTS, TOTAL_COL_VECTOR_CONSUMERS, ROWS_INSERTED, ROWS_UPDATED, ROWS_DELETED, POOL_DATA_P_READS, POOL_TEMP_DATA_L_READS, POOL_TEMP_DATA_P_READS, POOL_INDEX_P_READS, POOL_TEMP_INDEX_L_READS, POOL_TEMP_INDEX_P_READS, POOL_COL_L_READS, POOL_COL_P_READS, POOL_TEMP_COL_L_READS, POOL_TEMP_COL_P_READS, POOL_DATA_WRITES, POOL_INDEX_WRITES, POOL_COL_WRITES, DIRECT_READS, DIRECT_WRITES, DIRECT_READ_REQS, DIRECT_WRITE_REQS, FCM_SEND_VOLUME, FCM_RECV_VOLUME, TQ_TOT_SEND_SPILLS, PREP_TIME, PREFETCH_WAITS from <repository_schema_name>.SQL_FACT WITH UR ) OF CURSOR REPLACE INTO <repository_schema_name>.SQL_FACT_MDC(DBCONN_INT, COLLECTED, TIMESTAMP, SQL_HASH_ID, SQL_TEXT_SUMMARY, DELTA_MSEC, NUM_EXEC_WITH_METRICS, STMT_EXEC_TIME, TOTAL_CPU_TIME, ROWS_READ, ROWS_RETURNED, TOTAL_ACT_WAIT_TIME, LOCK_WAIT_TIME, SORT_OVERFLOWS, LOGICAL_READS, PHYSICAL_READS, TEMP_READS, POOL_DATA_L_READS, POOL_INDEX_L_READS, LOCK_ESCALS, STMT_TYPE_INT, SYSTEM_QUERY, FED_WAIT_TIME, FED_ROWS_DELETED, FED_ROWS_INSERTED, FED_ROWS_UPDATED, FED_ROWS_READ, FED_WAITS_TOTAL, LOCK_WAITS, ROWS_MODIFIED, LEVEL_TAG, INSERT_TS, CURRENT_TS, LAST_METRICS_UPDATE_TS, EXECUTABLE_ID, STMTID, PLANID, SEMANTIC_ENV_ID, STMT_TYPE_ID, COORD_STMT_EXEC_TIME, ESTIMATED_RUNTIME, ESTIMATED_SORT_SHRHEAP_TOP, SORT_SHRHEAP_TOP, HASH_JOIN_OVERFLOWS, HASH_GRPBY_OVERFLOWS, OLAP_FUNC_OVERFLOWS, COL_VECTOR_CONSUMER_OVERFLOWS, POST_THRESHOLD_SORTS, POST_THRESHOLD_HASH_JOINS, POST_THRESHOLD_OLAP_FUNCS, POST_THRESHOLD_HASH_GRPBYS, POST_THRESHOLD_COL_VECTOR_CONSUMERS, POOL_READ_TIME, POOL_WRITE_TIME, PREFETCH_WAIT_TIME, POOL_WRITES, EXT_TABLE_READ_VOLUME, EXT_TABLE_WRITE_VOLUME, EXT_TABLE_SEND_VOLUME, EXT_TABLE_RECV_VOLUME, TOTAL_SECTION_PROC_TIME, TOTAL_ROUTINE_USER_CODE_PROC_TIME, DIRECT_READ_TIME, DIRECT_WRITE_TIME, LOG_BUFFER_WAIT_TIME, LOG_DISK_WAIT_TIME, AUDIT_SUBSYSTEM_WAIT_TIME, AUDIT_FILE_WRITE_WAIT_TIME, DIAGLOG_WRITE_WAIT_TIME, EVMON_WAIT_TIME, TOTAL_EXTENDED_LATCH_WAIT_TIME, RECLAIM_WAIT_TIME, SPACEMAPPAGE_RECLAIM_WAIT_TIME, COMM_EXIT_WAIT_TIME, LOCK_WAIT_TIME_GLOBAL, FCM_RECV_WAIT_TIME, CF_WAIT_TIME, WLM_QUEUE_TIME_TOTAIL, FCM_WAIT_TIME, TOTAL_ACT_TIME, PACKAGE_NAME, PACKAGE_VERSION_ID, PACKAGE_SCHEMA, SECTION_NUMBER, NUM_EXECUTIONS, NUM_EXEC_WITH_ERROR, NUM_EXEC_WITH_WARNING, MAX_ESTIMATED_SHRHEAP_PER_PART_PERCENT, MAX_SHRHEAP_PEAK_PER_PART_PERCENT, AGENTS_TOP, ADM_BYPASS_ACT_TOTAL, QUERY_COST_ESTIMATE, LAST_EXEC_ERROR, LAST_EXEC_ERROR_SQLERRMC, LAST_EXEC_ERROR_TIMESTAMP, TOTAL_HASH_GRPBYS, TOTAL_HASH_JOINS, TOTAL_OLAP_FUNCS, TOTAL_SORTS, TOTAL_COL_VECTOR_CONSUMERS, ROWS_INSERTED, ROWS_UPDATED, ROWS_DELETED, POOL_DATA_P_READS, POOL_TEMP_DATA_L_READS, POOL_TEMP_DATA_P_READS, POOL_INDEX_P_READS, POOL_TEMP_INDEX_L_READS, POOL_TEMP_INDEX_P_READS, POOL_COL_L_READS, POOL_COL_P_READS, POOL_TEMP_COL_L_READS, POOL_TEMP_COL_P_READS, POOL_DATA_WRITES, POOL_INDEX_WRITES, POOL_COL_WRITES, DIRECT_READS, DIRECT_WRITES, DIRECT_READ_REQS, DIRECT_WRITE_REQS, FCM_SEND_VOLUME, FCM_RECV_VOLUME, TQ_TOT_SEND_SPILLS, PREP_TIME, PREFETCH_WAITS) NONRECOVERABLE');
CALL SYSPROC.ADMIN_CMD('LOAD FROM (select dbconn_int, collected, timestamp, level_tag, member, application_handle, uow_id, application_name, act_aborted_total, workload_occurrence_state, act_completed_total, act_rejected_total, direct_reads, direct_writes, rows_read, rows_modified, rows_returned, uow_log_space_used, total_cpu_time, total_act_time, num_locks_held, lock_wait_time, total_sorts, sort_overflows, total_section_sort_proc_time, fcm_sends_recvs_total, wlm_queue_time_total, session_auth_id, client_ipaddr, prev_uow_stop_time, uow_start_time, uow_stop_time, uow_comp_status, num_assoc_agents, app_rqsts_completed_total, num_locks_waiting, coord_member, total_hash_grpbys, total_hash_joins, total_olap_funcs, total_col_vector_consumers, post_threshold_hash_grpbys, post_threshold_hash_joins, post_threshold_olap_funcs, post_threshold_sorts, post_threshold_col_vector_consumers, hash_grpby_overflows, hash_join_overflows, olap_func_overflows, col_vector_consumer_overflows, rows_inserted, rows_updated, rows_deleted, pool_data_l_reads, pool_data_p_reads, pool_temp_data_l_reads, pool_temp_data_p_reads, pool_index_l_reads, pool_index_p_reads, pool_temp_index_l_reads, pool_temp_index_p_reads, pool_col_l_reads, pool_col_p_reads, pool_temp_col_l_reads, pool_temp_col_p_reads, pool_data_writes, pool_index_writes, pool_col_writes, direct_read_reqs, direct_write_reqs, fcm_send_volume, fcm_recv_volume, fcm_message_send_volume, fcm_message_recv_volume, fcm_tq_send_volume, fcm_tq_recv_volume, tq_tot_send_spills, ext_table_send_volume, ext_table_recv_volume, total_rqst_time, client_idle_wait_time, wlm_queue_assignments_total, lock_wait_time_global, cf_wait_time, fed_wait_time, pool_read_time, pool_write_time, direct_read_time, direct_write_time, total_commit_time, total_rollback_time, sort_memory_consumption from <repository_schema_name>."unitsOfWorks" WITH UR ) OF CURSOR REPLACE INTO <repository_schema_name>."unitsOfWorks_mdc"(dbconn_int, collected, timestamp, level_tag, member, application_handle,uow_id, application_name, act_aborted_total, workload_occurrence_state, act_completed_total, act_rejected_total, direct_reads, direct_writes, rows_read, rows_modified, rows_returned, uow_log_space_used, total_cpu_time, total_act_time, num_locks_held, lock_wait_time, total_sorts, sort_overflows, total_section_sort_proc_time, fcm_sends_recvs_total, wlm_queue_time_total, session_auth_id, client_ipaddr, prev_uow_stop_time, uow_start_time, uow_stop_time, uow_comp_status, num_assoc_agents, app_rqsts_completed_total, num_locks_waiting, coord_member, total_hash_grpbys, total_hash_joins, total_olap_funcs, total_col_vector_consumers, post_threshold_hash_grpbys, post_threshold_hash_joins, post_threshold_olap_funcs, post_threshold_sorts, post_threshold_col_vector_consumers, hash_grpby_overflows, hash_join_overflows, olap_func_overflows, col_vector_consumer_overflows, rows_inserted, rows_updated, rows_deleted,pool_data_l_reads, pool_data_p_reads, pool_temp_data_l_reads, pool_temp_data_p_reads, pool_index_l_reads, pool_index_p_reads, pool_temp_index_l_reads, pool_temp_index_p_reads, pool_col_l_reads, pool_col_p_reads, pool_temp_col_l_reads, pool_temp_col_p_reads, pool_data_writes, pool_index_writes, pool_col_writes, direct_read_reqs, direct_write_reqs, fcm_send_volume, fcm_recv_volume, fcm_message_send_volume, fcm_message_recv_volume, fcm_tq_send_volume, fcm_tq_recv_volume, tq_tot_send_spills, ext_table_send_volume, ext_table_recv_volume, total_rqst_time, client_idle_wait_time, wlm_queue_assignments_total, lock_wait_time_global, cf_wait_time, fed_wait_time, pool_read_time, pool_write_time, direct_read_time, direct_write_time, total_commit_time, total_rollback_time, sort_memory_consumption) NONRECOVERABLE');
    where <dmc_repository> is Db2 Data Management Console repository name, <repository_schema_name> is Db2 Data Management Console repository schema.
  4. Enable MDC tables function.
    Method 1:
    1. Navigate to the /ibm-datamgmtconsole/Config/ folder of your IBM Db2 Data Management Console installation and open the dswebserver_override.properties file. 
      /ibm-datamgmtconsole/Config/dswebserver_override.properties
    2. Add the following property value:
      IS_MDC=true
    Method 2:
    1. Enable the MDC function by using the following REST API:
      curl --location --request PUT 'http://{IP}:{PORT}/dbapi/v4/settings/uc/IS_MDC' \
--header 'Accept: application/json' \
--header 'Authorization: Bearer {token}' \
--header 'Content-Type: application/json' \
--data-raw '{
    "value": "true"
}'
{token} is returned by DMC authentication API.
    2. Verify whether MDC is enabled: 
      curl --location --request Get 'http://{IP}:{PORT}/dbapi/v4/settings/uc/IS_MDC' \
--header 'Accept: application/json' \
--header 'Authorization: Bearer {token}' \
--header 'Content-Type: application/json' \
      If the return value is {"value":"true"}, it means that MDC is enabled.
  5. Restart the service of Db2 Data Management Console. 
    /ibm-datamgmtconsole/bin/startup.sh