DB2TOP replay


Actually DB2TOP is a real-time tool, however many DBA’s don’t know that it can be run in REPLAY mode with captured session information. So, next time you have a big crisis with your database, you can capture all the data from db2top and do the analysis afterwards.

How to capture the data? Option -C to capture. Press N to create a file. The option “-m” to gather data during n minutes.


defidb2:db2dfi 4> db2top -C -m 10
[18:20:30] Starting DB2 snapshot data collector, collection every 2 second(s), max duration unlimited, max file growth/hour 100.0M, hit to cancel...
[18:20:31] Writing to 'db2snap-DFI-AIX64.bin', should I create a named pipe instead of a file [N/y]?

 

You can also capture data on real-time, pressing “C”.

How to replay capture data? Option -f to indicate the file with the data collection:


> db2top -f db2snap-DFI-AIX64.bin

 

When you replay you could see the time/date when the data was gathered, and you can use db2top options on the normal way of use. Futhermore, you can skip entries during “n” seconds indicating as it follows:


> db2top -f db2snap-DFI-AIX64.bin +50

 

If you like this post write a comment or subscribe you to our feed to obtain future posts in your feed reader.

Comments

No comments.

Add a comment

(required)

(required)