Log4db2 is a logging utility for DB2 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, 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 licenses of this project are:

* For the source code is "BSD 2-Clause license".
* For the documentation is "FreeBSD Documentation license."

With these two licenses you are free to use, modify and distribute any part of this
utility.

Author:

Andres Gomez Casanova

Features

  • 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 Samples

Project Activity

See All Activity >

License

BSD License, Public Domain

Follow log4db2

log4db2 Web Site

Other Useful Business Software
Simplify IT and security with a single endpoint management platform Icon
Simplify IT and security with a single endpoint management platform

Automate the hardest parts of IT

NinjaOne automates the hardest parts of IT, delivering visibility, security, and control over all endpoints for more than 20,000 customers. The NinjaOne automated endpoint management platform is proven to increase productivity, reduce security risk, and lower costs for IT teams and managed service providers. The company seamlessly integrates with a wide range of IT and security technologies. NinjaOne is obsessed with customer success and provides free and unlimited onboarding, training, and support.
Learn More
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of log4db2!

Additional Project Details

Languages

English

Intended Audience

Information Technology

User Interface

Console/Terminal, Command-line

Database Environment

IBM DB2, SQL-based

Registered

2014-01-31