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:

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:

Updated support for IBM DB2 for z/OS features

This release features the following feature upgrades or improvements:

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:

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