DBArtisan Home | DBArtisan Documentation | Embarcadero Technical Support | www.embarcadero.com
ReadMe Last Published: June 21, 2012. Any updates to these notes will be available at http://docs.embarcadero.com.
Thank you for using Embarcadero DBArtisan, the award winning DBA tool for enterprise-wide database administration. DBArtisan empowers you to manage all of your critical databases running on current versions of Oracle, SQL Server, MySQL, Sybase ASE, and IBM DB2 across the UNIX, Linux, Windows NT and mainframe z/OS operating systems, from a single, consistent, user-friendly interface. Before you use DBArtisan, please read the information below.
What's New in Version 9.1/XE 3
Updated support for Microsoft SQL Server features
Updated support for Sybase features
DBMS Support and Connectivity
Dedicated Support Connectivity Options
DBMS Versions No Longer Supported
Release Notes
Additional Resources
Licensing Your Embarcadero Product
Embarcadero Technologies Product Support
Embarcadero Technologies Technical Support
Embarcadero Technologies on the Web
What's New in Version 9.1/XE 3
Sybase IQ Support
This release introduces support for Sybasse IQ, Sybase's column-oriented DBMS. This release will offer the following:
Connectivity Updates
In previous releases, DBArtisan connectivity was primarily restricted to native Embarcadero drivers. These proprietary drivers, packaged with DBArtisan, work in conjunction with a supported set of third-party clients that must be installed. While this remains the default, the Datasource Registration wizard now features a new Connect Using JDBC control that lets you specify a more direct connection that does not require a native client.
One or more Type 4 JDBC drivers for each supported platform are now packaged with DBArtisan.
DBArtisan queries the selected driver to determine the properties, options, or parameters that the Type 4 JDBC driver accepts. The Datasource Registration Wizard’s new Custom JDBC Properties panel lets you provide these name/value pairs.
DBMS Version Updates
DBArtisan now provides support for Sybase ASE version 15.5. All current DBArtisan functionality is now available on this platform version.
SQL Editor Updates
This release includes the following updates to the SQL Editor
Database Monitor Updates
Against Oracle datasources, the Database Monitor now offers a Long Operations tab. This tab shows statistics and status information from the Oracle V$SESSION_LONGOPS view. The primary criterion for inclusion of an operation oin the V$SESSION_LONGOPS view is an operation duration of six seconds or more.
Updated support for Microsoft SQL Server features
SQL Server currency updates for this release include:
Updated support for Sybase features
Sybase currency updates for this release include:
User interface improvements
This release continues the reworking of object editors and wizards. Aimed at improving workflow and the user interface experience, the new editors and wizards are being reworked for consistency. The following object editors/wizards were upgraded for this release:
DBMS SUPPORT AND CONNECTIVITY OPTIONS
DEDICATED SUPPORT CONNECTIVITY OPTIONS
DBArtisan provides dedicated connectivity to a specific version range of IBM DB2 for Linux, Unix, and Windows, IBM DB2 for z/OS, Microsoft SQL Server, MySQL, Oracle, and Sybase databases. The following connectivity options are provided:
The following table provides a summary of resources/requirements for connectivity to dedicated DBMS platforms. For each platform, it lists supported versions, the client software that must be installed if using native Embarcadero clients, and the third-party, Type 4 JDBC drivers packaged with DBArtisan.
DBMS Platform | Supported Versions | Client Required for use with native Embarcadero drivers | Packaged JDBC Driver |
---|---|---|---|
IBM DB2 for z/OS | v8 and v9 | DB2 UDB Client for Windows 8.0 or later | IBM Data Server Driver for JDBC |
IBM DB2 for LUW | Versions 8.0 - 9.7 | IBM DB2 LUW Client for Windows 8.0 or later | IBM Data Server Driver for JDBC |
Microsoft SQL Server | 2000
2005 (All editions including 2000 SDE and 2005 Express Edition for 32-bit x86 and 64-bit Itanium & x86-64) 2008 |
Microsoft SQL Server Client Library | jTDS Type 4 JDBC Driver for Microsoft SQL Server
Microsoft SQL Server JDBC Driver |
MySQL | 4.x | MySQL ODBC driver 3.5.1 - MySQL ODBC driver 4.x. | MySQL Connector/J JDBC Driver |
Oracle | Oracle 9i, 10g, and 11g | Oracle SQL*Net Client | Oracle JDBC Thin Driver |
Sybase ASE | Sybase System 12.5 - Sybase 15.5 | Sybase Open Client | jTDS Type 4 JDBC Driver for Microsoft SQL Server
Sybase jConnect JDBC Driver |
Sybase IQ | 12.7 - 15.4 | Sybase jConnect JDBC Driver for Sybase IQ |
DBMS VERSIONS NO LONGER SUPPORTED
As of this release, DBArtisan is no longer tested against Oracle 8i.
Release Notes
KNOWN ISSUES
BUG FIXES
Bugs Fixed in DBArtisan 9.1.1/XE 3 | ||
---|---|---|
Issue # | Description | DBMS |
DBA-17991 | DBArtisan gives error: OciTypeBinder-Cannot convert type to stream for xmltype column when user runs query against the table in ISQL window | All |
DBA-27328 | [Application] Saving results set in Excel format when opened in Excel says is in a different format than specified by the file extension. | All |
DBA-27480 | [Editor] FIND Feature occasionally does not save selected options such as "Match whole word only" | All |
DBA-27916 | [DB2][ISQL]Fail to execute sp | DB2 |
DBA-27922 | Extract of DB2 table results in no definition being returned | DB2 |
DBA-26358 | [Data Source Explorer] Slow response times when viewing objects | Oracle |
DBA-27234 | [Instance][ASM][Disk Group]Error opening ASM Disk group ETSQLException: ORA-01468: a predicate may reference only one outer-joined table | Oracle |
DBA-27911 | Top 20 SQL is not displayed in Database Monitor for Oracle datasource | Oracle |
DBA-27914 | [Data Source Explorer] Tables are not displayed from materialized views. | Oracle |
DBA-27074 | TS : [Monitor] When running Select for multiple tables, there are many runnable processes for DBArtisan opened in Database Monitor | SQL Server |
DBA-27231 | TS: [TRIGGER] The GUI shows that the Trigger Alter works on the second attempt | SQL Server |
DBA-27601 | [Schema Extraction]The extraction of Logins containing more than one user fails to create the permissions under the correct User | SQL Server |
DBA-27653 | [Schema Extraction] 9.0.1 extraction .sav file is not recognized by version 9.1.0 | SQL Server |
DBA-27691 | [SQL Execution] EXECUTION ERROR: Incorrect syntax near the keyword 'TRIGGER' and Incorrect syntax near 'ENABLE' | SQL Server |
DBA-27818 | ISQL - SQL Azure - Java error when doing a "SELECT * from table". | SQL Server |
DBA-27881 | [Connectivity]Unable to connect to datasource when "Use Network Library Configuration" is enabled | SQL Server |
DBA-27532 | [DBMS Object Management] SQL generated when adding space to a database is not in the correct order. | Sybase |
DBA-27660 | [DBMS Object Management] a value is shown in the creation date column when there is no creation date | Sybase |
DBA-27710 | [SQL Editor] Opening Lob data results fails to show complete data | Sybase |
Bugs Fixed in DBArtisan 9.1/XE 3 | ||
---|---|---|
Issue # | Description | DBMS |
DBA-12705 | [8.5.0#3529] - Change the interval of the Database Monitor per Database monitor and not for all | All |
DBA-15086 | DBArtisan is crashing during a search | All |
DBA-17807 | After a successful package compile, the main right pane refreshes the object status but the left Explorer pane does not, please make this consistent | All |
DBA-17991 | DBArtisan gives error: OciTypeBinder-Cannot convert type to stream for xmltype column when user runs query against the table in ISQL window | All |
DBA-18746 | [Schema Extraction][Format action]The Format action is wrong performed in the result of Schema Extraction on MS SQL and Sybase datasources | All |
DBA-19172 | DBArtisan is not able to keep setting change at File->Options->Editor->Syntax Color > Property->White Space->Background Color | All |
DBA-20659 | Change Colour of Blank space before SQL code | All |
DBA-22315 | Viewing the Print Preview of the query results display appears to be removing the Query tab | All |
DBA-22396 | The Generate Report topic needs to be updated, the Command dialog is not valid anymore | All |
DBA-23981 | [UI][Tools] Some main menu child-items appear to be disabled or unavailable uppon first item-list expansion if the "Menu animations" option is set to something other than "None" | All |
DBA-24123 | [Explorer][Filters] User created Filter fails to Filter objects when View by Object Owner is selected | All |
DBA-24595 | [Database Search] When using a File based datasource catalog the datasources are displayed incorrectly from the registries | All |
DBA-24733 | [Connectivity] The dsuri.xml file is causing connection issues when Change Manager and DBArtisan are on the same workstation | All |
DBA-25652 | [ISQL] Nested comments are't colored correctly , only the first end of comment is taken in consideration | All |
DBA-26498 | [SQL Editor][Code Assist] When typing alias and then selecting multiple fields, it includes the alias with the first select field but not the others | All |
DBA-26553 | [Tools] ception is added when selecting the column of an object with code complete enabled. | All |
DBA-26714 | TS[Script Execution]:Headings and first record are in the same row for CSV format | All |
DBA-26799 | [Application][ISQL] Incorrect value is set for the coloring and folding option when launching Avalon and restoring settings | All |
DBA-26970 | [Foreign Key creation wizard] Column Selection sort is not functioning | All |
DBA-26999 | [Problem Report] Crash when pressing File menu when running application for the first time | All |
DBA-17847 | [Database Objects] Only the properties and container tabs are enabled when opening up a tablespace or table object. | DB2 |
DBA-17993 | For DB861 - The Files:>Options:>Results:>Format:>Enable Locale reference doesn't seem to function. | DB2 |
DBA-20908 | Syntax error. Parser not recognizing DB2 TABLE function. | DB2 |
DBA-24042 | [Performance Analyst] Program Unable to perform lexical cast error in output window when clicking on Home, Memory, I/O, etc in Performance Analyst | DB2 |
DBA-24079 | [TableSpaces] Incorrect data is displayed in Space tab of DB2 tablespaces, for tablespaces created on multiple database partitions . | DB2 |
DBA-24845 | [ISQL] Code complete is not working when editing a script having a 9.7 DB2 client installed | DB2 |
DBA-24715 | [Schema Extraction][View Definition] Schema Extraction and object DDL Definition view can't parse argument number for a stored procedure | DB2 |
DBA-25107 | [DBMS Object Management] "for bit data" as part of the column definition in a stored procedure not recognized | DB2 |
DBA-26713 | SQL Parsing issue when attempting to create a stored procedure. | DB2 |
DBA-26733 | [Analyst]Viewing Tablespaces in Space Analyst shows a Script Error "Object does not support this property or method" | DB2 |
DBA-26766 | [Tablespace Max Size]Increasing the Max size of a tablespace to more than 1 GIG will result in a negative MAXSIZE value | DB2 |
DBA-27411 | [SQL Editor] Null values were eliminated from the argument of a column function. | DB2 |
DBA-26473 | [Explorer][Tables] Error is raised on populating the tables node under databases on zOS version 8 | DB2 z/OS |
DBA-12293 | Code Collapse not folding code in correct blocks | Oracle |
DBA-13760 | Update script that ran in DB815 no longer executes in DB850 | Oracle |
DBA-14054 | Pasting a large number of INSERT or UPDATE statements (18,000 or more) into an ISQL session pegs the CPU and makes any further edits impossible | Oracle |
DBA-14563 | Running script with 29000 Oracle grant statements maxes memory out. This script and scripts up to 55000 lines run fine in DB812 | Oracle |
DBA-14792 | DBMS output options does not allow to over ride the buffer size | Oracle |
DBA-15020 | Space Utilization is displaying a negative SIZE for INDEX | Oracle |
DBA-23298 | [Capacity Analyst]When installing CA, error occurs Capacity Analyst Repository does not exist on this server ORA-24344: success with compilation | Oracle |
DBA-24023 | [SQL Editor][Error line reporting] Editor error reporting pane fails to show line number of error | Oracle |
DBA-24161 | [Analysts] Error with date time in Capacity Planning | Oracle |
DBA-24213 | [Reorganize] In offline mode reorganize on the same table space should be possible | Oracle |
DBA-24348 | [Materialized Views] Extracted SQL doesn't produce the same result as DDL tab | Oracle |
DBA-24737 | [Stored Procedure] the editor doesn't keep the extra white lines added | Oracle |
DBA-25412 | [SQL Editor][Results] When saving query results as file format PPE, CSV, or TXT, the [NULL] is replaced by || or spaces | Oracle |
DBA-25741 | TS: [Results] Product crashes when sorting a VARCHAR column | Oracle |
DBA-25758 | [DBMS Actions] Extract of same user in Oracle 11 provides different results using same Oracle client. | Oracle |
DBA-26292 | [SQL Editor] LobEditor does not show contents | Oracle |
DBA-26546 | TS :[SQL EDITOR] Cannot Save or Save As a Query Plan | Oracle |
DBA-26705 | [Application]Slow performance opening ROLEs, compared to previous 815 release with 2-3 minutes in opening object | Oracle |
DBA-26798 | TS: "Use OMF" option is no longer available for datafiles in the tablespace editor | Oracle |
DBA-26853 | No progress bar when reogranizing tables | Oracle |
DBA-26996 | TS : [Schema extraction] When extracting a table, the LOB STORE AS statement is incomplete | Oracle |
DBA-27176 | [Schema Migration] Migrate operation fails when retaining a reference to a tablespace | Oracle |
DBA-27423 | [Capacity Analyst] When opening the Capacity Analyst, error "ORA-24347: Warning of a NULL column in an aggregate function" is written to the output message window. | Oracle |
DBA-14638 | Database search doesn't return table name while searching within views with certain JDBC drivers - error Ljava.lang.String | SQL Server |
DBA-21511 | Paste over highlighted text does not work correctly in database editor window | SQL Server |
DBA-21802 | Running update stats on a database causes a java heap space error | SQL Server |
DBA-22178 | After click on "Find Next" to search for string the 2nd time in the result set tab, DBArtisan hangs | SQL Server |
DBA-23346 | When writing a cursor and running it, application automatically inserts a blank line between results | SQL Server |
DBA-25417 | [Extract] Application crashes when extracting some objects on a clean machine | SQL Server |
DBA-25518 | [Procedure] - Comment in /* */ inside the ddl disappeared after a stored procedure was created in an ISQL window | SQL Server |
DBA-26811 | TS: DBArtisan crashes while scrolling down Top Sql Cache in Monitor for SQL Server 2008 R2 | SQL Server |
DBA-27088 | [Analysts] Cannot execute collection when database collations are different. | SQL Server |
DBA-7051 | DB80: Does not handle nested comments correctly , same for Rapid 7.3 | Sybase |
DBA-9034 | In the segment wizard, it should only show the device fragments belonging to the current database and not for all devices on the server | Sybase |
DBA-12508 | 'Default type' drop down in the table editor is displaying 'SUSER_SNAME' instead of 'SUSER_NAME' | Sybase |
DBA-12452 | DBA8.5.0 Build#3537: An Inappropriate 'Help page' is displayed on clicking 'Help' button for objects editor 'Set online, Checkpoint , Move Log ' for 'Database editor' in Sybase ASE 15.0 datasource | Sybase |
DBA-13114 | Results window will not allow you to select a part of a cell of data | Sybase |
DBA-16977 | When viewing results with tabs and newlines will sometimes show a little square box. | Sybase |
DBA-22439 | [Explorer] Explorer column headings intermittently disappear requiring user to refresh the view | Sybase |
DBA-22719 | [Editor] [Code assist] Content assist does not populate the list of columns when JOIN syntax exists in statement | Sybase |
DBA-23345 | [Extract] Incorrect SQL extract for logins that are bounded to an execution class | Sybase |
DBA-23636 | [Estimate Size] Estimated Table size is truncated for a table with over 150 million rows | Sybase |
DBA-26285 | [Table][Datatype] Unable to change column datatype when Identity Column option is selected | Sybase |
DBA-26390 | [Editor]Datatypes fail to be correctly highlighted in SQL Editor | Sybase |
DBA-26745 | [Tables] Create insert statements not working correctly on Interbase and Oracle | Sybase |
DBA-26763 | [Registration] Host is not found when registering a sybase datasource from SQL.ini file | Sybase |
DBA-26801 | Sybase Default Isolation levels | Sybase |
DBA-27000 | [Table][Column ALTER] Error when adding column, Cannot have both a default value and a default object bound to a column | Sybase |
DBA-27101 | [DBMS Object Management] Need to use third argument to specify when renaming index when a column with same name exists. | Sybase |
DBA-27134 | [Datasource Combo] Datasource combo doesn't get enabled when disconnecting from the server after the connection was forcibly killed | Sybase |
DBA-27252 | nvarchar column sizes are not properly calculated in the DDL View tab | Sybase |
DBA-27278 | Turn off SET QUOTED_IDENTIFIER ON/OFF in adhoc DDL Extract | Sybase |
DBA-27481 | Default Row Count Option not limiting rows in results | Sybase |
Additional Resources
Licensing Your Embarcadero Technologies Product
All Embarcadero Technologies products include a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. For information on licensing your product, refer to the DBArtisan Installation Guide. If you have not yet purchased your Embarcadero Technologies product, contact [email protected], or [email protected] for sales in the EMEA region.
Embarcadero Technologies Product Support
The Embarcadero Technologies Web site is an excellent source for additional product information, including white papers, articles, discussion forums, and the Embarcadero Knowledge Base. Visit www.embarcadero.com/support, or click any of the links below, to find:
Embarcadero Technologies Technical Support
If you have a valid maintenance contract with Embarcadero Technologies, the Embarcadero Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of Embarcadero Technologies products to download free software upgrades during the active contract period. Evaluators receive free technical support for the term of their evaluation (14 days).
We encourage you to open technical support cases via the Technical Support request form. For additional information about Embarcadero Technologies Technical Support, visit the Support section of our Web site.
Embarcadero Technologies on the Web
To download evaluations of other Embarcadero Technologies products or to learn more about our company and our products visit us at www.embarcadero.com.