How to reset snapshot monitors on DB2

A snapshot monitor captures information about a database and connected applications at a given time.

Use a snapshot monitor when:

1) You want to capture database information at a specific point-in-time

2) You want to observe trends. Also, allows you to forecast problems

3) Troubleshoot database performance problems during a known time period.

4) Ad-hoc database health review

To reset the snapshot monitors on DB2 perform the commands below:

Syntax :

db2 attach to <instance_name>

Example :

db2inst1@HP06Ubuntu:~$ db2 attach to db2inst1

   Instance Attachment Information

 Instance server        = DB2/LINUXX8664 11.5.0.0
 Authorization ID       = DB2INST1
 Local instance alias   = DB2INST1

Syntax:

db2 reset monitor for database <db_name>

Example:

db2inst1@HP06Ubuntu:~$ db2 reset monitor for database BFENT
DB20000I  The RESET MONITOR command completed successfully.
db2inst1@HP06Ubuntu:~$ 

Syntax:

db2 reset monitor all

Example:

db2inst1@HP06Ubuntu:~$ db2 reset monitor all
DB20000I  The RESET MONITOR command completed successfully.
db2inst1@HP06Ubuntu:~$ 

That's all in this article. Please LIKE, SHARE & SUBSCRIBE to get more content like this.