The db2top tool, on each of its various screens, presents a subset of the full capabilities of the DB2 snapshot monitor. In this post, we’ll see how you can use the native snapshot feature to gain access to the full snapshot.
On most db2top screens, you can access the full native snapshot by holding the Shift key and pressing the ‘S’ key. Each screen produces a different kind of snapshot with some screens producing more than one and others not producing any at all.
The table below lists the various screens in db2top and the corresponding native snapshot.
Screen | Native snapshots |
---|---|
Database | get snapshot for dbm global |
get snapshot for db on <database name> global | |
Sessions | get snapshot for all applications global |
Details for agent | get snapshot for application agentid <agentid> global |
Tablespaces | get snapshot for tablespaces on <database name> global |
Bufferpools | get snapshot for bufferpools on <database name> global |
Tables | get snapshot for tables on <database name> global |
Dynamic SQL | get snapshot for dynamic sql on <database name> global |
Locks | get snapshot for locks on <database name> global |
Memory pools | N/A |
Statements | N/A |
Utilities | get snapshot for dbm global |
Partitions* | get snapshot for fcm for all dbpartitionnums at dbpartitionnum <partition number> |
get snapshot for database on <database name> at dbpartitionnum <partition number> | |
HADR | N/A |
Federation | N/A |
Bottlenecks | get snapshot for all applications global |
Skew Detection | N/A |
* You are prompted to specify the partition number before the snapshot is taken