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
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

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

Data Studio Client

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

Task category Feature V9.1 V10.1
Job management  
  Job manager X X
Health monitoring  
  Health monitor X X

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  
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

Task category Feature V6.1 V7.1
Job management  
  Job manager    
Health monitoring  
  Health monitor    

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  
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

Task category Feature V10 V11.1 V11.5 V11.7
Job management  
  Job manager        
Health monitoring  
  Health monitor        

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

Data Studio Client

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

Task category Feature V10g R1 V10g R2 V11g R1
Job management  
  Job manager      
Health monitoring  
  Health monitor      

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

Data Studio Client

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

Task category Feature V2005 V2008 V2008 R2
Job management  
  Job manager      
Health monitoring  
  Health monitor      

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

Data Studio Client

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

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

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Data Studio

Software version:

3.2

Operating system(s):

Linux, Windows

Reference #:

7036670

Modified date:

2012-12-07

Translate my page

Machine Translation

Content navigation