Skip to content
This repository has been archived by the owner on Jul 22, 2024. It is now read-only.
Samuel Pizarro edited this page Mar 15, 2021 · 1 revision

Welcome to the db2-Locking_Events_Html_Report wiki!

Create a rich HTML report from your Db2 Locking event monitor data!

Easily generates useful reports to make your lock analysis easier:

  • Filter by different event types ( DeadLocks, LockTimeOuts or LockWaits )
  • Filter by range of event timestamps
  • Initial html layout allows you to easily make side-by-side comparison between lock participants and their activities. Take a look at our ScreenShots

Main Features

  • Replaces db2evmonfmt java tool completely!

  • pure SQL solution!

    I got tired to compile and deal with java issues over and over in order to use db2evmonfmt tool. This is a 100% SQL only solution.

  • Flexible

    If you already have a locking event monitor that saves to UE tables, no need to create new ones. This solutions allows you to specify the source UE table where the locking events are being saved when extracting the information.

  • Extensible

    Didn't like the html layout or format? Cool This solution allows you to easily extend and create new html reports with richer layouts and formats.

  • 2 main options to generate the html reports:

    • Save the html report into your remote workstation, by using EXPORT utility ;
    • Save the html report directly into a directory in the database server;

Pre-Requirements

Deployment

Generating Locking Reports