Monday, November 10, 2008

ITM ODBC Universal Agent tips

As you know, (or don't know,) Tivoli Monitoring has a quick-and-simple way of extracting data from databases on windows machines. By creating a Universal Agent of the type ODBC, you can simply write your select into the mdl file and go from there. On Unixes you need to use a script UA and do a little more work.

Two things which I've dealt with in the past week:

  • There is a limit to how many lines the UA will pull out of the database. So if your select results in hundreds of lines, only the first 100 will actually be displayed in the portal or will cause situations to fire. You can change this maximum in the ENV file, by setting the parameter KUMP_ODBC_MAX_ROWS to whatever you need.
  • The SQL query in the mdl file must be on one line. I had a nicely formatted looong SQL which ran along a number of lines. The results were... not what I wanted (although the mdl compiled properly and there were no SQL errors). I suppose the newline character did some mischief with the SQL parser during runtime and it's not used by the mdl compiler.

Anyway, hope this helps someone :)