DB2 Snapshot information | Monitor level : Database

In this article we will see and learn how to get snapshot information about databases and instances for monitor level Database.

1) get snapshot for database on dbname : Database level information and counters for a database. Information is returned only if there is at least one application connected to the database.

Example :

db2 connect to <db_name>
db2 get snapshot for database on <db_name>

2) get snapshot for all databases : Database level information and counters for each database active on the partition. Information is returned only if there is at least one application connected to the database.

Example:

Db2 get snapshot for all databases

3) list active databases : The number of connections to each active database. Includes databases that were started using the ACTIVATE DATABASE command, but have no connections.

Example:

db2 list active databases

4) get snapshot for dcs database on dbname : Database level information and counters for a specific DCS database. Information is returned only if there is at least one application connected to the database.

Example:

db2 get snapshot for dcs database on <db_name> 

5) get snapshot for remote database on dbname : Database level information and counters for a specific federated system database. Information is returned only if there is at least one application connected to the database.

Example:

db2 get snapshot for remote database on BFENT

6) get snapshot for all remote databases : Database level information and counters for each active federated system database on the partition. Information is returned only if there is at least one application connected to the database. Example:

db2 get snapshot for all remote databases

In next post we will see DB2 Snapshot information | Monitor level : Application. Please Like, Follow, Share & Subscribe.