Welcome to DBArtisan® XE4 and DBArtisan® 9.5

DBArtisan Home | DBArtisan Documentation | Embarcadero Technical Support | www.embarcadero.com

ReadMe Last Published: Sept. 12, 2013. 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.5/XE4

Embarcadero Connect Integration

User Interface and Navigator/Explorer Updates

Oracle Updates

SQL Server Updates

Operational Updates

DBMS Support and Connectivity

Dedicated Support Connectivity Options

Generic JDBC/ODBC Connectivity

DBMS Versions No Longer Supported

Release Notes

Known Issues

Bug Fixes

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.5/XE4

Embarcadero Connect Integration

DBArtisan integrates with Embarcadero Connect, a product that allows easy distribution of data governance repository metadata to the enterprise. New Connect repository functionality includes:

Three new HKLM/HKCU registry settings (ConnectURL, UseConnect, and AllowKeepMeSignedIn) let you lock down those features.

User Interface and Navigator/Explorer Updates

Oracle Updates

SQL Server Updates

Operational Updates

A new command line startup switch, -R, lets you provide a platform-specific connection string when starting DBArtisan from the command line. For details, see the online Help topic Getting Started > Application Basics > Starting DBArtisan > Starting an Installed Version of DBArtisan from the Command Line.

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 9.0 - 9.7 IBM DB2 LUW Client for Windows 8.0 or later IBM Data Server Driver for JDBC
Microsoft SQL Server 2005 (All editions including 2005 Express Edition for 32-bit x86 and 64-bit Itanium & x86-64)

2008

2012

Microsoft SQL Server Client Library jTDS Type 4 JDBC Driver for Microsoft SQL Server

Microsoft SQL Server JDBC Driver

MySQL 4.x MySQL Connector/ODBC Driver 5.2.x Driver - MySQL Connector/ODBC driver 3.51.x Driver 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 SQL Anywhere ODBC drivers for Sybase IQ 12.7

Sybase IQ 32-bit ODBC drivers

Sybase jConnect JDBC Driver for Sybase IQ

GENERIC JDBC/ODBC CONNECTIVITY

Generic JDBC/ODBC connectivity to non-dedicated DBMS systems or non-database datasources is also provided. DBArtisan can connect to a datasource using a customer-provided, third-party JDBC version 3.0 or ODBC version 3.0 driver. Minimal DBArtisan functionality is provided, including a basic Explorer tree and SQL querying.

DBMS VERSIONS NO LONGER SUPPORTED

As of this release, DBArtisan is no longer tested against Microsoft SQL Server 2000 or IBM DB2 for Linux, Unix, and Windows 8.x.

Release Notes

KNOWN ISSUES


  • The current version of DBArtisan does not support the MySQL ODBC client that shipped with previous versions of DBArtisan. If DBArtisan crashes after connecting to a MySQL data source:
    1. Close DBArtisan.
    2. Uninstall the older MySQL ODBC client.
    3. Restart DBArtisan and try connecting to a MySQL datasource. You are prompted to install the MySQL client drivers.
    4. Follow the installation instructions to install the new driver.
  • Note that when debugging a procedure against an Oracle data source, DBartisan performs a compilation before debugging. During a compilation, Oracle invalidates referencing objects. For example, if procedures A2 and A3 both reference procedure A1, debugging procedure A1 in DBArtisan, will result in procedures A2 and A3 being invalidated.
  • In some situations the Database Monitor may prompt to connect to an already connected datasource if auto-connect is not enabled for that datasource
  • DBArtisan installs the incorrect stored procedures for Capacity Analyst for a Sybase 15 database. Please refer to this Knowledge Base article: www.embarcadero.com/jive/entry.jspa?externalID=1030&caID=2
  • For servers running on Sybase version 12.5.3a, the CREATE ENCRYPTION KEY and DECRYPT permissions do not display properly--they'll be shown as null. See Sybase's document CR392544 ("sp_helpprotect does not show privileges related to encryption keys."). This has been fixed in ASE version 12.5.3a/ESD#1 (now available as a download) and ASE version 12.5.4.
  • When you are using the Debugger:
  • The BCP (bulk copy) data movement option is disabled for cross-platform migration. In addition, to use the BCP in a Sybase-to-Sybase migration, the user must be logged in as System Administrator *or* the "select into/bulkcopy/pllsort" database option must be true on the target catalog. If this option is "false" on the target catalog, BCP will not appear as a data movement option for non-system users.
  • Schema migration jobs created in earlier versions of DBArtisan that were saved with a .migrate file extension must be re-created in DBArtisan 8.1 or later. Only migration jobs with a .sav extension can be reused.
  • DBArtisan is currently unable to create table names, column names, and check constraint names longer than 18 characters on an OS390 mainframe database.
  • On SQL Server 2005, the Browser component is disabled by default. With this service disabled, in DBArtisan you cannot reference SQL Server instances by name, only by port number. If you want the ability to reference SQL Server instances by name, you must enable this service on the server.
  • BUG FIXES

    <
    Bugs Fixed in DBArtisan 9.5/XE4
    Issue # Description DBMS
    DBA-4161 Sql toggle does not remember it's previous state in Database Monitor. All
    DBA-21912 When switch to database monitor window from other window in DBArtisan using navigation tabs, the monitor pane discard its contents and not refresh All
    DBA-29000 TS: DBArtisan goes to last opened tab instead of previously used tab when database monitor is closed. All
    DBA-29034 [Find Replace]Request to remove default Find Replace option "Match whole word only" All
    DBA-29464 [Crash Report] DBArtisan crashes when deleting a results column from a running query All
    DBA-29708 [Edit Data]Generate Insert Statements in Edit Data show NULL value fields as N'NULL' rather than NULL. All
    DBA-29067 [Migration] TIMESTAMP datatype should be mapped to DATETIME when migrating from DB2 to SQL Server / Sybase DB2
    DBA-29233 [DBMS Object Management] the list of tablespaces for a database only lists the tablespaces that are on the database partition. DB2
    DBA-29363 [Schema Extraction] LONG tablespace storage clause missing from Table extraction DDL DB2
    DBA-29271 [Datasource Registration][Generic JDBC][Custom Driver Properties] Navigating to previous\next tab does not work as expected. JDBC
    DBA-12177 When running a query that ran in DBArtisan 8.1 customer gets an error, Access denied - SUPER privilege MySQL
    DBA-26497 TS: Error 'Unknown system variable'sql_log_update' ' is returned for every executed query MySQL
    DBA-18031 DB Monitor process that checks for blocking locks is causing database to hang Oracle
    DBA-19834 [Users/Tablespace Nodes][Object population]COlumns in the right panel for Users and Tablespaces show N/A values on Oracle datasources. Oracle
    DBA-28852 [Oracle][Table]Missing Display of statistic information on table partitions Oracle
    DBA-28853 [Oracle][DBLINK]Display of the structures and data for involved synonyms remote tables (DB-links) is not apparent Oracle
    DBA-28879 Provide more information for Partitions Oracle
    DBA-28991 TS : Cannot alter the column data type NUMBER (x, 0) to NUMBER by deleting the width and scale Oracle
    DBA-29314 Table reorganize no longer includes index rebuild commands Oracle
    DBA-29345 [DBMS Object Management] cannot see the ALTER TABLE script of the Primary Keys and the Unique Keys Oracle
    DBA-29438 [Schema Extraction] Table location is are not being entirely extracted Oracle
    DBA-29444 [DBMS Object Management] When granting a role to a user, sometimes the Default Role header shows a YES and sometimes shows a NO. Oracle
    DBA-29462 [Data Editor] when data is edited the "Save current row " is grayed out Oracle
    DBA-29570 [DBMS Object Management] The Goto feature is not going to the line when specified Oracle
    DBA-29165 [Utilities][Database Restore]Database recovery wizard error when selecting Disk Directory and Name - The parameter is incorrect. SQL Server
    DBA-29435 Cannot execute extracted SQL Server procedure with comment lines containing Russian characters SQL Server
    DBA-15758 Problem exporting Nordic Characters to excel Sybase ASE
    DBA-27151 [Table Permission's tab]Can`t see all the Permisions on table on Sybase datasource. Sybase ASE
    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. Sybase ASE
    DBA-27524 [Data Source Explorer] When a user is writing to a table in db while listing tables in the explorer, application freezes, Sybase ASE
    DBA-27894 [DBMS Object Management] Error type when renaming table Number (207) Severity (16) State (4) Server (zpic) Procedure (sp_rename) Invalid column name 't'. Sybase ASE
    DBA-28321 [Explorer]Some role based security is not displaying accurately Sybase ASE
    DBA-28386 [Sybase 15.7] 'Invalid column name' error is displayed when dropping a user after the server is rebooted Sybase ASE
    DBA-28397 [DBMS Object Management] Role's object permissions tab does not show any permissions Sybase ASE
    DBA-29022 [Database segment graph] Segment pie chart missing, error no data available Sybase ASE
    DBA-29291 [Schema Extraction] Missing Permissions on View extraction Sybase ASE
    DBA-29298 [DBMS Object Management] the Last Password Change is showing with the actual date rather than the date which the user had changed his password. Sybase ASE
    DBA-29523 Database device drop results in opposite order than listed in UI. Sybase ASE
    DBA-29713 Error when using #included in the name of a temporary table Sybase ASE

    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 sales@embarcadero.com, or uk.sales@embarcadero.com 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.