最近在研究zabbix监控db2,正在研究查询指标的sql语句:主要有(1)查询表空间使用率SELECTsubstr(tbsp_name,1,20) as TABLESPACE_NAME, substr(tbsp_content_type,1,10) asTABLESPACE_TYPE, sum(tbsp_total_size_kb)/1024 as TOTAL_MB, sum(tbsp_used_size_kb)/1024 as USED_MB...(more)
set sqlbuf \" select kpi_id from db2admin.new_kpi_define where kpi_unit=\'%\' and kpi_data_unit=-2 order by kpi_id \" if [catch { aidb_sql $fhandle $sqlbuf } errmsg ] { trace_sql $errmsg 1...(more)
db2 update monitor switches using locks onselect * from table(sysproc.snapshot_lock(\'sample\',-1));SQL0440N No authorized routine named \"SNAPSHOT_LOCK\" of type \"FUNCTION\" having compatible arguments was found. SQLSTATE=4288...(more)