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.5 New features
Includes improvements in support of Db2 for LUW
Adds binary column support for Db2 for LUW
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.
Improves synchronization script in DB Change Manager
When using Db2 for LUW in DB Change Manager, the synchronization script now applies the appropriate order to be more efficient.
Improves efficiency in DBArtisan, DB Change Manager, and Rapid SQL
DB PowerStudio 18.5 includes operational ease and efficiency improvements for DBArtisan, DB Change Manager, and Rapid SQL.
Updates stored procedures functionality when using Redshift
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.
Updates supported database versions
DB PowerStudio 18.5 adds support for the following database versions:
- Db2 for LUW 11.5.x (DBArtisan, DB Change Manager, and Rapid SQL)
- MySQL 8.0 and later (DBArtisan and Rapid SQL)
- PostgreSQL 14.x (DBArtisan, DB Optimizer, and Rapid SQL)
18.5 Fixed issues
| 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 |