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.9 New features
Improves the Recent Project menu selection
DBArtisan 18.9 increases the number of projects appearing in the Recent Projects. This increase improves the user experience by providing more choices for a quick selection.
Adds the ability to keep NOT TRUSTED when modifying FK constraints
DB2 for LUW users now can use the NOT TRUSTED function when modifying foreign key (referential) constraints. Trusted/not trusted context affects how your application server interacts with the database server.
Improves performance for DB2 users
This release of DBArtisan and Rapid SQL can take advantage of performance improvements for DB2 users with updates to:
- tablespaces to allow null values, allowing users to formulate queries easily to allow for calculations by not including empty rows.
- the tablespace partition by range, ensuring accurate data and avoiding bottlenecks.
Includes enhanced Sybase optimization in DB Optimizer
DB Optimizer users will notice updated profiling to accurately show the sessions.
18.9 Fixed issues
| Issue Number | Description | DBMS |
|---|---|---|
| DBA-34820 | Resolves an issue preventing indexes from appearing on the Indexes table of a Table. | Azure SQL DB |
| DBA-34912 | Adds a new NOT TRUSTED function when modifying foreign key (referential) constraints. | DB2 for LUW |
| DBA-34914 | Resolves an issue causing Tablespaces to display null values when running queries against DB2 databases. | DB2 for LUW |
| DBA-34916 | Resolves an issue causing an empty Space tab when viewing some database segments. | |
| DBA-34920 | Provides the ability to increase the number of files in the Recent Project menu. | |
| DBA-34948 | Resolves an issue preventing some users from opening or extracting Views. | ALL |
| DBA-34950 | Supports UI text size comparable to the browser font size. | |
| OPT-5390 | Resolves a DB Optimizer issue preventing some Sybase users from viewing content when performing a session profile. | Sybase |
| RAP-6257 | Resolves a Rapid SQL installation error indicating you must install MS Visual C++ redistributables. | ALL |