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

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
• Enhanced task assistants
• SQL editor enhancements
• Enhanced password management
• Object management enhancements
• DB2 pureScale support
• Java project enhancements
• Data Studio web console
• Tuning enhancements
• Deprecated features

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.

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.

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

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

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.

Support for DB2 pureScale instances.

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.

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.

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:
  • 9.5: Collecting statistics using a statistics profile
  • 9.7: Collecting statistics using a statistics profile
  • 9.8: Collecting statistics using a statistics profile
• 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.

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

• The installation option to extend an Eclipse integrated development environment has been removed from IBM Data Studio V3.1 and is no longer supported for the Data Studio full client, see Installing IBM Data Studio full client for more information.
• The common connection configurations feature in IBM Data Studio will be removed in the next 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.

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