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.
Tab navigation
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:
Average rating
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.