DBForBix - DB2 Error

[handerson]

Hi,
we´re testing DBForbix to monitor a DB2 Database, but in dbforbix.log we are receiving this error on log:

2013-08-16 09:56:12,477 [main] ERROR DBforBIX - Error on Configurator for database server197 -->DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;SELECT SYSTEM_USER;<table_expr>, DRIVER=3.53.95

Our db2Query.props haven´t sql with this statement...

This is the code of db2Query.props:
#DefaultQueryPeriod=2
QueryList=tbsutilization
#statistic of database
tbsutilization.Query=select substr(tbsp_name,1,10) "Name", tbsp_utilization_percent "Used%", tbsp_free_pages "FreePages", tbsp_usable_Pages "UsablePages", tbsp_used_pages "UsedPages", tbsp_page_top "HWM", tbsp_auto_resize_Enabled "AutoResize 1=Yes", tbsp_increase_size "Increase Size", tbsp_max_size "MaxSizeBytes -1=ulimited", tbsp_last_resize_failed "ResizeFailed 1=Yes", tbsp_page_size "PgSize Bytes" \
from SYSIBMADM.TBSP_UTILIZATION \
where tbsp_type = 'DMS'
tbsutilization.NoDataFound=none

Can someone help me?
Tks!!

[johansen]

have exactly the same problem. Were you able to solve it?

[dalle]

most probably is an issue due to some grants missing.
Unfortunately I don't have anymore a DB2 where do some testing, can you get in touch with your DBA?