var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Monitoring performance,locks,querys in database.
Somebody can say me the commands to monitoring performance,locks, querys executing in database, monitoring memory. The release is DB2 V8.1.
Other Question, There is db2top for db2 release 8?
Thank you for advanced.
If I remember correctly, there are some functions that you can query or you can use the GET SNAPSHOT commands. Check the manuals. There is no db2top for V8.
db2top is available from db2 8.1 fixpak 17.
Visit the new-look IDUG Website
, register to gain access to the excellent content.
I agree that you will find db2top very useful for this.
Originally Posted by sathyaram_s
However after years of typing db2stop I find db2top to close for comfort. One little s and .....................
I alias db2top to dtop or somesuch so as to avoid an accidental instance shutdown.
Originally Posted by bitznbitez
SQL1025N The database manager was not stopped because databases are still active.