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) =