Tuesday, April 05, 2011

Data Studio Standalone compared to IDE

Richie on the Data Studio team recently pointed out a great table comparing Data Studio Standalone to Data Studio IDE. The short of it is that both are great tools for administering DB2, with IDE adding some features aimed at Java developers specifically. Let me put a slightly rearranged version here:

Group Details Data Studio Standalone Data Studio IDE
Architecture data modeling



Database overview diagrams Yes Yes
Instance management



Start, stop, quiesce, unquiesce a DB2 for Linux, UNIX, and Windows instance Yes Yes

Start, stop, quiesce, unquiesce a DB2 pureScale member Yes Yes

Configure a DB2 for Linux, UNIX, and Windows instance Yes Yes

Configure a DB2 pureScale member Yes Yes
Object management



Create, alter, drop DB2 or IDS server objects Yes Yes

View and edit privileges for DB2 and IDS data server objects and authorization IDS Yes Yes

Impact analysis - report on dependencies Yes Yes

Generate DDL Yes Yes

Generate commands for DB2 for Linux, UNIX, and Windows - start, stop, quiesce, etc. Yes Yes

Generate utilities for DB2 for Linux, UNIX, and Windows - backup restore, reorg, etc Yes Yes

Data distribution viewer Yes Yes
Data management



Export and import table Yes Yes

Extract data, extract as XML (from SQL results) Yes Yes

Sample contents Yes Yes

Load data Yes Yes

Unload using Optim High Performance Unload (separate purchase) Yes Yes

Edit data Yes Yes
Application development



Integrated Query Editor (SQL and XQuery) with query formatting Yes Yes

SQL Builder Yes Yes

Advanced query formatting Yes Yes

Visual Explain Yes Yes

Access plan graph (enhanced Visual Explain) Yes Yes

Single query statistics advisor Yes Yes

SQL query environment capture for serviceability (z/OS only) Yes Yes

SQL routine editor and debugger (including PL/SQL for DB2 for Linux, UNIX, and Windows deployments) Yes Yes

Java routine editor and debugger
Yes

SQLJ development
Yes

XML editor, schema editor, and annotated XSD mapping editor
Yes

Data Web Services development and deployment
Yes
General



Shell sharing with other Rational or Optim products
Yes

I usually recommend Data Studio Standalone since it's a smaller download. Data Studio IDE adds several useful features for Java developers.

A good resource for learning either is the free Get Started with Data Studio book.

    0 comments:

    Post a Comment