How to get the DB2 database free space?

Question: Where can I find information for the DB2 database free space with automatic storage in use   ?

Answer:  You can view various DB2 database status information via the GET SNAPSHOT command. For database free space follow these steps

Step 1)      Logon with db2<sid> user.

Step 2)  Connect to the database

          db2 connect to <dbsid> 

Step 3) Execute this command to get the DB snapshot

        db2 get snapshot for database on <dbsid> > /tmp/db_snapshot.txt

In the output file, you will find entries like below:

Number of automatic storage paths          =   

Automatic storage path                           =   

      Node number                                    =  

      State                                                = 

      File system ID                                   = 

      Storage path free space (bytes)          = 

      File system used space (bytes)          = 

      File system total space (bytes)           =

Read More on DB2 database status

DB2 manager status and get snapshot for dbm

SQL0286N A default table space could not be found - DBA DB2

How to check for DB2 Direct IO and FILE SYSTEM CACHING - DBA ...

DB2 Database objects overviews - DBA DB2