Released: Sep 1, 2025

Updates in 19.0

Features

• Improves DDL Extraction
  • The DDL Extract tab now correctly displays all primary key constraints, including clustered keys, ensuring complete and accurate schema archives.
• Modernizes the user interface
  • The New Data Source wizard is updated for Windows 11, providing a more intuitive and visually-consistent experience.
• Improves role management in DB Optimizer
  • The DB Optimizer Users and Roles tab now supports seamless role modification, streamlining user and permission management, and...

Released: Apr 8, 2025

Updates in 18.9

Features

• Added the ability to keep NOT TRUSTED when modifying FK constraints:
  • DB2 for LUW users now can use the NOT TRUSTED function when modifying foreign key (referential) constraints. Trusted/not trusted context affects how your application server interacts with the database server.

Released: Jul 30, 2024

Updates in 18.7

Features

• Updated the Monitor button to open a separate tab rather than simply a frame.

Released: Nov 28, 2023

Updates in 18.5

Features

• Added binary column support for Db2 for LUW.
• Added support for the following database versions:
  • Db2 for LUW 11.5.x.

Released: May 24, 2023

Updates in 18.4

Features

• DB Optimizer now includes native Git version control. You must have Git installed on the system where you want to use DB Optimizer to utilize the native Git version control functionality. Users may use Git version control to:
  • Create projects.
  • Get the latest version.
  • Add a file or project.
  • Remove a file or project.
  • Check in a file or project.
  • Get history logs of files.

Fixes

• Output from migration does not create table.

Released: Dec 8, 2022

Updates in 18.3

Features

• Added support for the latest version of Log4j.
• Improved profiling session capability which alerts users to potentially problematic SQL ahead of time.

Released: Jul 20, 2022

Updates in 18.2

Features

• Added support for Microsoft Windows 11.

Released: Apr 16, 2022

Updates in 18.1

Features

• Updated OpenJDK 11.0.7 to the latest OpenJDK 11 release.
• Added the ability to open multiple files from the command line.

Released: Oct 17, 2020

Updates in 17.1

Features

• Updated real-time syntax checking and code formatting.

Released: Dec 13, 2017

Updates in 17

Features

• Added Windows Server 2016 OS support.
• Versionless licensing for easier upgrades.
• .msi version available for UI-free “headless” installation.

Fixes

• Bug fix for null pointer errors on shutdown.