Welcome to DBArtisan® XE3.5 and DBArtisan® 9.2

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

ReadMe Last Published: February 19, 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.2/XE3.5

Lockdown Mode

Connectivity Updates

UI/Explorer Updates

SQL Editor Updates

Command Line Startup

Updated support for IBM DB2 (LUW and z/OS) features

Updated support for IBM DB2 for Linux, Unix, and Windows features

Updated support for Oracle features

Updated support for Microsoft SQL Server features

Updated support for Sybase IQ features

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.2/XE3.5

Lockdown Mode

Registry location HKLM\Software\Embarcadero\DBArtisan\Admin now has the following entries that let you restrict certain fatures:

Connectivity Updates

UI/Explorer Updates

SQL Editor Updates

Command Line Startup

This release introduces command line startup of DBArtisan with switches letting you specify a datasource and credentials:

dbart.exe -D datasource -U username -P password

This is primarily aimed at identity management systems working in conjunction with DBArtisan. Such systems can be configured to start DBArtisan and connect to a specific datasource using credentials that are invisible to the user. Other applications that hide credentials, force connection to a specific datasource, or otherwise automate startup of DBArtisan can make use of this feature.

Updated support for IBM DB2 (LUW and z/OS) features

Updated support for IBM DB2 for Linux, Unix, and Windows features

Updated support for Oracle features

Updated support for Microsoft SQL Server features

Updated support for Sybase IQ features

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.2/XE3.5
    Issue # Description DBMS
    DBA-2210 The 'OK' button is not getting click after changing the Batch Delimiter in the Query Options window. All
    DBA-7796 DBA810 3097 does not load global tnsnames.ora file located on remote file server All
    DBA-7899 DB811 3125 BUG: Unable to send email notification for a scheduled job in DBartisan if your email client is Outlook 2003. All
    DBA-8049 DB812 3216 BUG The script execution facility output will no longer sort by column header listing All
    DBA-14632 When using Excel 2K to open Excel files created via DB852 the save as feature (in Excel 2K) tries to save the file as a web page. This used to work in DB813 All
    DBA-24779 Copy/paste from DBArtisan Log into PFE changes the text format All
    DBA-25096 [SQL EDITOR]Virtual resources are used up when editting a stored procedure 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-28239 [ETSQLX] Null values are incorrectly replaced with value 0(zero) for numeric columns when having a job with .xls extension All
    DBA-28286 Change name of table in extract preview dialog. All
    DBA-28734 Use TEMP variable for temporary files All
    DBA-10054 DB2 saves date-timestamps with milliseconds but DBArtisan generates insert statements that ignore the milliseconds DB2
    DBA-11227 Provide an option to change the CURRENT_PATH value for DB2 datasources DB2
    DBA-18981 DB2 UDB DDL Extraction issue with space formatting for a VIEW object DB2
    DBA-20845 [Tables][Edit Data] Inappropriate time is displayed for a TIME data type column on DB2 LUW / OS390 datasource DB2
    DBA-21558 Table Editor: tablespace tab appends the name of the tablespace versus refreshing when you select from the table dropdown to change the table. DB2
    DBA-21626 Getting "SQL2218N One or more parameters specified for the REORG utility is incompatible" when reorganize an index DB2
    DBA-23614 [Connectivity] Unknown database error DB2
    DBA-25745 [SQL Editor][Results] Inconsistent query return results 10-15 second delay at times DB2
    DBA-27840 [Database Objects] Partitioned indexes the indexes are not listed on the indexes tab DB2
    DBA-27917 [DB2][ISQL]Fail to create trigger DB2
    DBA-27922 Extract of DB2 table results in no definition being returned DB2
    DBA-28003 TS : The Select statement generated in the Paste SQL window for a stored procedure does not include the parameters DB2
    DBA-777 DT 37794 - DB811 BUG When doing a schema migration, when migrating triggers, it takes a long time and eventually pops up a java.lang.StackOverflowError Oracle
    DBA-15465 DBArtisan hangs when click on "Object Permissions" tab Oracle
    DBA-22918 [Object Extract][Object DDL View]Slow performance Opening table DDL View and performing extract Oracle
    DBA-23250 [Extract] Extract for Tablespace could not be generated, no datafile information message appears Oracle
    DBA-24512 [Tools] Error when running ETSQLX.exe utility Oracle
    DBA-24784 [SQL Editor][Query Plan] When executed SQL statements contain an error, Query Plan fails to appear and no error is reported Oracle
    DBA-27169 [DBMS Search] Failed to find string in database search 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-27342 TS [Utilities] Error 'IMP-00000: Import terminated unsuccessfully' returned during Database Import execution Oracle
    DBA-27635 [Tablespace] Order by size results don't line up correctly for very large objects Oracle
    DBA-27652 [DB Monitor]Kill Session command in DB Monitor is incorrect for Oracle RAC clustered database Oracle
    DBA-27765 [SQL Execution] Running statements using dbms_output has extraneous characters being displayed. Oracle
    DBA-27880 TS : The Analyze table option does not refresh the table information Oracle
    DBA-28098 [Connectivity]LDAP datasources fail to connect due to error, Alias could not be resolved Oracle
    DBA-28675 TS : Cannot send e-mail notification using Graphical Output in Script Execution Facility Oracle
    DBA-22224 SQL Server to SQL Server table migration fails when the table already exists on the target database. SQL Server
    DBA-24396 [DBMS Object Management] Errors when adding or modifying a SQL Agent job step containing quotes. SQL Server
    DBA-25182 [Utilities] Using wizard to restore a database produces a blank script 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-27614 [Application] When running a detailed report on a table and the field includes a datatype of nvarchar the size of the datatype doubles SQL Server
    DBA-27691 [SQL Execution] EXECUTION ERROR: Incorrect syntax near the keyword 'TRIGGER' and Incorrect syntax near 'ENABLE' SQL Server
    DBA-27881 [Connectivity]Unable to connect to datasource when "Use Network Library Configuration" is enabled SQL Server
    DBA-27882 [Schema Extraction] Viewing and extracting function does not work SQL Server
    DBA-27895 [DBMS Object Management] Error when adding column to table and selecting data type. -- ConnectionDef is required SQL Server
    DBA-28893 TS : Blocking Locks are not populated on MS SQl servers SQL Server
    DBA-29020 [Data Unload] use BCP Utitlity”option does not work SQL Server
    DBA-10290 Not able to change default database or Full Name for user SA under Sybase Sybase ASE
    DBA-10593 SQL Query results with pre-formatting written into the query do not save properly in MS Excel 2000 format Sybase ASE
    DBA-16758 SQL Extract' no longer extracts primary key constraint for views in Sybase Sybase ASE
    DBA-21714 SQL Assist does not handle datepart (calweekofyear...) Sybase ASE
    DBA-22256 An unexpected token "@dboID" was found. Expected DOUBLE_QUOTED_LITERAL Sybase ASE
    DBA-23611 [Database Monitor] The load/refresh on Blocking Locks throws an error after changing the server Sybase ASE
    DBA-24214 [SQL Editor] Application crashes while editing in ISQL window. Sybase ASE
    DBA-25496 [Data Unload Load] Support to run the Sybase BCP utility with Kerberos authentication Sybase ASE
    DBA-26231 [Indexes/UK/PK] Statistics data are not displayed Sybase ASE
    DBA-26551 TS: Unable to deploy Performance Analyst procedures to database when datasource has a different name. Sybase ASE
    DBA-26800 Comments from a procedure are being removed Sybase ASE
    DBA-27518 [DB Monitor] On Sybase 15.7 instance, the 'kill' option is greyed out when SQL Toggle is enabled Sybase ASE
    DBA-27532 [DBMS Object Management] SQL generated when adding space to a database is not in the correct order. Sybase ASE
    DBA-27710 [SQL Editor] Opening Lob data results fails to show complete data Sybase ASE
    DBA-27912 [Sybase]An incorrect default binding is added to a column having a default value from the 'backup' table generated by extended alter Sybase ASE
    DBA-27945 Extract of Sybase Database user does not include sp_addlogin statement. Sybase ASE
    DBA-28110 [SQL Editor] Paste SQL Statement feature is pasting duplicate parameters[SQL Editor] Paste SQL Statement feature is pasting duplicate parameters Sybase ASE
    DBA-28144 [Connection] Error on connection with Sybase jConnect Driver JZ0LA: Failed to instantiate Cipher object. Transformation RSA/NONE/OAEPWithSHA1AndMGF1Padding is not implemented by any of the loaded JCE providers. Sybase ASE
    DBA28411 Results from complex queries are not exported to Excel Sybase ASE
    DBA-28421 Drop of Sybase Device doesn't include "If Exists..." statement. Sybase ASE
    DBA-28699 TS: Extract SQL is not generating the correct DDL for FK Sybase ASE
    DBA-28854 [Role][Extract] Incorrect "use " statement is added to the Extract script when having a default database set different than master - Sybase Sybase ASE
    DBA-28959 Kerberos Principle server should be empty. Do not pre-populate for Sybase connection. Sybase ASE
    DBA-28848 [Sybase IQ] Include storage option is incorrectly applied when performing an ad-hoc migration to Sybase ASE Sybase IQ

    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.