Finding info about the database

[#1]

I need to write a program to find out which database server is used, its ip address, its version and the databases within the server. How can i do that? Is there a config file or something similar which has all the information. Are there any APIs which i can use?

Please help me out here.

[markus_doehr2]

You can also run transaction DBACOCKPIT or use RZ20.

Markus

[Former Member]

Thanks Nick and Markus,

I can get the database info by the ways you suggested. But i am getting it manually. Is there a way i can get this from a c/c++ program?

[markus_doehr2]

> I can get the database info by the ways you suggested. But i am getting it manually. Is there a way i can get this from a c/c++ program?

I'm not sure what you're asking here.

You want to write a program that connects to the SAP system and gets the data? Why do you want to do that? I'm trying to understand the context of the requirement.

There is a complete monitoring infrastructure available (CCMS) to "push" the data to a central system.

Markus

[Former Member]

you could create an ABAP program that would fetch that info, write this in a text file and have or C+ program read that text file.

the ABAP program can be scheduled in SM36/SM37 and triggered by an event, you can call program SAPEVT at OS level to trigger your event.

There are no API for this.

there are a lot of interesting ABAP programs at http://www.kabai.com/abaps/q.htm

[markus_doehr2]

> I can get the database info by the ways you suggested. But i am getting it manually. Is there a way i can get this from a c/c++ program?

...or you can omit the SAP part alltogether and write a program using Oracles interface (OCI). You can also write a few sql scripts (e. g. select * from v$version) to get the information.

It's all a question on what you want to achieve.

Markus