SQLE 2.2305.0-pre2 Release Notes: New DB2 Metadata and TOP SQL Scanning Features

SQL audit tool SQLE 2.2305.0-pre2 has been released, offering a platform for database users and administrators that supports multi‑scenario auditing, a standardized release workflow, native MySQL audit, and extensible support for additional database types.

Project resources:

Type

Link

Repository

https://github.com/actiontech/sqle

Documentation

https://actiontech.github.io/sqle-docs-cn/

Release information

https://github.com/actiontech/sqle/releases

Audit plugin development guide

https://actiontech.github.io/sqle-docs-cn/3.modules/3.7_auditplugin/auditplugin_development.html

Community demo (admin/admin)

http://demo.sqle.actionsky.com

Enterprise demo (admin/admin)

http://demo.sqle.actionsky.com:8889

New version main features

DB2 table‑metadata scanning task (Enterprise) – Scans tables for missing comments, unnamed columns, unreasonable indexes, missing primary keys, etc., and provides optimization suggestions. Users can create a scanning task, have SQLE store results, and schedule periodic audits.

Steps:

Create a scanning task; SQLE stores the query results and audits according to the configured cycle.

View collected SQL in the task details and click “Audit Now” to generate a report.

DB2 TOP SQL scanning task (Enterprise) – Identifies the most resource‑intensive SQL statements in DB2, offering metrics such as execution count, total elapsed time, average elapsed time, and average CPU time, enabling regular optimization to maintain database performance.

Execution count (num_exec)

Total elapsed time (total_elapsed_time_ms)

Average elapsed time (avg_elapsed_time_ms)

Average CPU time (avg_cpu_time_ms)

Usage steps mirror the metadata scanning task: create the task, collect SQL, and generate a report.

Additional DB2 audit rule support (Enterprise) – New audit rules allow DB2 instances to be incorporated into the SQL audit workflow, meeting daily monitoring needs.

Release Notes

Features

[#1494] Added DB2 TOP SQL and table‑metadata intelligent scanning types (Enterprise).

Optimizations

[#1399] Fixed an error when indexes contain uppercase letters during work‑order creation.

Previous versions and recommended reading links are provided for further exploration.