Creating the Deadlock Monitor (DB2 UDB for UNIX and Windows) 

Use

As long as the system cannot find an existing deadlock monitor, the message No Deadlock Monitor found on system <system_name> is displayed.

You then need to create and start the deadlock monitor.

Procedure

Call ...

       1.      Call the DBA Cockpit and choose Diagnostics  ® Deadlock Monitor in the navigation frame of the DBA Cockpit.

The Diagnostics  ® Deadlock Monitor screen appears.

       2.      Choose Create Deadlock Monitor.

The Create Deadlock Monitor: Introduction dialog box appears.

       3.      Choose Continue.

If you are using DB2 Version 8 FixPak 10 or higher, you can also specify the buffer size of the deadlock monitor.

       4.      On the second screen of the dialog box, choose the tablespace where the deadlock monitor tables should reside. The drop-down list displays all the tablespaces that are currently available.

The deadlock monitor works with an internal buffer that is allocated in the monitor heap of the database. If this buffer runs out of space or if the deadlock monitor gets flushed by the user, the recorded data is written to disk.

Depending on the system workload, the deadlock monitor tables can grow up to several GB in size. We therefore recommend that you use a separate tablespace managed by DB2’s automatic storage management.

       5.      Choose Create Monitor.

       6.      To start the deadlock monitor, choose Start Monitor.