DB2 Monitor Event

1. What are the minimum permissions required to create an event monitor?
Dbadm Authority
SQLAdm Authority

2. What are the types of event monitors?

3. What is the purpose of the DB2 Flush Event Monitor eventmonitorname command?
Writes the current database monitoring data to the corresponding file

4. Is the command to turn the monitor on or off DB2 set event monitor Eventmonitorname State 0/1?
Yes
5. DB2 "SELECT Evmonname, Event_mon_state (evmonname) as state from syscat.eventmonitors" Can I check the status of my monitor?
Right

6. DB2 provides a total of three types of event Monitor. What are the three different?
Event Monitor in table Form, Event Monitor in file form, and event monitor in the form of a pipeline

7. When the database activity log is full, how can I use the DB2 monitoring method to locate the app that caused the log full?
Db.log_util

8. Please describe how to monitor and diagnose lock waits under DB2 v9.1,v9.5 and V9.7 respectively.

9. How to determine if a DB has a full table scan problem?

10. How do I find out what SQL statements are being executed by the currently running app in the database?

11. When the database is stuck, what tools need to be used and what data should be collected to do RCA before solving this problem?

12. If there is a problem with high CPU usage in a V9.5 DB2 instance, how will you diagnose it, please outline the idea.

13. How to view Db2diag records since 2014-03-26?

14. How can I tell if the deadlock event monitor Db2detaileddeadlock is turned on? If it is not open, how to open it? How do I format the data of the deadlock event monitor?

15. Describe the process of using Db2top to view the database lock chain.

16. How do I view all the locks held by an app?

17. How do I see what locks are waiting in the current database?

18. How do I see which locks are added to a table?

DB2PD How do I view tablespace information?
Db2pd-d dbname-tablespaces

DB2PD How do I see if the target server is a highly available schema?

21. How do I see if a backup recovery task is in progress?

22. Can I use this statement DB2 "select Tabname,colcount,status from Syscat.tables where Tabschema does like ' sys% ' ORDER by tabname ' View all User-defined (tabschema not-like ' sys% ') table status?

23. Can the storage state of the tablespace be viewed with DB2 get snapshot for tablespaces on XXX?

Db2top can monitor the status of the database in real-time, essentially through snapshot, and therefore has a certain impact on performance. Is this the right sentence?

DB2PD is a non-intrusive tool that reads information directly from memory, does not need to connect to the database, does not consume database engine resources, does not request locks, and has little impact on the performance of DB2. Is this the right sentence?

DB2 Monitor Event