What's New in IBM Data Studio Version 3.1.x

Product documentation


Abstract

The IBM® Data Studio Version 3.1.x releases contain cumulative fixes, enhancements, and new and deprecated features.

Content

IBM Data Studio versions:

Version 3.1.1
Version 3.1


For Data Studio Version 3.2, see Whats New and Changed in Data Studio Version 3.2.

Version 3.1.1

Data Studio, Version 3.1.1

Data Studio Version 3.1.1 provides enhancements in the following categories, for the full client, administration client, or web console:



Database support

  • DB2® V10.1 for Linux, UNIX, and Windows

    Data Studio now supports DB2® V10.1 for Linux, UNIX, and Windows databases, including the following features:

    • Adaptive compression for table rows
    • Special registers for temporal tables in server profiles
    • Time-based data management with temporal tables
    • Data management using multi-temperature storage
    • Data security with row and column access control (RCAC)
  • DB2 for i

    IBM Data Studio now includes toleration* support for the following versions of DB2 for i databases:

    • DB2 for i 6.1
    • DB2 for i 7.1
    *Toleration support indicates that there is only support for the same features and functionality in DB2 for i5/OS V5R4.

Data Studio clients

The Data Studio full and administration clients include the following enhancements:

  • Feature enhancements
    • Updated syntax checking in the SQL and XQuery editor for all DB2 for Linux, UNIX, and Windows Command Line Processor (CLP) commands
    • Gather database performance information for stored procedures in DB2 for Linux, UNIX, and Windows databases
    • Generate DDL statements to maintain security policies for tables in DB2 for Linux, UNIX, and Windows databases
    • Create test configurations to automate and run tests for SQL or Java routines for DB2 for Linux, UNIX, and Windows databases
    • Debug and redeploy SQL routines that are in DB2 database modules
    • Create SQL routines from the Data Source Explorer with a new wizard
    • Usability improvements to editing, running, and deploying SQL routines in Data Source Explorer
    • New IBM InfoSphere Optim pureQuery Runtime bind options
  • Federated data object enhancements
    • Improved the amount of detail for federated data objects in the Object List
    • Create, alter, and drop federated data objects for Oracle data sources in a federated system
  • Query tuning enhancements
    • Tune SQL from the Task Launcher with the new Start Tuning wizard
    • Generate access plan graphs that can display three new nodes:
      • Show the rebalancing of rows between SMP subagents with REBAL
      • Show multi-distinct processing with MGSTRM
      • Show a zigzag join with ZZJOIN
  • Task assistant enhancements
    • Updated the Verify DB2 Cluster Services Status task assistant
    • Updated the Manage DB2 Cluster Services Configuration task assistant
  • Client platform enhancements
    • Updated the Eclipse platform to enable shell sharing with other products based on Eclipse 3.6.x including IBM Rational Software Architect Version 8.x, Rational Application Developer Version 8.x, Rational Developer for System z Version 8.x, and InfoSphere Data Architect Version 8.1

Data Studio web console

The Data Studio web console includes the following feature enhancements:

  • Support for DB2 for Linux, UNIX, and Windows databases:
    • Provides alerts for high availability disaster recovery (HADR) databases, pureScale instance status, and for when the pureScale cluster facility is not found
    • Import capabilities for importing tasks from the DB2 Task Center into the Job Manager
  • Support for both DB2 for Linux, UNIX, and Windows and DB2 for z/OS databases:
    • Creates and manages user-defined alert types using custom scripts
    • Cancels job execution that have started as well as ones that exceed a timeout period

Deprecated features

The following features have been deprecated or will be deprecated in the next release:

  • The common connection configurations feature in IBM Data Studio will be removed in a future release. See Creating and using common connection configurations for information about the common connection configurations feature.
    To store your connection information in a single repository to share among team members, you can use the Data Studio web console, see Importing and exporting database connection information for more information.
  • Support will be removed in a future release for using the DB2® Administration Server (DAS) to run SQL statements, utilities, and commands, or to browse and access files on remote servers from IBM Data Studio. See Configuring for remote operations for more information.
  • The Microsoft Server Message Broker (SMB) protocol is no longer supported to run SQL statements, utilities, and commands, or to browse and access files on remote servers from IBM Data Studio.


For details about which features exist in each component of Data Studio, see Data Studio V3.1.x features.

Version 3.1

Data Studio, Version 3.1

Data Studio Version 3.1 provides enhancements in the following categories, for the full client, administration client, and web console:



Simplified packaging

Simplified packaging with the consolidation of the Data Studio, Optim Development Studio, Optim Database Administrator, and Data Studio Health Monitor products into a single Data Studio offering. The stand-alone client has been renamed to administration client, the IDE client has been renamed to full client, and the health monitor has been renamed to web console.

See Getting started in IBM Data Studio for more information.


Task assistants enhancements

Enhanced task assistants for the following tasks:

  • Backup
  • Configure database
  • Create database
  • Configure logging
  • Import and export table
  • Load
  • Manage pureScale Host Maintenance Mode
  • Quiesce and unquiesce database and instance
  • Reorg table
  • Restore a database
  • Roll forward and cancel roll forward database and table
  • Run statistics
  • Setup and Manage HADR
  • Start and stop database and instance

See Database administration commands that you can run from task assistants for more information.


SQL editor enhancements

Run option and syntax support enhancements in the SQL and XQuery editor.


Enhanced password management

Password management has been enhanced to simplify managing passwords for multiple databases, see Changing user names and passwords for more information.


Object management enhancements

Enhancements in data object editing and complex change management:

  • Object management simplification with in-place editing of objects in properties views.
  • Integrated change management for DB2 for Linux, UNIX, and Windows that uses new edit-in-place and change plan organization.

See Managing database object changes by using the Properties view for more information.

Enhancements in database support:

  • Support for temporal tables in DB2 10 for z/OS databases.
  • Support for Oracle databases.
  • Support for Sybase databases.
  • Support for Informix databases.

See System requirements for IBM Data Studio for more information.


DB2 pureScale support

Support for DB2 pureScale instances.


Java project enhancements

When you enable a Java project with Data Access Development support you can run, test, and tune the SQL statements that are in your application. For some features, you must also enable the Java project with pureQuery support.

After you enable Data Access Development support, you can enable pureQuery support to use pureQuery Runtime to develop, manage, and optimize new and existing applications that access data.

For more information about Data Access Development support, see Tuning SQL statements in Java applications.

For more information about pureQuery support, see pureQuery data access applications.


Data Studio web console

Provides health and availability monitoring features and job creation and management functions for DB2® for Linux, UNIX, and Windows and DB2 for z/OS® databases. From the workbench you can open the Data Studio web console in an embedded browser or in a stand-alone web browser.

Enhanced monitoring and job management features:

  • The health monitoring and alert features of the web console provide more information for DB2 pureScale and the database partitioning feature:
    • If you are using the DB2 pureScale feature, you can view the status of pureScale members, cluster caching facilities, and cluster hosts in the Health Summary page. You can configure the health monitor to send alerts when the status of a monitored pureScale component is changed.
    • If you are using the database partitioning feature (DPF) on DB2 for Linux, UNIX, and Windows Version 9.1 or higher, you can view the status of a database partition in the Health Summary page. You can configure the health monitor to send alerts when the status of a monitored database partition is OFFLINE.
  • You can create, manage, and schedule your database jobs from the Data Studio web console. The job scheduling capability is integrated with the workbench script editor. You can associate multiple schedules with a job, and associate a schedule with multiple databases. You can chain jobs so that a job is triggered to run based on the outcome or completion of a previous job. You can subscribe to notifications of job execution outcomes, and view the history of job executions.

See IBM Data Studio web console overview for more information.


Tuning enhancements

Enhancements in tuning single SQL statements include:

  • You can save recommended RUNSTATS commands into RUNSTATS profiles on DB2 V10 for z/OS. For information about RUNSTATS profiles, see "RUNSTATS profiles."
  • You can save recommended RUNSTATS commands into statistics profiles on DB2 for Linux, UNIX, and Windows, Versions 9.5, 9.7, and 9.8. See "Collecting statistics using a statistics profile" for more information:
  • You can configure the workflow assistant to use the ADMIN_INFO_SQL stored procedure on DB2 Versions 9 and 10 for z/OS to capture query and workload environments for sending information to IBM Support when troubleshooting problems. The advantage to using this stored procedure is that the collection of information is faster and easier to use than DB2PLI8.

See Tuning single SQL statements with the Query Tuner workflow assistant for more information.


Deprecated features

The following features have been deprecated or will be deprecated in the next release:



For details about which features exist in each component of Data Studio, see Data Studio V3.1.x features.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Data Studio
Installation/Migration

Software version:

3.1, 3.1.1

Operating system(s):

Linux, Windows

Reference #:

7021898

Modified date:

2013-01-28

Translate my page

Machine Translation

Content navigation