DBArtisan ReadMe

Welcome to DBArtisan® XE5 and DBArtisan® 9.6.1

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

ReadMe Last Published: May 6, 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, 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.6.1/XE5

DB Team Server

What's New in Version 9.6/XE5

64-bit Installation

Windows 8 Support

Teradata Support

Other New DBMS Version Support

DBMS Support and Connectivity

Dedicated Support Connectivity Options

Generic JDBC/ODBC Connectivity

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

DBMS Versions No Longer Supported

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.6.1/XE5

DB Team Server

In previous releases, DBArtisan integrated with Embarcadero Connect, a data governance and metadata repository. DBArtisan users could make use of datasource definitions and ER/Studio data model information stored on the repository as well as open a browser window to work directly against Embarcadero Connect.

DBArtisan features that were previously available through the Embarcadero Connect integration are now available against Embarcadero DB Team Server. New DB Team Server features now available in DBArtisan are:

An advanced search mechanism lets you locate datasource definitions by a variety of criteria, including DBMS platform, version, and host name, as well as operational characteristics such as space statistics and ping time.
Users can monitor the activity stream associated with their DB Team Server account or the activity stream for a datasource definition.

What's New in Version 9.6/XE5

64-bit Installation

DBArtisan now runs as a native 64-bit application. Separate installers let you choose between 32-bit and 64-bit applications. See Important Advisory Notes for more information.

Windows 8 Support

DBArtisan is now fully supported on the Windows 8 operating system. For information specific to Windows 8.1, see Important Advisory Notes.

Teradata Support

This release provides a Technical Preview of support for Teradata versions 13.10, 14, and 14.10. Specifically, version 12 syntax is supported. Connectivity is available with either of the Teradata ODBC or JDBC drivers (installed, with all Teradata prerequisites satisfied). Functionality as of the current release is as follows:

Command Line Startup
Standard datasource registration and connection features
Limited Datasource Navigator/Explorer tree functionality
SQL Editor execution and related, common SQL Editor functionality such as Query Options, Paste SQL Syntax, and Paste SQL Statement.

Teradata access is not covered under XE or trial licenses. Contact [email protected] for a separate Teradata license.

Other New DBMS Version Support

As of this release, DBArtisan provides full support for the following DBMS platform versions:

IBM DB2 LUW version 10
IBM DB2 z/OS version 10
Oracle 12c
Sybase ASE 15.7

Sybase ASE Updates

Against version 15.7 datasources, the Login Wizard/Editor now generates DDL that uses CREATE/ALTER LOGIN syntax. New properties let you work with SUID, LOGIN PROFILE, and EXEMPT INACTIVE LOCK parameters. The Change Login Password, Add/Modify Login Trigger, and Drop Login Trigger actions have also been updated to generate DDL that uses ALTER LOGIN syntax.

DB2 LUW Updates

The Update Statistics object action has been updated to use the ADMIN_CMD system procedure. This eliminates the constraint to have target datasources registered by alias and using the native client. Update Statistics can now be used against all datasources, regardless of how they were registered.

SQL Server Updates

Sequence object type - DBArtisan now supports the sequence object type, introduced with SQL Server version 12. A creation wizard, editor, and a basic set of object actions are provided.
File Table and FileStream updates to tables - When creating or editing SQL Server tables, a new set of properties is available. They let you:
- Specify a filegroup for the table by providing a FILESREAM_ON argument value
- Create the table as a FileTable, with a full set of FileTable arguments.
A new Enable/Disable Filetable(s) action lets you build and submit an ALTER TABLE statement, specifying either an ENABLE FILETABLE_NAMESPACE or DISABLE FILETABLE_NAMESPACE argument. This enables or disables system-defined constraints on a FileTable.

Oracle Updates

If the Oracle SQL*Net Client is not installed, DBArtisan will attempt to connect to an Oracle datasource using the Oracle Database Instant Client.

Query Builder

As of this release, when you add the same table to the diagram pane multiple times, a new alias is automatically assigned to each instance. Adding a table multiple times can be useful when selecting additional data from the table, based on different join criteria.

Database Monitor

The following customizations can be made on a DBMS platform basis.

Saved column-widths - When you manually resize a column on a Database Monitor tab, the new size is saved across startups of DBArtisan and Database Monitor.
Color-coding and Refresh Rate Customization - The Options Editor now offers a DB Monitor Options page. It lets set foreground and background colors associated with sleeping, blocking, and default processes. It also lets you specify the default display refresh rate used after opening a Database Monitor window. Note that you can still modify the refresh rate from the Database Monitor window.

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:

Native Embarcadero drivers - DBArtisan is packaged with a set of native drivers, each requiring a DBMS-specific client to be installed.
JDBC drivers - DBArtisan can connect to a datasource more directly using one of the packaged, third-party JDBC drivers. No additional connectivity components need to be installed. One or more third-party drvers, tested against DBArtisan, are installed with DBArtisan.

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

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

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 SQLNet Client**	Oracle JDBC Thin 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.

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

IMPORTANT ADVISORY NOTES

As of the 9.6 release, you can install DBArtisan as a native 64-bit application. 64-bit versions of DBMS platform drivers are installed when you select that option. If you are using custom drivers, as of the 9.6 release, you must be using 64-bit versions of those drivers when using the 64-bit version of DBArtisan.
If you want to run DBArtisan on Microsoft Windows 8.1, verify that third-party DBMS native drivers install properly. Consider using a JDBC connection.

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:

Close DBArtisan.
Uninstall the older MySQL ODBC client.
Restart DBArtisan and try connecting to a MySQL datasource. You are prompted to install the MySQL client drivers.
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.

The SQL Server Agent failing problem is caused by the lack of permission to enumerate the status of the server service. To determine the status of the server, the user must have permission to check the status of the server service. If the user running DBArtisan at the client machine is a not a local user who can be authenticated at the server machine, the Server Agent jobs will fail.
Workaround:
a. If the user that runs DBArtisan is not a domain user, create the same user with the same password on the server.
b. If the user is a domain user, make sure the user can login to the server.

When you are using the Debugger:

The Debugger windows (Variables, Watch, CallStack, Dependency) cannot be undocked. This behavior is deliberate and is true only for the Debugger windows. The Output window can be undocked.
When running Windows XP SP2, SQL Server 2000 SP4 is required on both the client and the server.
When running the Debugger on SQL Server 2005 CLIENTS:

Verify that the file ssdebugps.dll is registered on the client machine. This file is REQUIRED for debugging and Microsoft only installs it on the server machine and not as a part of a client-only install.
Follow the instructions under the "Configure DCOM on the computer that is running Visual Studio. NET" heading from Microsoft to reconfigure the DCOM settings on your client machine: http://support.microsoft.com/default.aspx?kbid=833977.
On the Default Properties tab of the My Computer dialog box, make sure the Default Authentication Level is set to None and that the Default Impersonation Level is set to Impersonate.

When using the Embarcadero Sybase debugger against a Sybase database with multiple temporary databases (supported in Sybase ASE 12.5.0.3 and above), either the user or the debugger application must be bound to a specific temporary database.

To bind the Embarcadero Sybase Debugger:
sp_tempdb "bind" , "ap", "Sybase Debugger", "DB", "<tempdb name>"
To bind the user:
sp_tempdb "bind", "lg", "<login id>", "DB", "<tempdb name>"

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.6.1/XE5
Issue #	Description	DBMS
DBA-29023	[Interface] Interface windows appear to be truncated and/or incomplete after remote sessions with a graphical rendering problem	All
DBA-29305	[SQL Editor] Having multiple SQL tabs open cause repaint issues	All
DBA-30676	DBArtisan display issue with Connect - Chinese characters not displayed.	All
DBA-30111	[Tools] Expanding the column names in a table by using Query builder can take up to 10 minutes.	Oracle
DBA-18281	In ISQL window, Background color for Line Numbers can't be changed	SQL Server
DBA-29919	[Schema Extraction] Trigger extraction is being truncated	SQL Server
DBA-30212	[Explorer][dmbs objects] Objects (like tables) will not open in Databases that are in read-only mode	SQL Server
DBA-30225	[DBMS Actions] cannot script out database roles when selecting ALL of them in the listing	SQL Server
DBA-25105	[Foreign Key] Can't create a foreign key referencing a column that is indexed as unique	Sybase ASE
DBA-29929	[SQL Editor] Extra Use database statement in extraction DDL	Sybase ASE
DBA-30210	[DBMS Actions] When monitoring the process list on a server, the highlighted row jumps to another process when the display is refreshed.	Sybase ASE
DBA-30223	[DBMS Actions] When a table is renamed the extract ddl incorrectly generates a partition statement.	Sybase ASE

Bugs Fixed in DBArtisan 9.6/XE5
Issue #	Description	DBMS
DBA-29727	[Definition][Error line reporting] Changes made in Definition tab that cause errors are not reporting error line in Output message window	All
DBA-15062	When running a simple read only type query and closing SQL editor, user is prompted for a Commit Rollback window even though session is Unlock or Locked	Oracle
DBA-28866	[Database Monitor]The top twenty sql in Monitor does not produce any rows.	Oracle
DBA-29275	[DBMS Object Management] when extracting code for procedures, schema owner is not always included.	Oracle
DBA-29904	[DBMS Object Management] Temporary Tablespace Groups not shown in the Temporary tablespace drop down box when configuring user.	Oracle
DBA-29685	[Schema Extraction] Check constraint extract is incorrect,() parenthesis missing	SQL Server
DBA-29835	[DataSource Explorer] When a SQL Server database is in offline/read-only mode, the explorer window is still showing the database as on-line.	SQL Server
DBA-30129	[Database Monitor] Monitor refresh rate setting is not being saved	SQL Server
DBA-30034	[Analysts] Memory Analysis page is not showing any data for SQL Server 2012.	SQL Server

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.