IBM Support

Data Studio V4.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

The following IBM Data Studio components and versions are covered in this document:

  • IBM Data Studio client Version 4.1.1
  • IBM Data Studio web console Version 4.1.1
  • IBM Data Studio client Version 4.1.0.1
  • IBM Data Studio client Version 4.1
  • IBM Data Studio web console Version 4.1

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 4.1.x document.

See the system requirements for IBM Data Studio Version 4.1.x at http://www.ibm.com/support/docview.wss?uid=swg27038176.



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 V10.5
General
  Database catalog filter   X X X X
Architecture data modeling
  Database overview diagrams X X X X X
Application development
  Integrated Query Editor (SQL and XQuery) with query formatting X X X X X
  SQL Builder X X X X X
  Query formatting X X X X X
  Visual Explain X X X X X
  Access plan graph (enhanced Visual Explain) X X X X X
  Statistics advisor X X X X X
  Routine test configuration X 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 X
  Creating SQL routines from the Data Source Explorer and Admin Explorer using Routine Editor X X X X X
  Stored procedure editor and debugger X X X X X
  User-defined function editor and debugger X X X X X
  PL/SQL editor and debugger  X1 X X X
  Java routine editor and debugger X X X X X
  VARRAY support X X X X X
  SQLJ development X X X X X
  XML editor, schema editor, and annotated XSD mapping editor X X X X X
  Data Web Services development and deployment X X X X X
  Performance metrics view X X X X X
  SQL outline view X X X X X
  pureQuery Runtime X X X X X
  IBM Common Repositories perspective X X X X X
  pureQuery Runtime API support X X X X X
Task category Feature V9.5 V9.7 V9.8 V10.1 V10.5
Query tuning
  Tune SQL statements X 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 X
  Format single SQL statements for better readability and analysis X X X X X
  Generate RUNSTATS commands for fixing problems with statistics for single SQL statements X X X X X
  Generate visual representations of access plans for single SQL statements X X X X X
Task category Feature V9.5 V9.7 V9.8 V10.1 V10.5
Instance management
  Start, stop, quiesce, unquiesce a DB2 for Linux, UNIX, and Windows instance X X X X X
  Start, stop, quiesce, unquiesce a DB2 pureScale member X1 X1 X1 X1 X1
  Configure a DB2 for Linux, UNIX, and Windows instance X1 X1 X1 X1 X1
  Manage and configure DB2 pureScale members     X1 X1 X1
Task category Feature V9.5 V9.7 V9.8 V10.1 V10.5
Database management
  Start, stop, quiesce, or unquiesce a DB2 for Linux, UNIX, and Windows database   X X X X
  Create, backup, restore, recover, roll forward, or drop a DB2 for Linux, UNIX, and Windows database   X X X X
  Configure a DB2 for Linux, UNIX, and Windows database   X1 X1 X1 X1
  Setup and manage a DB2 for Linux, UNIX, and Windows database for high availability disaster recovery (HADR)   X X X X
Task category Feature V9.5 V9.7 V9.8 V10.1 V10.5
Object management
  Create, alter, drop single database objects X1 X1 X1 X1 X1
  Create, alter, drop multiple database objects in a single change plan X1 X1 X1 X1 X1
  Convert tables to column organization to support BLU Acceleration         X
  IBM InfoSphere Federation Server support X1 X1 X1 X1 X1
  View and edit privileges for DB2 data server objects and authorization IDs X X X X X
  Impact analysis - report on dependencies X X X X X
  Generate DDL X X X X X
  Generate maintenance and data preservation commands X1 X1 X1 X1 X1
  Data distribution viewer X X X X X
  Compare and sync X X X X X
  Compare and migrate data objects X X X X X
Task category Feature V9.5 V9.7 V9.8 V10.1 V10.5
Data management
  Copy and paste data objects X X X X X
  Load and unload data with EXPORT and LOAD commands X1 X1 X1 X1 X1
  Export rows from the SQL Results view X X X X X
  Sample contents X X X X X
  Load data with SQL or DB2 utilities X X X X X
  Unload using InfoSphere Optim High Performance Unload (separate purchase) X X1 X1 X1 X1
  Data table editor X X X X X
  Browse or edit data and filter the view by columns and rows X X X X X
Legend:
X1 - Includes support for DB2® compatibility mode, but requires a JCC driver.

Data Studio Web Console

Task category Feature V9.5 V9.7 V9.8 V10.1 V10.5
Job management
  Job manager X X X X X
Health monitoring
  Health monitor X 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 V11.1
General  
  Database catalog filter X X X
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 X X X
  Visual Explain X X X
  Access plan graph (enhanced Visual Explain) X X X
  Statistics advisor X X X
  SQL query environment capture for serviceability X X X
  Routine test configuration X X X
  Database configuration check for routine development X X X
  Stored procedure editor and debugger X X X
  User-defined function editor and debugger X X X
  Java routine editor and debugger X X X
  SQLJ development X X X
  XML editor, schema editor, and annotated XSD mapping editor X X X
  Data Web Services development and deployment X X X
  SQL outline view X X X
  pureQuery Runtime X X X
  IBM Common Repositories perspective X X X
  pureQuery Runtime API support X X X
Task category Feature V9.1 V10.1 V11.1
Query tuning  
  Tune SQL statements X X X
  Capture and send the environments of single SQL statements to IBM Support X X X
  Create reports for single SQL statements that summarize the statistics that the DB2 optimizer uses to create access plans X X X
  Format single SQL statements for better readability and analysis X X X
  Generate RUNSTATS commands for fixing problems with statistics for single SQL statements X X X
  Generate visual representations of access plans for single SQL statements X X X
Task category Feature V9.1 V10.1 V11.1
Object management  
  Create, alter, drop single database objects X X X
  Create, alter, drop multiple database objects in a single change plan      
  IBM InfoSphere Federation Server support X X X
  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 V9.1 V10.1 V11.1
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 X X X

Data Studio Web Console

Task category Feature V9.1 V10.1 V11.1
Job management  
  Job manager X X X
Health monitoring  
  Health monitor X 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 X1 X1
  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  
Legend:
X1 - Not supported when a connection is created by using only the IBM Toolbox for Java driver

Data Studio Web Console

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 V12.1
General  
  Database catalog filter     
Architecture data modeling  
  Database overview diagrams X1 X1 X1 X1 X1
Application development  
  Integrated Query Editor (SQL and XQuery) with query formatting X1 X1 X1 X1 X1
  SQL Builder X1 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 X
  Stored procedure editor and debugger X X X X X
  User-defined function editor and debugger X 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 X
  Performance metrics view     
  SQL outline view     
  pureQuery Runtime X X X X X
  IBM Common Repositories perspective     
  pureQuery Runtime API support X X X X X
Task category Feature V10 V11.1 V11.5 V11.7 V12.1
Object management  
  Create, alter, drop single database objects X1 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 X1
  Generate DDL X1 X1 X1 X1 X1
  Generate maintenance and data preservation commands     
  Data distribution viewer X X X X X
  Compare and sync X X X X X
  Compare and migrate data objects     
Task category Feature V10 V11.1 V11.5 V11.7 V12.1
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 X1
  Sample contents X1 X1 X1 X1 X1
  Load data with SQL X1 X1 X1 X1 X1
  Data table editor X1 X1 X1 X1 X1
  Browse or edit data and filter the view by columns and rows     
Legend:
X1 - Also supported by the Informix native driver

Data Studio Web Console

Task category Feature V10 V11.1 V11.5 V11.7 V12.1
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      
  Access plan graph (enhanced Visual Explain)   
  Statistics advisor   
  Stored procedure editor and debugger      
  User-defined function editor and debugger      
  PL/SQL editor and debugger      
  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 V2008 V2008 R2 V2012
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 V2008 V2008 R2 V2012
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 V2008 V2008 R2 V2012
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 V2008 V2008 R2 V2012
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 

[{"Product":{"code":"SS62YD","label":"IBM Data Studio"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Installation\/Migration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"4.1;4.1.0.1;4.1.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg27038175