Which system tables can be queried to gather information about database health in DB2?

  • SYSIBM.SNAPDB
  • SYSIBM.SYSINDEXES
  • SYSIBM.SYSSTATS
  • SYSIBM.SYSTABLES
SYSIBM.SNAPDB is a system table that provides a snapshot of database health, including information about locks, buffer pool usage, and other vital statistics. Querying this table can help DBAs monitor and maintain the health of their DB2 databases. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *