Ошибка в работе субагента IBM DB2
-
В конфиге настроил подключение к БД
SubAgent = 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
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