actiontech/sqle-db2-plugin

this a DB2 SQL audit plugin for SQLE

中文文档

SQLE DB2 Plugin

This is A DB2 SQL audit for SQLE, which is an SQL audit platform.

1. Add Rule

You can define a rule in coresponding file, and then add it to the plugin by AddRule() method. More details please refer to docs.

2. Build Binary

Docker compile

execute make docker_install

The binary file is located in bin/ folder, and you can use it to audit your database.

3. Prepare the plugin runtime environment

1. Download the driver on the machine deployed by SQLE

   curl -L https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/linuxx64_odbc_cli.tar.gz -o /opt/sqle/linuxx64_odbc_cli.tar.gz

2. Unzip the driver

   tar zxvf /opt/sqle/linuxx64_odbc_cli.tar.gz -C /opt/sqle/

3. Add environment variables for sqled

   systemctl set-environment "LD_LIBRARY_PATH=/opt/sqle/clidriver/lib"

4. Restart sqled

   systemctl restart sqled

4. Begin to use

More details please refer to docs.