Welcome to DBArtisan® XE6 and DBArtisan® 9.7.2

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

ReadMe Last Published: Nov. 11, 2014. 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 IBM DB2, Oracle, PostgreSQL, Microsoft SQL Server, MySQL, Sybase, and Teradata systems, from a single, consistent, user-friendly interface. Before you use DBArtisan, please read the information below.

What's New in Version 9.7/XE6

PostgreSQL Support

Backup Analyst Support Discontinued

Technical Requirements

Browser Requirements

Hardware Requirements

Operating System Requirements

32-bit versus 64-bit Application Considerations and Restrictions

DBMS Support and Connectivity

Dedicated Support Connectivity Options

Generic JDBC/ODBC Connectivity

Specifically-tested JDBC/ODBC Connectivity Products: Apache Hive/Hadoop

Release Notes

Important Advisory 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.7/XE6

PostgreSQL Support

This release introduces support for PostgreSQL datasources, PostgreSQL version 9.3 and higher. Connectivity is available with the PostgreSQL ODBC Driver (version 9.02 minimum) or with the pre-packaged PostgreSQL JDBC Driver. Functionality as of the current release is as follows:

Backup Analyst Support Discontinued

As of this release, the Backup Analyst feature is no longer supported.

TECHNICAL REQUIREMENTS

Before using DBArtisan, please verify that your environment meets the requirements listed below:

NOTE: Users need full registry privileges during the installation and access to the keys under HKEY_CURRENT_USER in the registry after installation.

BROWSER REQUIREMENTS

DBArtisan requires Microsoft Internet Explorer 7 or later.

HARDWARE REQUIREMENTS

Embarcadero Technologies recommends the following minimum hardware requirements:

OPERATING SYSTEM REQUIREMENTS

DBArtisan supports the following operating systems:

XP Support Notes - Windows XP has two user security groups: Users and Power Users. Microsoft intentionally does not grant members of the Users Group the authority to install applications or make global changes to the system. Restricted Users are members of the Users Group. Standard users belong to the Power Users Group. Microsoft grants members of the Power Users Group the authority to install programs. You must be a member of the Administrators Group in order to install and use Embarcadero Technologies applications. Because Restricted Users are members of the Users Group, they cannot install and run Embarcadero Technologies applications.

Use the Group Membership tab to determine your group and review the Microsoft security guidelines. On the Control Panel, open User Accounts. On the Users tab, select a user and then click the Properties button. Click the Group Membership tab.

Vista and Windows 7 Support Notes - Windows Vista UAC and Windows 7 provide two user types: Standard users and Administrators. DBArtisan can be installed or uninstalled by an administrator or by a standard user using an administrator token. Standard users can run DBArtisan. For the purpose of running DBArtisan, default standard user token privileges should not be modified. Modifying standard user token privileges can result in licensing issues which will prevent DBArtisan from operating properly.

32-BIT VERSUS 64-BIT APPLICATION CONSIDERATIONS AND RESTRICTIONS

If you install the 64-bit version of DBArtisan and you are using custom drivers, you must be using 64-bit versions of those drivers when using the 64-bit version of DBArtisan. Similarly, 32-bit versions of custom drivers must be used with the 32-bit DBArtisan installation.

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, PostgreSQL, Oracle, Sybase, and Teradate 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, v9, and v10 DB2 UDB Client for Windows 9.0 or later IBM Data Server Driver for JDBC
IBM DB2 for LUW Versions 9.0 - 10.0 IBM DB2 LUW Client for Windows 9.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, 11g, and 12c Oracle SQL*Net Client Oracle JDBC Thin Driver
PostgreSQL 9.3 minimum
Specifically-supported PostgreSQL-based database products include Greenplum, Pivotal HAWQ, and BigSQL.
PostgreSQL ODBC Driver (latest version recommended) PostgreSQL JDBC Driver
Sybase ASE Sybase System 12.5 - Sybase 15.7 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
Teradata 13.10, 14, and 14.10 Teradata ODBC driver for Windows (version 14 recommended) Teradata JDBC Driver

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.

SPECIFICALLY-TESTED JDBC/ODBC CONNECTIVITY PRODUCTS: APACHE HIVE/HADOOP

DBArtisan has been successfully tested against Apache Hive/Hadoop datasources using the Hortonworks ODBC driver. Similarly, Cloudera Impala datasources have been tested using the Cloudera JDBC driver. In both cases, SQL querying and a Datasource Explorer/Navigator tree are available.

RELEASE NOTES

IMPORTANT ADVISORY NOTES

KNOWN ISSUES


  • If the Retain View Settings is enabled and DBArtisan is shut down with more than 10 datasources actively connected, the application may crash after the next start up. To avoid this, either disable Retain View Settings or ensure that not more than 10 datasources are connected when shutting down.
  • 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.7.2/XE6
    Issue # Description DBMS
    DBA-29996 [Query Plan] Query Explain Plan doesn't work on some Oracle servers with the native driver, error Execution ORA-01453: SET TRANSACTION must be first statement of transaction Oracle
    DBA-30717 [DBMS Objects] Viewing Login, Users missing from Users tab even though they appear in database Sybase ASE
    DBA-30948 [Schema Extraction] When extracting DDL for Server logins in Sybase, not all user databases are appearing in extract or the display Sybase ASE
    DBA-31321 [SQL Editor] Saving from results tab writes over the Query, saving from Query tab tries to write over results just saved. ALL
    DBA-31335 Error ORA-06550: line 1, column 23: PLS-00306 when running a function from the package Oracle
    DBA-31351 Results figures are rounded up when query is scheduled (they appear unrounded when query executed manually) Oracle
    DBA-31359 [SQL Editor] Save results is changing document file ALL
    DBA-31363 Oracle error ORA-06550 when running SQL Code (works in 9.6.1) Oracle
    DBA-31367 [Build/Install] Unable to launch DBArtisan after install ALL
    DBA-31402 Procedures with no parameters in package are not being displayed Oracle
    DBA-31409 [Enhancement] SQL Editor results saved to Excel will not autofit columns any more ALL
    DBA-31424 [DBMS Actions] When scrolling quickly horizontally through columns in a Results tab the headers don't keep pace. ALL
    DBA-31430 Migration Wizard cannot find BCP Sybase ASE
    DBA-31453 [Detail Report] Sybase table reports Space as 0 MB at “Table Usage (MB)” Sybase ASE
    Bugs Fixed in DBArtisan 9.7.1/XE6
    Issue # Description DBMS
    DBA-30090 [Data Source Explorer] Unable to connect via LDAP Oracle
    DBA-31080 [SQL Editor] Auto Indent does not work sometimes ALL
    DBA-31081 [SQL Editor] Home key does not work correctly ALL
    DBA-31096 [SQL Editor] In a table with a column of type UROWID, select * results in a "ORA-01406: fetched column value was truncated" error Oracle
    DBA-31098 [Utilities] Duplicate rows appear in a RAC database monitor session Oracle
    DBA-31106 [DBMS Actions] Changing a user's password is getting prompted to be in the master database Sybase ASE
    Bugs Fixed in DBArtisan 9.7/XE6
    Issue # Description DBMS
    DBA-2827 DBA813 3229: An error message is displayed on inserting an Identity column on a Table for a SQL Server 2000 datasource. SQL Server
    DBA-2888 DBA813 3234: An error message is displayed on adding the column in to the table which has the view for a SQL Server 2005 datasource. SQL Server
    DBA-18604 Using the REFRESH button from the database object editor's SPACE tab inappropriately switches the name of the DB to another DB (usually Master). Sybase ASE
    DBA-29811 [Object management]Partitioned Tablespaces are failing to show anything in DDL View tab DB2 LUW
    DBA-30096 [Application] Application crashes upon loading Sybase ASE
    DBA-30123 The Database Monitor does not display processes for RAC nodes other than the All selection Oracle
    DBA-30124 DBArtisan cannot be run by a user different from the installed user All
    DBA-30227 Extract and execute a stored procedure comments disappear. Sybase ASE
    DBA-30266 [DBMS Actions] Error when running extracted login script on another server SQL Server
    DBA-30724 [DBMS Actions] Unable to run the explain plan Oracle
    DBA-30751 Oracle LDAP discovery fails for certain datasources Oracle
    DBA-30815 DBArtisanDBA-30876 Query plan not working when login as SYSDBA Oracle
    DBA-30876 DBArtisanDBA-30876 [DBMS Object Management] Landing page displayed on connection to MS SQL Server 2012, displays "Buffer Cache (KB)" as 0 SQL Server
    DBA-30947 [Data Editor] File save to Excel does not produce a proper xlsx format. Sybase ASE
    DBA-30959 [Data Source Explorer] Command line start-up parameters for a Sybase alias from the SQL.ini is not recognized 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 [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.