Log4db2 is a logging utility for DB2 for LUW that uses SQL instructions with SQL PL code.

Its purpose is to provide an easy way to write messages from a SQL routine, with the possibility to query these messages directly from the database and view the generated output, allowing to monitor the progression of a process. This utility aims to reduce the time used for developing, testing, debugging and monitoring SQL routines, by centralizing the messages produced by the code.

The idea and architecture of this utility are based on the popular Java logging utilities, such as Log4j and slf4j/logback.

* Log4j [http://logging.apache.org/log4j]
* Logback/SLF4J [http://logback.qos.ch/] [http://www.slf4j.org/]

The license of the source code is "BSD 2-Clause license", and for the documentation is "FreeBSD Documentation license." With these two licences you are free to use, modify and distribute any part of this utility.


  • Based on the log4j architecture
  • Different log levels
  • Configurable logger levels
  • Independent configuration for appenders
  • Different type of appenders
  • Message pattern layout is configurable
  • Logger's hierachy to control the logger's level
  • Plugins system to create additional appenders
  • Completely configurable from the database
  • Configuration is changed dynamically
  • Sensitive information is not exposed
  • Traffic network is zero
  • Very low performance impact when a logger is not active
  • Easy administration
  • Configuration is stored in a memory cache
  • Maximum 3 levels of cascade calls
  • Installation is done with just the DDL / DML file
  • Written completely in SQL-PL
  • Transactions of short duration
  • Low quantity of lock generation
  • Commit independent - Autonomous transactions
  • Appender's configuration in XML documents
  • Frequent values cached in arrays to reduce IO

Project Activity

See All Activity >


Database, Testing, Logging

Follow log4db2

log4db2 Web Site

Other Useful Business Software

Find out what (or who) is slowing down your network Find out what (or who) is slowing down your network Icon
Find out what (or who) is slowing down your network Icon

Get comprehensive network bandwidth analysis and performance monitoring with SolarWinds® Bandwidth Analyzer Pack.

Network slow, but you don't know the cause? Use Bandwidth Analyzer Pack (BAP) to monitor and analyze network bandwidth performance and traffic patterns. With BAP, you can identify which users, applications, and protocols are consuming the most bandwidth. You can also monitor Wireless LAN Controller traffic to see what applications and clients are using your wireless network. Try it free for 30 days!

Rate This Project

Login To Rate This Project

User Reviews

Be the first to post a review of log4db2!

Additional Project Details



Intended Audience

Information Technology

User Interface

Console/Terminal, Command-line

Database Environment

IBM DB2, SQL-based