Skip to Content
author's profile photo Former Member
Former Member

Database size and version

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Posted on Jun 17, 2008 at 11:20 AM

    hi,

    check these tables.

    CATK and CVERS_TXT.

    reward points if hlpful.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 11:21 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 11:22 AM

    HI,

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

    Thanks

    Murali

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 17, 2008 at 11:35 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 12:21 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.