Can I script these checks ... HOW ... ???

[Former Member]

Hi all,

Am not sure to which forum I should post this question and I assume most DBAs are BASIS administrators as well who may be doing these checks.

At the moment, am doing the following checks manually via SPGUI.

DB02

DB12

DB13

SM50

SM56

SM37

SM13

SM12

ST22

SM21

Is there any way to run these checks via a UNIX script .... please .......

Any response or suggestion will be very much appreciated. Thanks in advance.

[Former Member · Accepted solution]

Yes, it is, but why don't you use SAP CCMS (tx rz20) to perform your checks. All you checks can be grouped in one overview.

Kind regards,

Mark

[Former Member · Accepted solution]

Hi,

Some checks are via RZ20 and some are not, not sure why ... am confused (???) and I can see what you mentioned that some of the checks are indeed in the RZ20 transaction ...

The only main difference I can see is that with RZ20, you can clear the alert but if not using RZ20, then you cannot clear the alerts, am I correct?

Still want to know how to script it though ...

[markus_doehr2 · Accepted solution]

> Still want to know how to script it though ...

Lots of that information is only available at application level, e. g. SM37 are SAP jobs that are not accessible easily from the OS as well as e. g. ST22.

And the question is: what do you want to "check"? There's for sure a possibility to get the output of ST22 but what to do with the output?

Markus

[Former Member · Accepted solution]

Hi Markus,

Thanks for your response.

Things I want to check, for example as below:

- SM37, is there any terminated jobs,

- SM12, is there any locks that are 2-4 hours old that may cause a deadlock when a batch load runs

- DB12, when is the last successful backup

- ST22, who had created the most short dumps, send the user an email

At the moment, am doing these checks manually, I am hoping if I can script it somehow, then I just do the checks within the script.

[former_member204746 · Accepted solution]

RZ20 is the way to go.

also check transaction SSAA.

but to completely fulfill your needs, you will need to write ABAP programs.