Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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-34651Update OpenJDK 11.0.7 to the latest OpenJDK 11 release
DBA-34650Update PostgreSQL support to version 13
DBA-34649Update Oracle support to version 21c
DBA-34646Provide ability to open multiple files from the command line
DBA-34644

Sybase ASE Syntax Drop Login, Alter Login not presenting with DDL Extract

RAP-6189

Format SQL Clears out commands

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 ASERAP-6189Stored Procedure is not extracting correctly with Rapid SQL 17.1.1