IBM Support

Data Studio V2.2.1.x features: stand-alone versus IDE

Product Documentation


Use the following table to compare the features and capabilities between the Data Studio stand-alone and IDE packages.


Data Studio stand-alone capabilities compared to IDE capabilities

GroupDetailsData Studio stand-aloneData Studio IDE
Architecture data modeling
Shell sharing with other Rational or Optim productsX
Database overview diagramsXX
Application development
Integrated Query Editor (SQL and XQuery) with query formattingXX
SQL BuilderXX
Advanced query formattingXX
Visual ExplainXX
Access plan graph (enhanced Visual Explain)XX
Single query statistics advisorXX
SQL query environment capture for serviceability (z/OS only)XX
SQL routine editor and debugger (including PL/SQL for DB2 for Linux, UNIX, and Windows deployments)XX
Java routine editor and debuggerX
SQLJ developmentX
XML editor, schema editor, and annotated XSD mapping editorX
Data Web Services development and deploymentX
Instance management
Start, stop, quiesce, unquiesce a DB2 for Linux, UNIX, and Windows instanceXX
Start, stop, quiesce, unquiesce a DB2 pureScale memberXX
Configure a DB2 for Linux, UNIX, and Windows instanceXX
Configure a DB2 pureScale memberXX
Object management
Create, alter, drop DB2 or IDS server objectsXX
View and edit privileges for DB2 and IDS data server objects and authorization IDSXX
Impact analysis - report on dependenciesXX
Generate DDLXX
Generate commands for DB2 for Linux, UNIX, and Windows - start, stop, quiesce, etc.XX
Generate utilities for DB2 for Linux, UNIX, and Windows - backup restore, reorg, etcXX
Data distribution viewerXX
Data management
Export and import tableXX
Extract data, extract as XML (from SQL results)XX
Sample contentsXX
Load dataXX
Unload using Optim High Performance Unload (separate purchase)XX
Edit dataXX

[{"Product":{"code":"SS62YD","label":"IBM Data Studio"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"2.2.1;","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018