db2top Native Snapshot

Snapshot of a database

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.

ScreenNative snapshots
Databaseget snapshot for dbm global
get snapshot for db on <database name> global
Sessionsget snapshot for all applications global
Details for agentget snapshot for application agentid <agentid> global
Tablespacesget snapshot for tablespaces on <database name> global
Bufferpoolsget snapshot for bufferpools on <database name> global
Tablesget snapshot for tables on <database name> global
Dynamic SQLget snapshot for dynamic sql on <database name> global
Locksget snapshot for locks on <database name> global
Memory poolsN/A
Utilitiesget 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>
Bottlenecksget snapshot for all applications global
Skew DetectionN/A

* You are prompted to specify the partition number before the snapshot is taken

If you enjoyed this post, make sure you subscribe to my RSS feed!
  • Search