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 ?
How to check various tablespaces in SAP and their sizes ?
14 comments:
many thanks to you if you take screen shot of increasing table space at os level
i want know what was the size of the tablespace yesterday..
on a particular date and time
plzz reply
i want to know the size of the tablespace for yesterday for particular date and time.
appreciate u r philanthropic
activities..
good one
Dear Prasad, i'm not been able to see any data in db02. do i need to run any programs
Yes, it's DB02 with all the details.
Kumar Mitra from Germany
GOOD
how to check yesterday tablesize for reporting purpose
Hi team how do I pull sort codes ftom SAP Finance?
Dear Prasad Sir, can you explain me what is mean By PSAPSR3, PSAPSR3USR and what is different between them?
No Need to run any. it my be due to error. check SAPOSCAL service is running proper.
PSAPSR3, PSAPSR3USR these are tablespaces.
How to set daily backup in DB2 Database in SAP JAVA stack?
Post a Comment