keithmmcdonald's channel

This video compares the output of the db2mtrk command with the db2top Memory screen. It covers current allocations, high watermarks, and maximum al...

Demonstrates the buffer pool hit ratio on the Bufferpools screen of db2top. To produce a hit ratio of 100%, we query a single row repeatedly to per...

Demonstration of the regular expressions (regex) feature of db2top. Covers basic regular expressions as well as the '.', '+', and '[]' metacharacte...

Demonstration of the Locks screen of db2top. Includes creating a lock chain, examining Application Status, Object Name, Locked By and Lock Count an...

Demonstration of the Watch feature of db2top. Includes watching statements from a given application, dumping database structure, and capturing all ...

Demonstration of changing column order on a db2top screen and preserving the new order by saving the configuration to the .db2toprc file (from http...

Demonstration of setting the sort order on a db2top performance report by launching db2top in interactive mode, setting the sort order, and saving ...

Demonstration of using cut & paste to specify a hash value for the db2top Dynamic SQL screen (from http://www.thekguy.com)