IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Performance tuning > Tivoli Data Warehouse > Relational database design and performance tuning for DB2 Database servers > Monitor tools > SNAPSHOT and EVENT monitors
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
SNAPSHOTs
Use the GET SNAPSHOT command to collect status information and format the output for your use. The returned information represents a snapshot of the database manager operational status at the time the command was issued.
Various formats of this command obtain different kinds of information, and the specific syntax can be obtained from the DB2 Command Reference. The following formats are useful:
- GET SNAPSHOT FOR DATABASE
- Provides general statistics for one or more active databases on the current database partition.
- GET SNAPSHOT FOR APPLICATIONS
- Provides information about one or more active applications that are connected to a database on the current database partition.
- GET SNAPSHOT FOR DATABASE MANAGER
- Provides statistics for the active database manager instance.
- GET SNAPSHOT FOR LOCKS
- Provides information about every lock held by one or more applications connected to a specified database.
- GET SNAPSHOT FOR BUFFERPOOLS
- Provides information about buffer pool activity for the specified database.
- GET SNAPSHOT FOR DYNAMIC SQL
- Returns a point-in-time picture of the contents of the SQL statement cache for the database.
You can create some simple scripts and schedule them to get periodic snapshots during your test cycles.
Parent topic:
SNAPSHOT and EVENT monitors