IBM Support

What's New and Changed in IBM Data Studio Version 3.2

Product documentation


Abstract

The IBM® Data Studio Version 3.2 release contains cumulative fixes, enhancements, and new features for both the Data Studio client and Data Studio web console. View the following list for details about the new, changed, deprecated, or removed features in Data Studio Version 3.2.

Content

New and Changed Features

Data Studio Version 3.2 provides enhancements or additional support in the following categories:

Deprecated Features

For information about features that are being deprecated, no longer supported, or being removed in the next release, see the Deprecated features section.


Data Studio Client

The Data Studio client includes the following enhancements:

  • Usability improvements in various views, dialog boxes, and task assistants. Notable enhancements include:
    • The menu that you use to open the Compare and Migrate wizard has moved into a contextual menu and is no longer accessible from the main menu. You now open the Compare and Migrate wizard by right-clicking the database and then clicking Migrate > Compare and Migrate Objects.
    • Data Source Explorer is now able to open the table data editor that includes row and column filtering.
  • When directed by IBM Support, you can now use the IBM Support Assistant Data Collection tool to collect information about the product and assist in troubleshooting and problem determination.
  • The SQL results view now includes a link to directly access the preferences dialog box from the menu in the view.
  • Routine SQL statement tuning with InfoSphere® Optim™ Query Workload Tuner has been improved to now collect the actual access plan information from DB2 databases, including runtime statistics for the operations performed to execute the SQL statements.
  • From the Data Source Explorer, you can now use the routine editor to open triggers that are defined on tables or views in DB2 for Linux, UNIX, and Windows v10.1 Fix Pack 2 and later databases.
  • You can now create and debug anonymous PL/SQL blocks in the SQL and XQuery editor when you are connected to DB2 for Linux, UNIX, and Windows v10.1 Fix Pack 2 and later databases.
  • Enhanced routine editing and debugging:
    • Improved performance for debugging routines.
    • The routine debugger now supports nested routines.
    • For routines that are deployed on a DB2 for Linux, UNIX, and Windows v10.1 Fix Pack 2 and later databases, you can now set and remove breakpoints from routine source code in the routine editor in the routine editor and debugger.
    • Now, all breakpoint information is persisted with each routine.
    • In the debugger, you can now view ARRAY, ASSOCIATIVE ARRAY, ARRAY of ROW, and global variables in the Variables view.
    For more information about the routine debugger, see Routine debugger.
  • Use IBM Optim Configuration Manager to share and synchronize connection information for DB2 databases between your Data Studio clients. Use IBM Optim Configuration Manager to store your connection information in a single repository to share among team members. For more information, see Sharing database connection information through a repository database.
  • Installation enhancements:
    • Enterprise deployment now supports both Windows and Linux operating systems. Use IBM Installation Manager and the scripts and sample response files that are bundled with the product to deploy the product installation to other computers in your enterprise. For more information, see Enterprise deployment of IBM Data Studio.
    • You can now install the product into a shared package group (also referred to as shell-sharing) with other 64 bit Optim and Rational products.
  • Additional operating system and driver support:
    • Support for the following operating systems has been added:
      • Red Hat Enterprise Linux v6.3
      • SUSE Linux Enterprise v11 Service Pack 2
    • 64 bit operating systems are now supported.
    • Java Runtime Environment 7 is now supported.

Data Studio Web Console

The Data Studio web console includes the following feature enhancements:

  • Schedule database blackout events to disallow monitoring and job execution on databases for a specified period of time.
  • Create and share alert views to identify problems associated with managed databases.
  • Create alert actions to run jobs when alerts are triggered.
  • Installation enhancement:
    The installation wizard has been upgraded to use IBM Installation Manager so you can now manage both the Data Studio client and web console product installations from the same tool.

    Important:

    • To install the Data Studio web console, you must have administrator privileges. In the launchpad, you must select Administrative Installation because the Non-Administrative Installation option is unsupported.
    • It is recommended that you upgrade to the Data Studio web console v3.2 if you upgrade to the Data Studio client v3.2. To use the job manager in Data Studio web console v3.2 with versions of the Data Studio full client v3.1.1, you must open the web console interface in a web browser. Managing jobs from the Job Manager tab in the 3.1.1 version of the Data Studio full client is not supported.

Deprecated Features

The following features are being deprecated for this release and will be removed in the next release:

  • Support for creating Java stored procedures from Java methods is being deprecated and will be removed in the next release. For more information, see Creating Java stored procedures from Java methods in the Data Studio Information Center.
  • Support for collecting the actual values to compute the cost of SQL statements in DB2 for z/OS data sources is being deprecated and will be removed in the next release.
  • Support for analyzing static JDBC result sets is being deprecated and will be removed in the next release.
  • Support for Oracle Visual Explain is being deprecated and will be removed in the next release.
  • Support for editing routines, running commands, and debugging for Oracle databases, Sybase databases, and IBM DB2 databases with the IBM DB2 Sybase SQL skin (SSacSA) is being deprecated and will be removed in the next release.
  • Support for IBM WebSphere Application Server Community Edition (CE) for web services, is being deprecated and will be removed in the next release. You can continue to use WebSphere Application Server for Developers, for more information see the product page at http://www.ibm.com/software/webservers/appserv/developer/.

The following features have been deprecated and will be removed in a future release:

  • The DB2® Administration Server (DAS) has been deprecated and is no longer supported for running SQL statements, utilities, and commands, or to browse and access files on remote servers. For more information, see Configuring for remote operations.
  • The Microsoft Server Message Broker (SMB) protocol has been deprecated starting with Data Studio Version 3.1.1 and is no longer supported for running SQL statements, utilities, and commands, or to browse and access files on remote servers.
  • The common connection configurations feature has been deprecated starting with Data Studio Version 3.1 and is no longer supported. For information about the common connection configurations feature, see Creating and using common connection configurations.
    To store your connection information in a single repository to share among team members, you can use the Data Studio web console, see Sharing database connection information through a repository database for more information.

Document information

More support for: IBM Data Studio
Installation/Migration

Software version: 3.2

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows, z/OS

Reference #: 7024313

Modified date: 07 December 2012