Соединения с базами IBM DB2
-
Пытаюсь настроить соединения с БД IBM Db2.
Конфигурация агента:
#SubAgent = db2.nsm #*DB2 #ConfigFile = c:/NetXMS/etc/db2.xmlСодержимое файла db2.xml:
<?xml version="1.0" encoding="Windows-1251" ?> <config> <db2sub> <db2 id=1> <dbname>VOCDB</dbname> <dbalias>VOCDB</dbalias> <username>db2admin</username> <password>pass12345</password> <queryinterval>30</queryinterval> <reconnectinterval>30</reconnectinterval> </db2> </db2sub> <db2sub> <db2 id=2> <dbname>ANGEL</dbname> <dbalias>ANGEL</dbalias> <username>db2admin</username> <password>pass12345</password> <queryinterval>30</queryinterval> <reconnectinterval>30</reconnectinterval> </db2> </db2sub> <db2sub> <db2 id=3> <dbname>SEVER</dbname> <dbalias>SEVER</dbalias> <username>db2admin</username> <password>pass12345</password> <queryinterval>30</queryinterval> <reconnectinterval>30</reconnectinterval> </db2> </db2sub> </config>Лог:
Initialization of subagent "db2.nsm" failed DB2: 'c:/NetXMS/etc/db2.xml' is not a valid configuration fileЕсли же прописываю параметры одной БД в файле, получаю следующее:
Subagent "db2.nsm" loaded successfully DB2: connected to database 'VOCDB' Ошибка 11.02.2015 11:29:39 NetXMS Win32 Agent 23 Отсутствует DB2: query 'SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE tab_organization = 'C'' failed Ошибка 11.02.2015 11:29:39 NetXMS Win32 Agent 44 Отсутствует "SQL query failed (Query = ""SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE tab_organization = 'C'""): [IBM][CLI Driver][DB2/NT64] SQL0206N ""TAB_ORGANIZATION"" недопустимо в контексте, где оно используется. SQLSTATE=42703" Ошибка 11.02.2015 11:29:39 NetXMS Win32 Agent 23 Отсутствует DB2: query 'SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE tab_organization = 'R'' failed Ошибка 11.02.2015 11:29:39 NetXMS Win32 Agent 44 Отсутствует "SQL query failed (Query = ""SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE tab_organization = 'R'""): [IBM][CLI Driver][DB2/NT64] SQL0206N ""TAB_ORGANIZATION"" недопустимо в контексте, где оно используется. SQLSTATE=42703" Ошибка 11.02.2015 11:29:39 NetXMS Win32 Agent 23 Отсутствует DB2: query 'SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE data_sharing_state = 'BECOMING_NOT_SHARED'' failed Ошибка 11.02.2015 11:29:39 NetXMS Win32 Agent 44 Отсутствует "SQL query failed (Query = ""SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE data_sharing_state = 'BECOMING_NOT_SHARED'""): [IBM][CLI Driver][DB2/NT64] SQL0206N ""DATA_SHARING_STATE"" недопустимо в контексте, где оно используется. SQLSTATE=42703" Ошибка 11.02.2015 11:29:39 NetXMS Win32 Agent 23 Отсутствует DB2: query 'SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE data_sharing_state = 'BECOMING_SHARED'' failed Ошибка 11.02.2015 11:29:39 NetXMS Win32 Agent 44 Отсутствует "SQL query failed (Query = ""SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE data_sharing_state = 'BECOMING_SHARED'""): [IBM][CLI Driver][DB2/NT64] SQL0206N ""DATA_SHARING_STATE"" недопустимо в контексте, где оно используется. SQLSTATE=42703" Ошибка 11.02.2015 11:29:39 NetXMS Win32 Agent 23 Отсутствует DB2: query 'SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE data_sharing_state = 'NOT_SHARED'' failed Ошибка 11.02.2015 11:29:39 NetXMS Win32 Agent 44 Отсутствует "SQL query failed (Query = ""SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE data_sharing_state = 'NOT_SHARED'""): [IBM][CLI Driver][DB2/NT64] SQL0206N ""DATA_SHARING_STATE"" недопустимо в контексте, где оно используется. SQLSTATE=42703" Ошибка 11.02.2015 11:29:39 NetXMS Win32 Agent 23 Отсутствует DB2: query 'SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE data_sharing_state = 'SHARED'' failed Ошибка 11.02.2015 11:29:39 NetXMS Win32 Agent 44 Отсутствует "SQL query failed (Query = ""SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE data_sharing_state = 'SHARED'""): [IBM][CLI Driver][DB2/NT64] SQL0206N ""DATA_SHARING_STATE"" недопустимо в контексте, где оно используется. SQLSTATE=42703" Ошибка 11.02.2015 11:29:39 NetXMS Win32 Agent 23 Отсутствует DB2: query 'SELECT sum(table_scans), sum(rows_read), sum(rows_inserted), sum(rows_updated), sum(rows_deleted),sum(overflow_accesses), sum(overflow_creates), sum(page_reorgs), sum(data_object_l_pages), sum(lob_object_l_pages),sum(long_object_l_pages), sum(index_object_l_pages), sum(xda_object_l_pages), sum(no_change_updates),sum(lock_wait_time), sum(lock_wait_time_global), sum(lock_waits), sum(lock_waits_global), sum(lock_escals),sum(lock_escals_global), sum(data_sharing_remote_lockwait_count), sum(data_sharing_remote_lockwait_time),sum(direct_writes), sum(direct_write_reqs), sum(direct_reads), sum(direct_read_reqs), sum(object_data_l_reads),sum(object_data_p_reads), sum(object_data_gbp_l_reads), sum(object_data_gbp_p_reads),sum(object_data_gbp_invalid_pages), sum(object_data_lbp_pages_found), sum(object_data_gbp_indep_pages_found_in_lbp),sum(object_xda_l_reads), sum(object_xda_p_reads), sum(object_xda_gbp_l_reads), sum(object_xda_gbp_p_reads),sum(object_xda_gbp_invalid_pages), sum(object_xda_lbp_pages_found), sum(object_xda_gbp_indep_pages_found_in_lbp),sum(num_page_dict_built), sum(stats_rows_modified), sum(rts_rows_modified), sum(col_object_l_pages),sum(object_col_l_reads), sum(object_col_p_reads), sum(object_col_gbp_l_reads), sum(object_col_gbp_p_reads),sum(object_col_gbp_invalid_pages), sum(object_col_lbp_pages_found), sum(object_col_gbp_indep_pages_found_in_lbp),sum(num_columns_referenced), sum(section_exec_with_col_references) FROM TABLE (mon_get_table('', '', -2))' failed Ошибка 11.02.2015 11:29:39 NetXMS Win32 Agent 44 Отсутствует "SQL query failed (Query = ""SELECT sum(table_scans), sum(rows_read), sum(rows_inserted), sum(rows_updated), sum(rows_deleted),sum(overflow_accesses), sum(overflow_creates), sum(page_reorgs), sum(data_object_l_pages), sum(lob_object_l_pages),sum(long_object_l_pages), sum(index_object_l_pages), sum(xda_object_l_pages), sum(no_change_updates),sum(lock_wait_time), sum(lock_wait_time_global), sum(lock_waits), sum(lock_waits_global), sum(lock_escals),sum(lock_escals_global), sum(data_sharing_remote_lockwait_count), sum(data_sharing_remote_lockwait_time),sum(direct_writes), sum(direct_write_reqs), sum(direct_reads), sum(direct_read_reqs), sum(object_data_l_reads),sum(object_data_p_reads), sum(object_data_gbp_l_reads), sum(object_data_gbp_p_reads),sum(object_data_gbp_invalid_pages), sum(object_data_lbp_pages_found), sum(object_data_gbp_indep_pages_found_in_lbp),sum(object_xda_l_reads), sum(object_xda_p_reads), sum(object_xda_gbp_l_reads), sum(object_xda_gbp_p_reads),sum(object_xda_gbp_invalid_pages), sum(object_xda_lbp_pages_found), sum(object_xda_gbp_indep_pages_found_in_lbp),sum(num_page_dict_built), sum(stats_rows_modified), sum(rts_rows_modified), sum(col_object_l_pages),sum(object_col_l_reads), sum(object_col_p_reads), sum(object_col_gbp_l_reads), sum(object_col_gbp_p_reads),sum(object_col_gbp_invalid_pages), sum(object_col_lbp_pages_found), sum(object_col_gbp_indep_pages_found_in_lbp),sum(num_columns_referenced), sum(section_exec_with_col_references) FROM TABLE (mon_get_table('', '', -2))""): [IBM][CLI Driver][DB2/NT64] SQL0206N ""NO_CHANGE_UPDATES"" недопустимо в контексте, где оно используется. SQLSTATE=42703"Как правильно настроить подключение?
Заранее спасибо! -
По XML - скорее всего на Windows ему не нравится / как разделитель пути к файлу - поставьте \.
У пользователя, которым подключается агент, должно быть право EXECUTE на функцию MON_GET_TABLE. Возможно проблема в том что нет прав на эту функцию.
-
-
А какая версия DB/2 сервера и клиента?
-
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login