Read KNLDIAGERR with dbmcli

[Former Member]

Hello,

I want to read the KNLDIAGERR with command line tool dbmcli from remote with option "DATE".

Command:

"file_getfirst KNLDIAGERR DATE=20080101000000"

The Result of this command is:

"ERR

-24996,ERR_PARAM: wrong parameters"

In the documentation this a supported option:

file_getfirst <file_ID> [<file_spec>]

<file_spec> :: = DATE=<timestamp> | LINE=<nnn>

SAPDB-Version 7.6.0

Bug or feature ?

Somebody experiences or ideas ?

Greetings, Andreas

[Former Member]

Hi Lars,

we want to implement an automatic monitoring using BMC Agents, which poll the database every few minutes and send a message or create a tickets, if something is wrong. These are messages about state, space, entries in error log file and so on.

There is no need to use the DBM-GUI manually for monitoring.

If you use the MaxDB without SAP, there is no CCMS and/or DB59.

Thanks for your reply,

kind regards

Andreas

[lbreddemann]

Hi Andreas,

so basically you're re-building the CCMS monitoring with the BMC agents...

You're right, if there is no SAP system running - you've no CCMS. I was just pointing out the opportunities, since most MaxDB customers do have a SAP instance running and don't know about the option to use the CCMS even for NON-SAP- MaxDB-instances.

Anyhow: for your monitoring tool

dbm_filegetfirst line=<n>

will deliver the newest <n> lines.

That way you can at least implement a sorting/matching in your BMC agent based on the timestamp.

Good luck with the implentation!

KR Lars

[Former Member]

Hi Lars,

thanks for the answer. There is a lack in the documentation. Next time i will search for the error message and hopefully find the other thread ...

But DBM-GUI is not a tool for remote monitoring.

Kind regards

Andreas

[lbreddemann]

Hi Andreas,

>

> But DBM-GUI is not a tool for remote monitoring.

What do you mean with that?

It's no problem to administer many remote database with the DBMGUI!

You can access all logfiles, the Db Analyzer logs (with DB Studio this is even more comfortable).

What kind of monitoring do you do?

If you're a SAP customer you can integrate all your SAP DB/MaxDB/liveCache instances into the CCMS (Transaction DB59),

KR Lars

[lbreddemann]

HI Andreas,

the file_getfirst command in combination with the date/line parameter does not work on all files.

That's similar to the problem discussed in thread .

Anyhow for KNLDIAGERR the line parameter works fine.

Therefore this is not a software bug but rather a lack of documentation.

BTW: it's really recommended to use the DBM Gui/DB Studio to administer databases - especially for remote databases!

KR Lars