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


Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Cookies use

This web uses cookies to enhance your user experience, collect anonymous usage statistics and integrate content from third-party services. If you continue browsing you are giving your consent for us to set cookies. More information.

Aviso de cookies