View Source

This build of DB Optimizer includes many fixed issues, including the following updates.

18.3 New features

Updates Azure cloud monitoring capability in DBArtisan

The monitoring capability for Microsoft Azure cloud is updated in DBArtisan. This functionality includes multi-tabbed process monitoring and management as well as allows you to catch performance issues before they arise.

Supports the latest version of Log4j

DB PowerStudio 18.3 includes support for the latest version of Apache Log4j, which is essential for proper logging and diagnostics of applications.

Improves multiple areas within DBArtisan and Rapid SQL

DB PowerStudio 18.3 includes updates to the following areas within DBArtisan and Rapid SQL:

Extraction operations on roles for PostgreSQL allows users to have higher control over their data security.
Handling procedures with cascaded parameters on Redshift provides additional usage options with those parameters.
Connections to Azure SQL using multi-factor authentication provides more secure access.
Connections to PostgreSQL via Java Database Connectivity (JDBC) provides native connectivity for quicker access.
Reordering columns for Data Definition Language (DLL) validation allows the flexibility to rerun or reuse in scripts.

Improves multiple areas within DB Change Manager

Validation of Dump Devices, Linked Servers, Remote Servers and Server Triggers on Azure enables higher quality of those features.
Reuse of connection settings on logins when a node is accessible in SQL Server Management Studio (SSMS) allows faster user connections.
Fully populating database nodes on Azure for completeness.

Updates profiling session capability in DB Optimizer

DB Optimizer 18.3 updates profiling session capability, which alerts users to potentially problematic SQL ahead of time.

18.3 Fixed issues

Issue Number	Description	DBMS
DBA-34744	Log4J Upgrade all of DB PowerStudio
DBA-34743	DDL validation failing after reordering columns	Oracle
DBA-34682	Windows Authentication not working with Access Analyst	SQL Server
DBA-34605	Cannot connect to Azure SQL using MFA	Azure SQL
DBA-34524	Receiving an error when trying to connect to PostgreSQL	PostgreSQL
DBA-34244	User would like additional features for Azure support	Azure SQL
OPT-5352	Profiling session does not finish and seems to stall	Sybase ASE

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 in DBArtisan and Rapid SQL

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

Issue Number	Description	DBMS
DBA-34677	Issue when importing .xlsx files in DBArtisan 18.0	Sybase ASE
DBA-34675	Issue when opening tables in the DB2 Servers database
DBA-34674	Issue in DBArtisan when using Audit Unified Policies tree nodes in Oracle 19c and 21c	Oracle
DBA-34673	Performance issues in DBArtisan 18.0	Oracle
DBA-34672	DBArtisan 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-34665	DBArtisan does not recognize "lockless" cache types	Sybase ASE
DBA-34662	Permissions error when using Capacity Analyst	Sybase ASE

18.1 New features

Adds support for Oracle 21c and PostgreSQL 13 in DBArtisan and Rapid SQL

DBArtisan and Rapid SQL 18.1 add support for Oracle 21c and PostgreSQL 13. This release also includes a number of fixed issues that you may review in the Release Notes.

18.1 Fixed issues

Issue Number	Description	DBMS
DBA-34651	Update OpenJDK 11.0.7 to the latest OpenJDK 11 release
DBA-34650	Update PostgreSQL support to version 13	PostgreSQL
DBA-34649	Update Oracle support to version 21c	Oracle
DBA-34646	Provide ability to open multiple files from the command line
DBA-34644	Sybase ASE Syntax Drop Login, Alter Login not presenting with DDL Extract	Sybase ASE
RAP-6189	Format SQL Clears out commands	Sybase ASE
RAP-6188	Stored Procedure is not extracting correctly with Rapid SQL 17.1.1	Oracle, SQL Server

18.0 New features & fixed issues

The DB Optimizer 18.0 release includes no customer-reported bug fixes.