Product Documentation
Abstract
Use the following table to compare the features and capabilities between the Data Studio stand-alone and IDE packages.
Content
Data Studio stand-alone capabilities compared to IDE capabilities
| Group | Details | Data Studio stand-alone | Data Studio IDE |
|---|---|---|---|
| Architecture data modeling | |||
| Shell sharing with other Rational or Optim products | X | ||
| Database overview diagrams | X | X | |
| Application development | |||
| Integrated Query Editor (SQL and XQuery) with query formatting | X | X | |
| SQL Builder | X | X | |
| Advanced query formatting | X | X | |
| Visual Explain | X | X | |
| Access plan graph (enhanced Visual Explain) | X | X | |
| Single query statistics advisor | X | X | |
| SQL query environment capture for serviceability (z/OS only) | X | X | |
| SQL routine editor and debugger (including PL/SQL for DB2 for Linux, UNIX, and Windows deployments) | X | X | |
| Java routine editor and debugger | X | ||
| SQLJ development | X | ||
| XML editor, schema editor, and annotated XSD mapping editor | X | ||
| Data Web Services development and deployment | X | ||
| Instance management | |||
| Start, stop, quiesce, unquiesce a DB2 for Linux, UNIX, and Windows instance | X | X | |
| Start, stop, quiesce, unquiesce a DB2 pureScale member | X | X | |
| Configure a DB2 for Linux, UNIX, and Windows instance | X | X | |
| Configure a DB2 pureScale member | X | X | |
| Object management | |||
| Create, alter, drop DB2 or IDS server objects | X | X | |
| View and edit privileges for DB2 and IDS data server objects and authorization IDS | X | X | |
| Impact analysis - report on dependencies | X | X | |
| Generate DDL | X | X | |
| Generate commands for DB2 for Linux, UNIX, and Windows - start, stop, quiesce, etc. | X | X | |
| Generate utilities for DB2 for Linux, UNIX, and Windows - backup restore, reorg, etc | X | X | |
| Data distribution viewer | X | X | |
| Data management | |||
| Export and import table | X | X | |
| Extract data, extract as XML (from SQL results) | X | X | |
| Sample contents | X | X | |
| Load data | X | X | |
| Unload using Optim High Performance Unload (separate purchase) | X | X | |
| Edit data | X | X |
[{"Product":{"code":"SS62YD","label":"IBM Data Studio"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"2.2.1;2.2.1.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27023330