IBM Support

Data Studio V3.2 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 and Changed in IBM Data Studio Version 3.2 document.



View the features and supported data servers for the following components:

Data Studio Client

Legend:
X1 - Includes support for DB2® compatibility mode, but requires a JCC driver

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

Data Studio Web Console

Legend:
X1 - Includes support for DB2® compatibility mode, but requires a JCC driver

View the features and supported data servers for the following components:

Data Studio Client

Task category Feature V9.5 V9.7 V9.8 V10.1
Job management
  Job manager X X X X
Health monitoring
  Health monitor X X X X
Task category Feature  
General  
  Shell sharing with other Rational or InfoSphere Optim products
  Enterprise deployment
  Install help content locally with the Local Help Updater
Task category Feature V9.1 V10.1
General  
  Database catalog filter X X
Architecture data modeling  
  Database overview diagrams X X
Application development  
  Integrated Query Editor (SQL and XQuery) with query formatting X X
  SQL Builder X X
  Query formatting X X
  Visual Explain X X
  Access plan graph (enhanced Visual Explain) X X
  Statistics advisor X X
  SQL query environment capture for serviceability X X
  Routine test configuration X X
  Database configuration check for routine development X X
  Stored procedure editor and debugger X X
  User-defined function editor and debugger X X
  Java routine editor and debugger X X
  SQLJ development X X
  XML editor, schema editor, and annotated XSD mapping editor X X
  Data Web Services development and deployment X X
  SQL outline view X X
  pureQuery Runtime X X
  IBM Common Repositories perspective X X
  pureQuery Runtime API support X X
Task category Feature V9.1 V10.1
Query tuning  
  Tune SQL statements X X
  Capture and send the environments of single SQL statements to IBM Support X X
  Create reports for single SQL statements that summarize the statistics that the DB2 optimizer uses to create access plans X X
  Format single SQL statements for better readability and analysis X X
  Generate RUNSTATS commands for fixing problems with statistics for single SQL statements X X
  Generate visual representations of access plans for single SQL statements X X
Task category Feature V9.1 V10.1
Object management  
  Create, alter, drop single database objects X X
  Create, alter, drop multiple database objects in a single change plan  
  IBM InfoSphere Federation Server support X X
  View and edit privileges for DB2 data server objects and authorization IDs X X
  Impact analysis - report on dependencies X X
  Generate DDL X X
  Generate maintenance and data preservation commands  
  Data distribution viewer X X
  Compare and sync X X
  Compare and migrate data objects  
Task category Feature V9.1 V10.1
Data management  
  Copy and paste data objects X X
  Load and unload data with EXPORT and LOAD commands  
  Export rows from the SQL Results view X X
  Sample contents X X
  Load data with SQL X X
  Data table editor X X
  Browse or edit data and filter the view by columns and rows X X

Data Studio Web Console


View the features and supported data servers for the following components:

Data Studio Client

Legend:
X1 - Not supported when a connection is created by using only the IBM Toolbox for Java driver

Task category Feature V9.1 V10.1
Job management  
  Job manager X X
Health monitoring  
  Health monitor X X
Task category Feature  
General  
  Shell sharing with other Rational or InfoSphere Optim products
  Enterprise deployment
  Install help content locally with the Local Help Updater
Task category Feature V6.1 V7.1
General  
  Database catalog filter  
Architecture data modeling  
  Database overview diagrams X X
Application development  
  Integrated Query Editor (SQL and XQuery) with query formatting X X
  SQL Builder X X
  Query formatting  
  Visual Explain  
  Access plan graph (enhanced Visual Explain)  
  Statistics advisor  
  Routine test configuration X1 X1
  Stored procedure editor and debugger X1 X1
  User-defined function editor and debugger  
  PL/SQL editor and debugger  
  Java routine editor and debugger X1 X1
  SQLJ development  
  XML editor, schema editor, and annotated XSD mapping editor  
  Data Web Services development and deployment  
  SQL outline view X1 X1
  pureQuery Runtime X1 X1
  IBM Common Repositories perspective  
  pureQuery Runtime API support X1 X1
Task category Feature V6.1 V7.1
Object management  
  Create, alter, drop single database objects X X
  Create, alter, drop multiple database objects in a single change plan  
  IBM InfoSphere Federation Server support X1 X1
  View and edit privileges for DB2 data server objects and authorization IDs  
  Impact analysis - report on dependencies X X
  Generate DDL X X
  Generate maintenance and data preservation commands  
  Data distribution viewer X X
  Compare and sync X X
  Compare and migrate data objects  
Task category Feature V6.1 V7.1
Data management  
  Copy and paste data objects  
  Load and unload data with EXPORT and LOAD commands  
  Export rows from the SQL Results view X X
  Sample contents X X
  Load data with SQL X X
  Data table editor X X
  Browse or edit data and filter the view by columns and rows  

Data Studio Web Console

Legend:
X1 - Not supported when a connection is created by using only the IBM Toolbox for Java driver


View the features and supported data servers for the following components:

Data Studio Client

Legend:
X1 - Also supported by the Informix native driver

Task category Feature V6.1 V7.1
Job management  
  Job manager  
Health monitoring  
  Health monitor  
Task category Feature  
General  
  Shell sharing with other Rational or InfoSphere Optim products
  Enterprise deployment
  Install help content locally with the Local Help Updater
Task category Feature V10 V11.1 V11.5 V11.7
General  
  Database catalog filter     
Architecture data modeling  
  Database overview diagrams X1 X1 X1 X1
Application development  
  Integrated Query Editor (SQL and XQuery) with query formatting X1 X1 X1 X1
  SQL Builder X1 X1 X1 X1
  Query formatting    
  Visual Explain     X  
  Access plan graph (enhanced Visual Explain)    
  Statistics advisor    
  SQL query environment capture for serviceability    
  Routine test configuration X X X X
  Stored procedure editor and debugger X X X X
  User-defined function editor and debugger X X X X
  PL/SQL editor and debugger    
  Java routine editor and debugger    
  SQLJ development    
  XML editor, schema editor, and annotated XSD mapping editor    
  Data Web Services development and deployment X X X X
  Performance metrics view    
  SQL outline view    
  pureQuery Runtime X X X X
  IBM Common Repositories perspective    
  pureQuery Runtime API support X X X X
Task category Feature V10 V11.1 V11.5 V11.7
Object management  
  Create, alter, drop single database objects X1 X1 X1 X1
  Create, alter, drop multiple database objects in a single change plan    
  IBM InfoSphere Federation Server support    
  View and edit privileges for DB2 data server objects and authorization IDs X X  
  Impact analysis - report on dependencies X1 X1 X1 X1
  Generate DDL X1 X1 X1 X1
  Generate maintenance and data preservation commands    
  Data distribution viewer X X X X
  Compare and sync X X X X
  Compare and migrate data objects    
Task category Feature V10 V11.1 V11.5 V11.7
Data management  
  Copy and paste data objects    
  Load and unload data with EXPORT and LOAD commands    
  Export rows from the SQL Results view X1 X1 X1 X1
  Sample contents X1 X1 X1 X1
  Load data with SQL X1 X1 X1 X1
  Data table editor X1 X1 X1 X1
  Browse or edit data and filter the view by columns and rows    

Data Studio Web Console

Legend:
X1 - Also supported by the Informix native driver


View the features and supported data servers for the following components:

Data Studio Client

Task category Feature V10 V11.1 V11.5 V11.7
Job management  
  Job manager    
Health monitoring  
  Health monitor    
-->
Task category Feature  
General  
  Shell sharing with other Rational or InfoSphere Optim products
  Enterprise deployment
  Install help content locally with the Local Help Updater
Task category Feature V10g R1 V10g R2 V11g R1
General  
  Database catalog filter   
Architecture data modeling  
  Database overview diagrams X X X
Application development  
  Integrated Query Editor (SQL and XQuery) with query formatting X X X
  SQL Builder X X X
  Query formatting   
  Visual Explain X X X
  Access plan graph (enhanced Visual Explain)   
  Statistics advisor   
  Stored procedure editor and debugger X X X
  User-defined function editor and debugger X X X
  PL/SQL editor and debugger X X X
  Java routine editor and debugger   
  Routine test configuration   
  SQLJ development   
  XML editor, schema editor, and annotated XSD mapping editor   
  Data Web Services development and deployment   
  Performance metrics view   
  SQL outline view   
  pureQuery Runtime X X X
  IBM Common Repositories perspective X X X
  pureQuery Runtime API support X X X
Task category Feature V10g R1 V10g R2 V11g R1
Object management  
  Create, alter, drop single database objects X X X
  Create, alter, drop multiple database objects in a single change plan   
  View and edit privileges for DB2 data server objects and authorization IDs X X X
  Impact analysis - report on dependencies X X X
  Generate DDL X X X
  Generate maintenance and data preservation commands   
  Data distribution viewer X X X
  Compare and sync X X X
  Compare and migrate data objects   
Task category Feature V10g R1 V10g R2 V11g R1
Data management  
  Copy and paste data objects X X X
  Load and unload data with EXPORT and LOAD commands   
  Export rows from the SQL Results view X X X
  Sample contents X X X
  Load data with SQL X X X
  Data table editor X X X
  Browse or edit data and filter the view by columns and rows   

Data Studio Web Console


View the features and supported data servers for the following components:

Data Studio Client

Task category Feature V10g R1 V10g R2 V11g R1
Job management  
  Job manager   
Health monitoring  
  Health monitor   
Task category Feature  
General  
  Shell sharing with other Rational or InfoSphere Optim products
  Enterprise deployment
  Install help content locally with the Local Help Updater
Task category Feature V2005 V2008 V2008 R2
General  
  Database catalog filter   
Architecture data modeling  
  Database overview diagrams X X X
Application development  
  Integrated Query Editor (SQL and XQuery) with query formatting X X X
  SQL Builder X X X
  Query formatting   
  Visual Explain   
  Access plan graph (enhanced Visual Explain)   
  Statistics advisor   
  SQL query environment capture for serviceability   
  Stored procedure editor and debugger   
  User-defined function editor and debugger   
  PL/SQL editor and debugger   
  Java routine editor and debugger   
  SQLJ development   
  XML editor, schema editor, and annotated XSD mapping editor   
  Data Web Services development and deployment   
  Performance metrics view   
  SQL outline view   
  pureQuery Runtime   
  IBM Common Repositories perspective   
  pureQuery Runtime API support   
Task category Feature V2005 V2008 V2008 R2
Object management  
  Create, alter, drop single database objects   
  Create, alter, drop multiple database objects in a single change plan   
  IBM InfoSphere Federation Server support   
  View and edit privileges for DB2 data server objects and authorization IDs   
  Impact analysis - report on dependencies X X X
  Generate DDL X X X
  Generate maintenance and data preservation commands   
  Data distribution viewer X X X
  Compare and sync X X X
  Compare and migrate data objects   
Task category Feature V2005 V2008 V2008 R2
Data management  
  Copy and paste data objects   
  Load and unload data with EXPORT and LOAD commands   
  Export rows from the SQL Results view X X X
  Sample contents X X X
  Load data with SQL X X X
  Data table editor X X X
  Browse or edit data and filter the view by columns and rows   

Data Studio Web Console


View the features and supported data servers for the following components:

Data Studio Client

Task category Feature V2005 V2008 V2008 R2
Job management  
  Job manager   
Health monitoring  
  Health monitor   
Task category Feature  
General  
  Shell sharing with other Rational or InfoSphere Optim products
  Enterprise deployment
  Install help content locally with the Local Help Updater
Task category Feature V15.0
General  
  Database catalog filter 
Architecture data modeling  
  Database overview diagrams X
Application development  
  Integrated Query Editor (SQL and XQuery) with query formatting X
  SQL Builder X
  Query formatting 
  Visual Explain 
  Access plan graph (enhanced Visual Explain) 
  Statistics advisor 
  SQL query environment capture for serviceability 
  Stored procedure editor and debugger X
(editor only)
  User-defined function editor and debugger 
  PL/SQL editor and debugger 
  Java routine editor and debugger 
  SQLJ development 
  XML editor, schema editor, and annotated XSD mapping editor 
  Data Web Services development and deployment 
  Performance metrics view 
  SQL outline view 
  pureQuery Runtime 
  IBM Common Repositories perspective 
  pureQuery Runtime API support 
Task category Feature V15.0
Object management  
  Create, alter, drop single database objects X
  Create, alter, drop multiple database objects in a single change plan 
  IBM InfoSphere Federation Server support 
  View and edit privileges for DB2 data server objects and authorization IDs 
  Impact analysis - report on dependencies 
  Generate DDL X
  Generate maintenance and data preservation commands 
  Data distribution viewer X
  Compare and sync X
  Compare and migrate data objects 
Task category Feature V15.0
Data management  
  Copy and paste data objects 
  Load and unload data with EXPORT and LOAD commands 
  Export rows from the SQL Results view X
  Sample contents X
  Load data with SQL X
  Data table editor X
  Browse or edit data and filter the view by columns and rows 

Data Studio Web Console

[{"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.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg27036670

Task category Feature V15.0
Job management  
  Job manager 
Health monitoring  
  Health monitor