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
Tab navigation
Legend:
X1 - Only supported in IBM Data Studio V3.1.1
X2 - Only supported when connection is created using IBM Tool box driver
| 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 | V5.4 | V6.1 | V7.1 | Data Studio component |
| General | |||||
| Database catalog filter | Full client, Administration client | ||||
| Architecture data modeling | |||||
| Database overview diagrams | X2 | X2 | X2 | Full client, Administration client | |
| Application development | |||||
| Integrated Query Editor (SQL and XQuery) with query formatting | X2 | X2 | X2 | Full client, Administration client | |
| SQL Builder | X2 | X2 | X2 | Full client, Administration client | |
| Query formatting | Full client, Administration client | ||||
| Visual Explain | Full client, Administration client | ||||
| Access plan graph (enhanced Visual Explain) | Full client, Administration client | ||||
| Statistics advisor | Full client, Administration client | ||||
| Routine test configuration | X1 | X1 | X1 | Full client, Administration client | |
| Stored procedure editor and debugger | X | X | X | Full client, Administration client | |
| User-defined function editor and debugger | Full client, Administration client | ||||
| PL/SQL editor and debugger | Full client | ||||
| Java routine editor and debugger | X | X | X | Full client | |
| SQLJ development | Full client | ||||
| XML editor, schema editor, and annotated XSD mapping editor | Full client | ||||
| Data Web Services development and deployment | Full client | ||||
| Mass deployment to the enterprise | X | X | X | Full client | |
| SQL outline view | X | X | X | Full client | |
| pureQuery Runtime | X | X | X | Full client | |
| IBM Common Repositories perspective | Full client | ||||
| pureQuery Runtime API support | X | X | X | Full client | |
| Task category | Feature | V5.4 | V6.1 | V7.1 | Data Studio component |
| Instance management | |||||
| Start, stop, quiesce, unquiesce a DB2 for Linux, UNIX, and Windows instance | Full client, Administration client | ||||
| Start, stop, quiesce, unquiesce a DB2 pureScale member | Full client, Administration client | ||||
| Configure a DB2 for Linux, UNIX, and Windows instance and database | Full client, Administration client | ||||
| Configure a DB2 pureScale member | Full client, Administration client | ||||
| Task category | Feature | V5.4 | V6.1 | V7.1 | Data Studio component |
| Object management | |||||
| Create, alter, drop single database objects | X2 | X2 | X2 | Full client, Administration client | |
| Create, alter, drop multiple database objects in a single change plan | Full client, Administration client | ||||
| IBM InfoSphere Federation Server support | X | X | X | Full client, Administration client | |
| View and edit privileges for DB2 data server objects and authorization IDs | Full client, Administration client | ||||
| Impact analysis - report on dependencies | X2 | X2 | X2 | Full client, Administration client | |
| Generate DDL | X2 | X2 | X2 | Full client, Administration client | |
| Generate maintenance and data preservation commands | Full client, Administration client | ||||
| Data distribution viewer | X2 | X2 | X2 | Full client, Administration client | |
| Compare and sync | X2 | X2 | X2 | Full client, Administration client | |
| Compare and migrate data objects | Full client, Administration client | ||||
| Task category | Feature | V5.4 | V6.1 | V7.1 | Data Studio component |
| Data management | |||||
| Copy and paste data objects | Full client | ||||
| Load and unload data with EXPORT and LOAD commands | Full client, Administration client | ||||
| Export rows from the SQL Results view | X2 | X2 | X2 | Full client, Administration client | |
| Sample contents | X2 | X2 | X2 | Full client, Administration client | |
| Load data with SQL | X2 | X2 | X2 | Full client, Administration client | |
| Unload using InfoSphere Optim High Performance Unload (separate purchase) | Full client, Administration client | ||||
| Data table editor | X2 | X2 | X2 | Full client, Administration client | |
| Browse or edit data and filter the view by columns and rows | Full client, Administration client | ||||
| Job management | |||||
| Job manager | Web console | ||||
| Health monitoring | |||||
| Health monitor | Web console | ||||
Legend:
X1 - Only supported in IBM Data Studio V3.1.1
X2 - Only supported when connection is created using IBM Tool box driver
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.