Table entry about a running R/3 instance ?!

[Former Member]

Hello,

i'm searching about a oracle table with some informations about running R/3 instances like SM51 or RZ03.

Know somebody something about a table that contain's this informations? - i need a OS-Level information about the status of the central and applikation instance for a script.

Thank you very much.

Regards,

Markus

[Former Member]

Marcus,

There is a program called sapinfo (part of SDK). It can be used to check the system, sapinfo ashost=host sysnr=nn.

-RK

[Former Member]

Thank's for your response.

But for that, i need a second list with hostname and instancenumber for the complete system.

I need a solution without a second list, RZ03 will be perfeckt to see which instance are running and which are not running, but i think we don't have a table with the RZ03 entrys ?!

Regards,

Markus

[Former Member]

Can you use table RZLLITAB?

-RK

[Former Member]

Let me check ...

[Former Member]

Hello

you can use the msprot programm on your central Instance.

Look at

http://help.sap.com/saphelp_nw70/helpdata/EN/97/ed71845e2c45839d1cce77290a85e0/frameset.htm

You can call msprot -l pf=<Path to your profile>

The list is like sm51.

You can now use the exit code or search in the output.

[Former Member]

The table RZLLITAB is very good.

But i can't see the status of a instance and are alle instances started or not.

In RZ03 you see also system instances they are not started.

From some systems we had sometimes the problem that are not all instances started after offline backup.

I'd like a solution to check all systems (>100) with a script if all instances are started, thats my intention.

Regards,

Markus

[Former Member]

I agree. msprot is better.

-RK

[Former Member]

@Markus Gieske: thanks for your answer

This information is very good, let me check.

Edited by: Markus Dinkel on Apr 17, 2008 4:04 PM