March 02, 2017

How to Check DB2 database on SAP Level

We can check the database on SAP level with tcode DB02 or DBACOCKPIT and navigate to space -> Space Overview to view
  • Database Name
  • Database System
  • Size
  • Free Size
  • Used Percentage
  • Number of Tablespaces
  • Number of Container Tablespaces

In DB02 or DBACOCKPIT, navigate to space -> space overview to find all on below details

Database Name and Database System



 

Total Size of Database, Free size and Used Percentage of Database



 In DB02 or DBACOCKPIT, navigate to tablespaces -> tablespaces overview to find all on below details

Total Size of Tablespaces, Free size and Used Percentage of Tablespaces


Tablespaces content name
 In DB02 or DBACOCKPIT, navigate to Containers -> containers overview to find all on below details
List Containers of tablespaces