Pages

▼

Tuesday, 21 June 2011

How to check database, tablespace sizes in SAP ?




This article answers the following queries :
  • How to check the database size ?
  • How to check in SAP, the number of tables and indexes in database and their sizes ?
  • How to check  the users that are present in database at SAP level ?
  • How to check various tablespaces in SAP and their sizes ?

 ---------------------------------------------------------------------------------------


How to check the database size ?

Goto transaction DB02  and navigate to Space -> Space overview to view

  • Database name
  • Database system
  • Size
  • Free size
  • Used percentage
  • Number of database users
  • Number of tablespaces
  • Number of tables and size
  • Number of indexes and size

In DB02, navigate to Space -> Space overview to find all the above mentioned details


    How to check  the users that are present in database at SAP level ?

    In DB02, navigate to Space -> Users -> Overview as below


              How to check various tablespaces in SAP and their sizes ?

              In DB02, navigate to Space -> Table spaces -> Overview to view tablespaces details as below.






                    at

                    14 comments:

                    1. Anonymous30 October 2012 at 19:55

                      many thanks to you if you take screen shot of increasing table space at os level

                      ReplyDelete
                    2. Anonymous10 January 2013 at 16:06

                      i want know what was the size of the tablespace yesterday..
                      on a particular date and time

                      plzz reply

                      ReplyDelete
                    3. Anonymous10 January 2013 at 16:08

                      i want to know the size of the tablespace for yesterday for particular date and time.

                      ReplyDelete
                    4. Unknown15 May 2013 at 11:47

                      appreciate u r philanthropic
                      activities..

                      ReplyDelete
                    5. http://vishalchaudharybasis.blogspot.com14 September 2013 at 19:43

                      good one

                      ReplyDelete
                    6. Unknown17 December 2013 at 14:25

                      Dear Prasad, i'm not been able to see any data in db02. do i need to run any programs

                      ReplyDelete
                      Replies
                      1. Anonymous5 July 2017 at 12:26

                        No Need to run any. it my be due to error. check SAPOSCAL service is running proper.

                        Delete
                    7. Kumar Mitra12 May 2014 at 17:26

                      Yes, it's DB02 with all the details.

                      Kumar Mitra from Germany

                      ReplyDelete
                    8. ALI MD B21 September 2014 at 22:21

                      GOOD

                      ReplyDelete
                    9. shiva28 April 2015 at 10:08

                      how to check yesterday tablesize for reporting purpose

                      ReplyDelete
                    10. Unknown30 May 2015 at 18:02

                      Hi team how do I pull sort codes ftom SAP Finance?

                      ReplyDelete
                    11. Unknown4 April 2017 at 12:50

                      Dear Prasad Sir, can you explain me what is mean By PSAPSR3, PSAPSR3USR and what is different between them?

                      ReplyDelete
                    12. SRIKANTH15 June 2018 at 22:52

                      PSAPSR3, PSAPSR3USR these are tablespaces.

                      ReplyDelete
                    13. Unknown19 July 2018 at 12:50

                      How to set daily backup in DB2 Database in SAP JAVA stack?

                      ReplyDelete

                    Please provide your valuable feedback: