DB Optimizer 17.0.1 and later cannot use any workspaces produced by previous DBO versions, nor use any files created by those older workspaces.

DB Optimizer provides the following new features and fixed issues. For items introduced or fixed in an earlier release, see Previous features and fixed issues.

18.2 New features

Adds support for Snowflake in DBArtisan and Rapid SQL

DB PowerStudio 18.2 adds support for Snowflake in DBArtisan and Rapid SQL.

Adds support for Windows 11

DB PowerStudio now supports the Microsoft Windows 11 operating system.

Updates database platform support

This release of DB PowerStudio includes updated support in DBArtisan and Rapid SQL for the following database platforms:

  • DB2 LUW 11.5
  • Sybase IQ 16.1

Updates trial licensing in DB Optimizer

This release of DB PowerStudio includes updated trial licensing support for DB Optimizer to limit the number of suggestions a user can submit. 

18.2 Fixed issues

There are no new features in this release of DB Optimizer, but there are the following fixed issues in DB PowerStudio.

Issue NumberDescriptionDBMS
DBA-34677Issue when importing .xlsx files in DBArtisan 18.0Sybase ASE
DBA-34675Issue when opening tables in the DB2 Servers database
DBA-34674Issue in DBArtisan when using Audit Unified Policies tree nodes in Oracle 19c and 21cOracle
DBA-34673Performance issues in DBArtisan 18.0Oracle
DBA-34672DBArtisan is missing security roles and MQT extraction 

DB2 for LUW

DBA-34667

Sybase ASE Data Cache window does not properly show bound objects in the cache

Sybase ASE

DBA-34666

DBArtisan displays incorrect Create Date for individual logins

Sybase ASE
DBA-34665DBArtisan does not recognize "lockless" cache typesSybase ASE
DBA-34662Permissions error when using Capacity AnalystSybase ASE