Database size and version

[Former Member]

Hi

i want to display the database size, version and Operating system used.

can anyone tell me the tables relevant to them please...

points will be rewarded

[GauthamV]

hi,

check these tables.

CATK and CVERS_TXT.

reward points if hlpful.

[Former Member]

Hi,

SY-DBSYS

Central database system, for example INFORMIX, ORACLE

SY-OPSYS

Operating system of application server, for example HP-UX, SINIX

SY-SAPRL

Release status of the SAP System, for example 30D, 46A

The above system variable fulfill you req.

Reward if found helpful.

Regards,

Boobalan Suburaj

[Former Member]

HI,

Goto se14 t-code and give the table name and check it.

Thanks

Murali

[JanStallkamp]

Hi.

There are some global variables like:

sy-dbsys -> Database system

sy-opsys -> Operating system

For release information I would use the Class CL_DBA_DBCON. There you will find methods like GET_DBMS (database type), GET_DBREL (DB release). I'm not sure that there is a platform independet way to find out the operating system version. Database size can also be complicated as this is highly depending on the database type.

If you have used transaction DBACOCKPIT once on the system you will find data about DB-type and release in table DB6NAVSYST. Don't change any entries there manually!

Best regards,

Jan Stallkamp

[JanStallkamp]

One thing to add:

If you just want to know the values: Ask your basis people. They should know... Or have a look into transaction DBACOCKPIT.

/Jan

[Former Member]

Hi

Go through the link given below :

http://help.sap.com/saphelp_nw70/helpdata/en/3d/11ffa78c672844a242ed4a85a4da31/content.htm

hope it will work for you.

With Regards

Nikunj Shah