Data Studio V3.1.x features: by data server and component

Product documentation


Abstract

Use the following set of tables to view the features of Data Studio that are supported for each data server and to view the Data Studio components that you use for each feature.

Content

For a list of features that have been deprecated or are scheduled for deprecation, see the Deprecated features section in the What's New in IBM Data Studio Version 3.1.x document.



Legend:
X1 - Only supported in IBM Data Studio V3.1.1
X2 - Includes support for DB2® compatibility mode, but requires a JCC driver
X3 - Includes support for ANTs Software product IBM® DB2 SQL Skin for applications compatible with Sybase ASE (IBM DB2 SSacSA)

Task category Feature   Data Studio component
General  
  Shell sharing with other 32-bit Rational or InfoSphere Optim products Full client
  Install help content locally with the Local Help Updater Full client
Task category Feature V9.1 V9.5 V9.7 V9.8 V10.1 Data Studio component
General  
  Database catalog filter     X X X Full client, Administration client
Architecture data modeling  
  Database overview diagrams X X X X X Full client, Administration client
Application development  
  Integrated Query Editor (SQL and XQuery) with query formatting X X X X X Full client, Administration client
  SQL Builder X X X X X Full client, Administration client
  Query formatting X X X X X Full client, Administration client
  Visual Explain X X X X X Full client, Administration client
  Access plan graph (enhanced Visual Explain) X X X X X Full client, Administration client
  Statistics advisor X X X X X Full client, Administration client
  Routine test configuration X1 X1 X1 X1 X1 Full client, Administration client
  Debugging, editing, and running routines in DB2 database modules X1 X1 X1 X1 X1 Full client, Administration client
  Editing, debugging, and redeploying SQL routines deployed in databases X1 X1 X1 X1 X1 Full client, Administration client
  Creating SQL routines from the Data Source Explorer and Admin Explorer using Routine Editor X1 X1 X1 X1 X1 Full client, Administration client
  VARRAY support X1 X1 X1 X1 X1 Full client, Administration client
  Stored procedure editor and debugger X X X X X Full client, Administration client
  User-defined function editor and debugger X X X X X Full client, Administration client
  PL/SQL editor and debugger     X2 X X Full client
  Java routine editor and debugger X X X X X Full client
  SQLJ development X X X X X Full client
  XML editor, schema editor, and annotated XSD mapping editor X X X X X Full client
  Data Web Services development and deployment X X X X X Full client
  Mass deployment to the enterprise X X X X X Full client
  Performance metrics view X X X X X Full client
  SQL outline view X X X X X Full client
  pureQuery Runtime X X X X X Full client
  IBM Common Repositories perspective X X X X X Full client
  pureQuery Runtime API support X X X X X Full client
Task category Feature V9.1 V9.5 V9.7 V9.8 V10.1 Data Studio component
Query tuning  
  Tune SQL statements X X X X X Full client, Administration client
  Capture and send the environments of single SQL statements to IBM Support           Full client, Administration client
  Create reports for single SQL statements that summarize recommendations and information about database objects in access plans X X X X X Full client, Administration client
  Create reports for single SQL statements that summarize the statistics that the DB2 optimizer uses to create access plans X X X X X Full client, Administration client
  Format single SQL statements for better readability and analysis X X X X X Full client, Administration client
  Generate RUNSTATS commands for fixing problems with statistics for single SQL statements X X X X X Full client, Administration client
  Generate visual representations of access plans for single SQL statements X X X X X Full client, Administration client
  Tune single SQL statements that you enter directly into the workflow assistant X X X X X Full client, Administration client
Task category Feature V9.1 V9.5 V9.7 V9.8 V10.1 Data Studio component
Instance management  
  Start, stop, quiesce, unquiesce a DB2 for Linux, UNIX, and Windows instance X X2 X2 X2 X2 Full client, Administration client
  Start, stop, quiesce, unquiesce a DB2 pureScale member X X2 X2 X2 X2 Full client, Administration client
  Configure a DB2 for Linux, UNIX, and Windows instance and database X X2 X2 X2 X2 Full client, Administration client
  Configure a DB2 pureScale member X X2 X2 X2 X2 Full client, Administration client
Task category Feature V9.1 V9.5 V9.7 V9.8 V10.1 Data Studio component
Object management  
  Create, alter, drop single database objects X X2 X2,3 X2 X2 Full client, Administration client
  Create, alter, drop multiple database objects in a single change plan X X2 X2 X2 X2 Full client, Administration client
  IBM InfoSphere Federation Server support X X2 X2 X2 X2 Full client, Administration client
  View and edit privileges for DB2 data server objects and authorization IDs X X X X X Full client, Administration client
  Impact analysis - report on dependencies X X X X X Full client, Administration client
  Generate DDL X X X X X Full client, Administration client
  Generate maintenance and data preservation commands X X2 X2 X2 X2 Full client, Administration client
  Data distribution viewer X X X X X Full client, Administration client
  Compare and sync X X X X X Full client, Administration client
  Compare and migrate data objects X X X X X Full client, Administration client
Task category Feature V9.1 V9.5 V9.7 V9.8 V10.1 Data Studio component
Data management  
  Copy and paste data objects X X X X X Full client
  Load and unload data with EXPORT and LOAD commands X X2 X2 X2 X2 Full client, Administration client
  Export rows from the SQL Results view X X X X X Full client, Administration client
  Sample contents X X X X X Full client, Administration client
  Load data with SQL or DB2 utilities X X X X X Full client, Administration client
  Unload using InfoSphere Optim High Performance Unload (separate purchase) X X2 X2 X2 X2 Full client, Administration client
  Data table editor X X X X X Full client, Administration client
  Browse or edit data and filter the view by columns and rows X
(browse only)
X X3 X X Full client, Administration client
Job management  
  Job manager X X X X X Web console
Health monitoring  
  Health monitor X X X X X Web console

Legend:
X1 - Only supported in IBM Data Studio V3.1.1
X2 - Includes support for DB2® compatibility mode, but requires a JCC driver
X3 - Includes support for ANTs Software product IBM® DB2 SQL Skin for applications compatible with Sybase ASE (IBM DB2 SSacSA)

Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Data Studio

Software version:

3.1, 3.1.1

Operating system(s):

Linux, Windows

Reference #:

7022148

Modified date:

2012-11-28

Translate my page

Machine Translation

Content navigation