DBArtisan ReadMe

Welcome to DBArtisan® 8.7

DBArtisan Home | DBArtisan Documentation | Embarcadero Technical Support | www.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, 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 8.7

Unicode

ISQL editor updates

Updated support for Microsoft SQL Server features

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

Updated support for IBM DB2 for z/OS features

Updated support for Oracle features

Updated support for Sybase features

User interface improvements

Release Notes

DBMS Support

DBMS Versions No Longer Supported

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 8.7

Unicode support

DBArtisan now includes Unicode support throughout the application, allowing you to work with data in different languages and display the text correctly on screen.

ISQL editor updates

The ISQL Editor has been enhanced with a set of automated validation and code assistance features:

On-the-fly syntax-checking locates and diagnoses syntax errors as you type
Semantic validation eliminates typographical errors and helps avoid outdated references in specified object names.
Code Complete analyzes statements as you type and offers intelligent suggestions with regard to object names

In addition, specified query options that customize the execution environment can now be saved and subsequently loaded. The frequency with which the options are sent to the server has been optimized.

Updated support for Microsoft SQL Server features

Index support in DBArtisan has been upgraded to account for newer Microsoft SQL Server index functionality. You can now rebuild, reorganize, and disable indexes, primary keys, and unique keys. When creating, dropping or rebuilding indexes, primary keys, or unique keys, online options are available with these operations. This release also offers sparse columns, MAXDOP support, and page and row locking.

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

DBArtisan 8.7 supports the following recent upgrades to IBM DB2 for Linux, Unix, and Windows functionality:

IMMEDIATE and DEFERRED options when editing buffer pools
Encoding scheme options of ASCII, UNICODE, or NONE for character or graphic string parameters in procedures and functions
Object ownership transfer for object owners and users with SECADM authority
Additional “history” deadlock event types for Event Monitors
Inherit isolation level with or without lock request options on Structured Type methods

Updated support for IBM DB2 for z/OS features

This release features the following feature upgrades or improvements:

The truncate operation has been extended to control DROP STORAGE/REUSE STORAGE, RESTRICT WHEN DELETE TRIGGERS/IGNORE DELETE TRIGGERS, and IMMEDIATE clauses of the TRUNCATE TABLE statement.
Revised calculation and display of certain index and table statistics to reflect 8.x changes to system catalogs
Support for long object names
Modification of column sizes and default values with a simple ALTER TABLE statement
Features formerly provided through proprietary stored procedures now use native stored procedures

Updated support for Oracle features

When creating or modifying tablespace datafiles, you can now set the availability of the datafile to either ONLINE or OFFLINE.

Updated support for Sybase features

A Server shutdown Wait Time option lets you enable a grace period, an upper limit on how long to wait for normal operations to complete before forcing a shutdown.

User interface improvements

The most significant user interface improvement for the 8.7 release is a significantly reworked data source tree. The new tree provides enhanced navigation, alternative views, and a more consistent approach to options. The key addition to data source management functionality is the ability to filter the data source view by a number of different criteria.

In addition, DBArtisan 8.7 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:

Microsoft SQL Server – Backup Devices, Linked Servers, Remote Servers, Roles, User Messages
DB2 for Linux, Unix, and Windows – Event Monitors, Structured Types

Release Notes

DBMS SUPPORT

IBM DB2 UDB for OS/390 (z/OS)

Server: IBM DB2 UDB for OS/390 and z/OS v7, v8, and v9

Client: When going through a DB2 Connect gateway, DB2 UDB Client for Windows 6.0 or later. When going directly to the mainframe from the client, DB2 Connect Personal Edition v6 or higher on the client machine.

IBM DB2 UDB for LUW

Server: IBM DB2 LUW Versions 8.x and 9.x

Client: IBM DB2 LUW Client for Windows 7.0 or later. When using a v8 client, DBArtisan only supports connecting to a v8 Database on Windows, Linux and Unix.

Microsoft SQL Server

Server: Microsoft SQL Server 2000, 2005, (All editions including 2000 SDE and 2005 Express Edition for 32-bit x86 and 64-bit Itanium & x86-64) and 2008.

Client: Microsoft SQL Server Client Library

MySQL

Server: 4.x

Client: MySQL ODBC driver 3.5.1 - 4.x.

Oracle

Server: Oracle 8i, 9i, 10g, and 11g.

Client: Oracle SQL*Net Client

Sybase ASE

Server: Sybase System 12.5, Sybase 15.x

Client: Sybase Open Client

DBMS VERSIONS NO LONGER SUPPORTED

All DBMS versions supported in the previous release are supported for this release.

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.

Currently, for Sybase data sources, the Sybase JTDS Driver does not support cp866 codepages. If you are making use of cp866 codepages, ensure that you are using another driver.

In some situations the Database Monitor may prompt to connect to an already connected datasource if auto-connect is not enabled for that datasource

The Oracle Tablespace editor map is not functioning properly

There is a problem with Oracle Graphical Query Plan functionality

Performance Analyst may not work properly or may cause DBArtisan to crash if Internet Explorer 8.0 is installed.

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 fails using SQL Server 2005.

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 8.7
Issue #	Description	DBMS
DBA-9044	The GUI for "Save most recent commands" and "Emulation" in the Editor has some minor errors	All
DBA-12415	Failed to execute query error message after migration	All
DBA-13503	DBA850 #3599: Errors appear during migration using BCP for data movement in Sybase and SQL Server	All
DBA-14188	Error output list doesn't refresh (intermittent) after upgrade to DB850	All
DBA-17825	ISQL Editor is not saving changes in the Syntax highlighting options	All
DBA-17910	ISQL window not being made active when clicking on tab within window	All
DBA-17911	Unable to drag registered datasource instances to another folder/group	All
DBA-17964	Auto Column Lookup ignores Popup Delay ms option setting	All
DBA-18038	DBArtisan 861: After upgrading from build 3893 to build 3899, the bookmarks get erased	All
DBA-18249	CLONE -When you go to file > options > editor > printer font select a different font, then you go to print, it does not go with the printer font but the editor font	All
DBA-19032	Slow performance in application for certain datasources	All
DBA-19115	Excel output not correct, unicode characters not outputted correctly	All
DBA-19974	The "Auto Connect" button does not work from login screen.	All
DBA-15318	Procedure with XML datatype fails to compile	DB2
DBA-15852	When extracting privileges on a group, GRANT EXECUTE ON PROCEDURE schema.* is missing	DB2
DBA-18108	Altering a table generates the following error: "The ObjectRoot is in an inconsistent state (TriggerTime has not been set)"	DB2
DBA-19037	Unable to extract stored procedure that contains xquery syntax.	DB2
DBA-19616	When extracting a table, there is an error during object population. Type = Table caused by Overflow occurred during numeric data conversion	DB2
DBA-19672	User explorer displays system privileges incorrectly. Specifically Create External Routine	DB2
DBA-8762	Adding a new column and placing the column in the middle of the column list, does not result in an extended alter being created	MySQL
DBA-13892	When trying to extract a schema from MySQL (after upgrade) the datetime fields come out in format "MON DD YYYY HH:MM:SS" which is not recognized as a valid date value when inserting into a MySQL table.	MySQL
DBA-15737	Database monitor Processes show an error with a "String Data Right Truncated" message and are showing executed SQL statements as HEX	MySQL
DBA-7277	Checking blocking locks from Database Monitor against Oracle 10g will cause high library cache waits contention if the share pool size is large.	Oracle
DBA-10502	Grant or revoke 'CREATE JOB' OR 'CREATE ANY JOB'	Oracle
DBA-11393	Unable to view Oracle 10 Tablespaces	Oracle
DBA-14015	After extracting the DDL for a role the users assigned the role are no longer included	Oracle
DBA-14734	Customer experiences crashes 4 or 5 times a day since upgrading to DB852 using Oracle 9i	Oracle
DBA-15503	Slow to extract Function and Procedure from explorer window	Oracle
DBA-15552	After upgrading to DB854 from DB815 Oracle compile no longer works and complains about invalid character when trying to execute	Oracle
DBA-15825	Crash when running Performance Analyst when Internet Explorer 8.0 is installed	Oracle
DBA-17489	Incorrect application behaviour when DBA_Role removed from user	Oracle
DBA-17880	Error appears when navigating to Roles tab of the User editor, connected with non dba user.	Oracle
DBA-17969	Migration - Include Storage option from Schema Migration does not work	Oracle
DBA-18380	It takes a long time to extract a user definition	Oracle
DBA-18406	[regression 861] Incomplete DDL generated for Roles (ALTER USER statements missing), on Oracle.	Oracle
DBA-18640	Extracting many indexes sorted by "Dist Key" with drop indexes clause checked produce a ddl script where drop commands are not in the right order	Oracle
DBA-18685	DB870 3954: files saved from DB previewing a compile are unusable for edit or run, invalid characters for editors like Codewright or SQL Plus	Oracle
DBA-18978	Data load doesn't work in latest release. Customer is getting syntax errors when trying to load a table via the data load utility in the DBArtisan's latest release.	Oracle
DBA-18991	When creating users, incorrect DDL is generated in the form of CREATE USER MY_NEW_ACCOUNT IDENTIFIED BY VALUES 'letmein'; when it should be CREATE USER MY_NEW_ACCOUNT IDENTIFIED BY letmein	Oracle
DBA-19127	Not able to generate insert statement when right click on result set column name if schema name is not included in front of table before WHERE clause in the query	Oracle
DBA-19211	Feature Data Load fails to load data into target object	Oracle
DBA-19212	When performing Extract on Interval partitioned Table, error occurs Error During Object Population. Type = Table	Oracle
DBA-19228	When partitioning a table, the user gets error: The ObjectRoot is in an inconsistent state. (TriggerTime has not been set)	Oracle
DBA-19269	Error when attempting table open or extract on Oracle 8.1 datasource, Error during object population type = TABLE	Oracle
DBA-19296	Not able to create synonyms when highlighting multiple tables > Create Synonyms	Oracle
DBA-19485	User names cannot be sorted in alphabetical order at Security > Profiles > (profile name) > Users tab	Oracle
DBA-19570	User extraction generates an ORA-01017 error	Oracle
DBA-19571	Getting ORA-28009 when connected to DBArtisan 8.6.2 3952 using non default log in , and trying to extract an object	Oracle
DBA-19723	ORA-24347: Warning of a NULL column in an aggregate function when performing a select query	Oracle
DBA-19762	Opening an Oracle table or user object does nothing (see DBA-19571)	Oracle
DBA-19801	After extract a table, varchar2(n) data type column becomes VARCHAR2(n CHAR)	Oracle
DBA-9133	Unable to debug SQL Server procedures	SQL Server
DBA-13470	Failed to create connection URL or Driver class may be incorrect. Unable to get information from SQL Server - error causes database to be inaccessible	SQL Server
DBA-13552	During migrate table with BCP option DBArtisan crashed	SQL Server
DBA-16581	Space Analyst object tab shows conflicting information between graph and details for SQL Server 2000.	SQL Server
DBA-17118	VIEW_EXTRACT: Long View DDL not extracting fully and is truncated.	SQL Server
DBA-17727	Schema Migration fails to complete when using Windows Authentication - SQL Server 2005	SQL Server
DBA-17670	Attempting to ALTER database to READ ONLY (SQL Server 2005), generated ALTER statements are incorrect	SQL Server
DBA-18055	DB861 3899 Error During Object Population. Type = Login when extracting more than 80 objects at once	SQL Server
DBA-18133	SID not extracted with Login on MSSQL Server 2005	SQL Server
DBA-18142	DB861 3899 extended alter does not recreate permisions for dependencies	SQL Server
DBA-19033	After selecting the target DB Table migration inappropriately tries to login to the 1st source DB in the list instead of the source DB where the table resides.	SQL Server
DBA-19049	Table extract inappropriately lists columns comprising clustered primary key in the order of table definition instead of the order in which they're defined via the clustered primary Key	SQL Server
DBA-19726	Database Space usage exceeds total DB space available	SQL Server
DBA-19922	When migrate SQL Server tables to Sybase, error: java.lang.NULLPointerException	SQL Server
DBA-20063	Incorrect ALTER COLUMN statement when changing data scope.	SQL Server
DBA-7527	DBA810 3089 BUG: Get Incorrect Syntax error when executing the SQL Statements on master.dbo.syslogins generated by using the Create Insert Statement tool	Sybase
DBA-8832	DB811 One time crash when dropping users from Sybase	Sybase
DBA-8675	DBA813 3301: An error message is displayed when Memory Detail window Data Cache is opened for a Sybase 15 ASE datasource.	Sybase
DBA-11543	[8.5.0 #3524] Support for nullable datatypes ending with 'n' such as datetimn	Sybase
DBA-12725	Select in Sybase 15.0.2 with Unicode generates WARNING! Some character(s) in the source string are considered illegal bytes in server's character set. All bytes after the first illegal bytes are truncated.	Sybase
DBA-13467	When the Data Insert from an Alter Table script fails, the SCRIPT continues and DROPS the original table with all of the data. Recovery requires a complete DB restore	Sybase
DBA-14255	DBA 851 #3649: java.lang.StackOverflowError when trying to create/alter/extract a very large procedure (~10 000 lines) on a Sybase datasource	Sybase
DBA-14555	Invalid Column Name Error when using Performance Analyst with Sybase 15.2 server	Sybase
DBA-15058	Attributes for indexes don't always match up between the indexes pane and the attributes tab	Sybase
DBA-15211	Data load fails when running from a saved file	Sybase

DBA-16151	SYSLOGINS Create Insert statement is not correctly creating quotes around the Column PWDATE	Sybase
DBA-17950	When connecting to a Sybase 15 datasource the product (DB861 3893,3899,3911) successfully connects to the Sybase instance but the ASE's Log shows one - "Login failed. User: **** Client IP address: 'x.x.x.x'" message during the connection attempt	Sybase
DBA-18030	Extracting a login - aliases are no longer extracted from each database	Sybase
DBA-18077	After upgrading to DB861 3899 from DB855, Sybase DDL extracts inexplicably add revoke statements for users that have been explicitly granted permissions.	Sybase
DBA-18083	PCTUSED (missing PCTFREE) is incorrectly being added to the DDL when extracting partitioned table objects, the resulting DDL does not execute properly	Sybase
DBA-18272	Enabling Migration with BCP data movement causes task to fail with errors of either the desired objects not found or Establishing connection failed	Sybase
DBA-18452	Lack of objects in the dependency tab: dependencies tab of tables used in a trigger definition don't contain the trigger	Sybase
DBA-18792	When going to the DDL tab of a Sybase table the following error is written to the "Output": String index out of range: 8128 or 8240	Sybase
DBA-18990	DBArtisan inappropriately generates code with SETUSER command which causes error when run by non-DBO	Sybase
DBA-19126	Migrating a database object from one Sybase datasource to another is no longer possible.	Sybase
DBA-19171	DB search doesn't find strings that are split across multiple rows of Sybase system table syscomments	Sybase
DBA-19270	Database Space usage is greater than 100% at certain time in DBArtisan	Sybase
DBA-19294	Space in Datasource name causes connection to fail for Sybase datasource	Sybase
DBA-19481	Unable to migrate from HP-UX to Linux ASE15	Sybase
DBA-19728	Performance Analyst error when attempting to view Data Cache on Sybase - Attempt to insert NULL value into column 'ProcessesAccessing', table '#mdi_values';	Sybase
DBA-19802	Extracted DDL does not contain sp_primarykey and sp_foreignkey commands used in SQL that created the table	Sybase
DBA-19969	Wrong datetime format displayed when performing Create Insert Statements on a table with datetime columns - specifically syslogins	Sybase
DBA-20016	Adding the variable @@sqlstatus in the watch window for a Sybase stored procedure makes DBArtisan to hang	Sybase
DBA-20105	ISQL editor fails to keep session persistent and lock in set commands, prior versions supported this feature	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 Rapid SQL 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.