IBM Support

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 productsFull client
  Install help content locally with the Local Help UpdaterFull client
Task category Feature V9.1 V9.5 V9.7 V9.8 V10.1 Data Studio component
General  
  Database catalog filter     X X XFull client, Administration client
Architecture data modeling  
  Database overview diagrams X X X X XFull client, Administration client
Application development  
  Integrated Query Editor (SQL and XQuery) with query formatting X X X X XFull client, Administration client
  SQL Builder X X X X XFull client, Administration client
  Query formatting X X X X XFull client, Administration client
  Visual Explain X X X X XFull client, Administration client
  Access plan graph (enhanced Visual Explain) X X X X XFull client, Administration client
  Statistics advisor X X X X XFull client, Administration client
  Routine test configuration X1 X1 X1 X1 X1Full client, Administration client
  Debugging, editing, and running routines in DB2 database modules X1 X1 X1 X1 X1Full client, Administration client
  Editing, debugging, and redeploying SQL routines deployed in databases X1 X1 X1 X1 X1Full client, Administration client
  Creating SQL routines from the Data Source Explorer and Admin Explorer using Routine Editor X1 X1 X1 X1 X1Full client, Administration client
  VARRAY support X1 X1 X1 X1 X1Full client, Administration client
  Stored procedure editor and debugger X X X X XFull client, Administration client
  User-defined function editor and debugger X X X X XFull client, Administration client
  PL/SQL editor and debugger   X2 XXFull client
  Java routine editor and debugger X X X X XFull client
  SQLJ development X X X X XFull client
  XML editor, schema editor, and annotated XSD mapping editor X X X X XFull client
  Data Web Services development and deployment X X X X XFull client
  Mass deployment to the enterprise X X X X XFull client
  Performance metrics view X X X X XFull client
  SQL outline view X X X X XFull client
  pureQuery Runtime X X X X XFull client
  IBM Common Repositories perspective X X X X XFull client
  pureQuery Runtime API support X X X X XFull 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 X2Full client, Administration client
  Start, stop, quiesce, unquiesce a DB2 pureScale member X X2 X2 X2 X2Full client, Administration client
  Configure a DB2 for Linux, UNIX, and Windows instance and database X X2 X2 X2 X2Full client, Administration client
  Configure a DB2 pureScale member X X2 X2 X2 X2Full 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 X2Full client, Administration client
  Create, alter, drop multiple database objects in a single change plan X X2 X2 X2 X2Full client, Administration client
  IBM InfoSphere Federation Server support X X2 X2 X2 X2Full client, Administration client
  View and edit privileges for DB2 data server objects and authorization IDs X X X X XFull client, Administration client
  Impact analysis - report on dependencies X X X X XFull client, Administration client
  Generate DDL X X X X XFull client, Administration client
  Generate maintenance and data preservation commands X X2 X2 X2 X2Full client, Administration client
  Data distribution viewer X X X X XFull client, Administration client
  Compare and sync X X X X XFull client, Administration client
  Compare and migrate data objects X X X X XFull 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 XFull client
  Load and unload data with EXPORT and LOAD commands X X2 X2 X2 X2Full client, Administration client
  Export rows from the SQL Results view X X X X XFull client, Administration client
  Sample contents X X X X XFull client, Administration client
  Load data with SQL or DB2 utilities X X X X XFull client, Administration client
  Unload using InfoSphere Optim High Performance Unload (separate purchase) X X2 X2 X2 X2Full client, Administration client
  Data table editor X X X X XFull client, Administration client
  Browse or edit data and filter the view by columns and rows X
(browse only)
X X3 X XFull client, Administration client
Job management  
  Job manager X X X X XWeb console
Health monitoring  
  Health monitor X X X X XWeb 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)

[{"Product":{"code":"SS62YD","label":"IBM Data Studio"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"3.1;3.1.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg27022148