topic Re: Database size and version in Application Development and Automation Discussions

Database size and version

Former Member — Tue, 17 Jun 2008 11:14:50 GMT

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

Re: Database size and version

GauthamV — Tue, 17 Jun 2008 11:20:45 GMT

hi,

check these tables.

CATK and CVERS_TXT.

reward points if hlpful.

Re: Database size and version

Former Member — Tue, 17 Jun 2008 11:21:14 GMT

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

Re: Database size and version

Former Member — Tue, 17 Jun 2008 11:22:03 GMT

HI,

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

Thanks

Murali

Re: Database size and version

JanStallkamp — Tue, 17 Jun 2008 11:35:42 GMT

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

Re: Database size and version

JanStallkamp — Tue, 17 Jun 2008 11:41:12 GMT

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

Re: Database size and version

Former Member — Tue, 17 Jun 2008 12:21:53 GMT

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