NetXMS Support Forum

В конфиге настроил подключение к БД

QuoteSubAgent = db2.nsm

*DB2
DBName            = testdb
DBAlias           = testdb
UserName          = netxms
Password          = **********
QueryInterval     = 60
ReconnectInterval = 30

Пункты DCI , которые должны были добавиться для выбора не появились. В журнале Windows много ругательств (приложил).
IDB DB2 9.7.700  MS Windows Server 2008 R2.
Это баг или я что то не так сделал?

хотелось бы вернуться к теме:
настроил подключение, в логе ошибки:


[18-Nov-2016 21:13:01.843] [INFO ] DB Library: Database driver "db2.ddr" loaded and initialized successfully
[18-Nov-2016 21:13:01.843] [INFO ] Subagent "db2.nsm" loaded successfully
[18-Nov-2016 21:13:02.015] [INFO ] DB2: connected to database 'ROS'
[18-Nov-2016 21:13:02.857] [INFO ] Listening on socket 0.0.0.0:4700
[18-Nov-2016 21:13:02.857] [INFO ] Listening on socket [::]:4700
[18-Nov-2016 21:13:03.871] [INFO ] NetXMS Agent started
[18-Nov-2016 21:13:36.538] [ERROR] 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  "DATA_OBJECT_L_PAGES" ??????????? ? ?????????, ??? ??? ????????????.  SQLSTATE=42703
[18-Nov-2016 21:13:36.538] [ERROR] 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
[18-Nov-2016 21:13:36.553] [ERROR] 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
[18-Nov-2016 21:13:36.553] [ERROR] DB2: query 'SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE data_sharing_state = 'SHARED'' failed
[18-Nov-2016 21:13:36.553] [ERROR] 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
[18-Nov-2016 21:13:36.553] [ERROR] DB2: query 'SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE data_sharing_state = 'NOT_SHARED'' failed
[18-Nov-2016 21:13:36.553] [ERROR] 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
[18-Nov-2016 21:13:36.553] [ERROR] DB2: query 'SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE data_sharing_state = 'BECOMING_SHARED'' failed
[18-Nov-2016 21:13:36.553] [ERROR] 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
[18-Nov-2016 21:13:36.553] [ERROR] DB2: query 'SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE data_sharing_state = 'BECOMING_NOT_SHARED'' failed
[18-Nov-2016 21:13:36.553] [ERROR] 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
[18-Nov-2016 21:13:36.553] [ERROR] DB2: query 'SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE tab_organization = 'R'' failed
[18-Nov-2016 21:13:36.553] [ERROR] 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
[18-Nov-2016 21:13:36.553] [ERROR] DB2: query 'SELECT count(*) FROM TABLE (mon_get_table('', '', -2)) WHERE tab_organization = 'C'' failed