This build of DB Optimizer includes many fixed issues, including the following updates.
This release of DB PowerStudio includes binary column support for Db2 for LUW, which enhances efficiency, performance, and storage utilization in DBArtisan, DB Change Manager, and Rapid SQL.
When using Db2 for LUW in DB Change Manager, the synchronization script now applies the appropriate order to be more efficient.
DB PowerStudio 18.5 includes operational ease and efficiency improvements for DBArtisan, DB Change Manager, and Rapid SQL.
Redshift users of DBArtisan and Rapid SQL can take advantage of stored procedures which are now added to allow parameter nodes. You now can route these particular requests through the nodes if it satisfies the predicate, allowing more control for the user.
DB PowerStudio 18.5 adds support for the following database versions:
Issue Number | Description | DBMS |
---|---|---|
DBA-34863 | Resolves an issue with DBArtisan where BINARY and VARBIN string types are not supported | Db2 for LUW |
DBA-34859 | Adds support PostgreSQL 14.x | PostgreSQL |
DBA-34844 | Adds support Db2 LUW - 11.5.x | Db2 for LUW |
DBA-34814 | Adds support MySQL 8.0 or latest release | MySQL |
DBA-34658 | Resolves an issue preventing some Redshift users from editing parameters for Stored Procedures | Amazon Redshift |
DBA-34657 | Resolves an issue causing DBArtisan to not display all Redshift parameter modes when creating a Stored Procedure | Amazon Redshift |
DBA-34618 | Resolves an issue causing an error for some PostgreSQL 12.3 users when they double-click a domain to open the editor | PostgreSQL |
SC-14832 | CHANGE MANAGER: Resolves an issue causing only two tables to appear in Mapping and Materialized Query Tables | Db2 for LUW |
DBArtisan and Rapid SQL now include native Git version control. You must have Git installed on the system where you want to use DB PowerStudio to utilize the native Git version control functionality.
Users may use Git version control to:
DB PowerStudio 18.4 includes support for SQL Server 2022.
This release of DBArtisan includes updates that improve space, capacity, and performance for Azure SQL and PostgreSQL.
DBArtisan and Rapid SQL now include sign-on capability for AzureAD for PostgreSQL, MySQL, and SQL Server.
DBArtisan and Rapid SQL now include support for PostgreSQL identity columns.
DB Change Manager/Data Compare includes updated support for Azure SQL for data copying. For more information about DB Change Manager, see DB Change Manager Wiki.
Issue Number | Description | DBMS |
---|---|---|
DBA-34810 | Output from migration does not create table. | Db2 |
DBA-34792 | Error message "Incorrect syntax near 'Index' " appears when dropping the Foreign Key between two tables. | SQL Server |
DBA-34788 | Unable to drop an index on Azure SQL DB. | Azure SQL |
DBA-34784 | Descending sort order is missing when editing properties of an index. | Azure SQL, Oracle |
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.
DB PowerStudio 18.3 includes support for the latest version of Apache Log4j, which is essential for proper logging and diagnostics of applications.
DB PowerStudio 18.3 includes updates to the following areas within DBArtisan and Rapid SQL:
DB Optimizer 18.3 updates profiling session capability, which alerts users to potentially problematic SQL ahead of time.
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 |
DB PowerStudio 18.2 adds support for Snowflake in DBArtisan and Rapid SQL.
DB PowerStudio now supports the Microsoft Windows 11 operating system.
This release of DB PowerStudio includes updated support in DBArtisan and Rapid SQL for the following database platforms:
This release of DB PowerStudio includes updated trial licensing support for DB Optimizer to limit the number of suggestions a user can submit.
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 |
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.
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 |
The DB Optimizer 18.0 release includes no customer-reported bug fixes.