DBArtisan ReadMe

Welcome to DBArtisan® XE 3 and DBArtisan® 9.1

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

ReadMe Last Published: April 2, 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

Database Monitor Updates

Updated support for Microsoft SQL Server features

Updated support for Sybase features

User interface improvements

DBMS Support and Connectivity

Dedicated Support Connectivity Options

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.1/XE 3

Sybase IQ Support

This release introduces support for Sybasse IQ, Sybase's column-oriented DBMS. This release will offer the following:

The ability to register and connect to Sybase IQ datasources
Explorer visibility of the following object types: DBSpaces, Domains, Foreign Keys, Functions, Groups, Indexes, Join Indexes, Primary Keys, Procedures, System Indexes, System Tables, System Triggers, Tables, Triggers, Users, and Views.
Database Monitor functionality providing live details on connected users and table locks as well as status information
SQL Editor support

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

Hyperlink object actions - Hyperlinks let you invoke common or object type-specific object actions against tables, views, functions, procedures, packages, and package bodies referenced in a script. A configurable keystroke combination (default, CTRL+Right-click) opens an object action menu.
Datasource index configuration - the object index used to implement Code Assist features can now be configured. You can control the object types included in the index, the maximum size of the index, and the maximum number of results returned by queries to the index.

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:

Enhanced Public Key Encryption Support - Certificate, Asymmetric Key, and Symmetric Key database objects are now offerred. Dedicated wizards and editors let you create and edit the new objects types. In addition, associated object actions let you add or change a certificate's private key and back up a certificate to file.
Enhanced Backup/Restore Functionality - The SQL Server Backup Wizard now offers READ_WRITE_FILEGROUPS options, offering partial backups for both full and incremental backups. New BACKUP DATABASE statement support includes compression and checksum options.

Updated support for Sybase features

Sybase currency updates for this release include:

Proxy Tables - New properties let you specify FOR PROXY_UPDATE and DEFAULT_LOCATION= parameters when creating a database. A new Resynchronize action, available against databases defined with the For Proxy Update property selected, forces the resynchronization of proxy tables within the proxy database.
Archive Databases - A new ARCHIVE Type option and a new Scratch Database property let you generate CREATE ARCHIVE DATABASE DDL and specify a WITH SCRATCH_DATABASE value.
Relaxed Durability Databases - A new Durability property of the Database Wizard/Editor lets you control persistence of commited transactions. Selecting one of the FULL, NO RECOVERY, or AT_SHUTDOWN options includes a DURABILITY= option in the DDL generated to create or alter the database.
In-memory Databases - New properties on the Data Caches, Database Devices, and Database Wizards let you set up all resources required to create in-memory databases.

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:

Oracle – Job Queues
Sybase – Segments

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 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 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 SQLNet 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

Running Schema Migration against an Oracle table can cause DBArtisan to crash if the table has a large number of records and Data Copy is used as the Data Movement option. Against a table with fewer records, a java.lang.NullPointer exception may be thrown.

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.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.