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:

GroupDetailsData Studio StandaloneData Studio IDE
Architecture data modeling



Database overview diagramsYesYes
Instance management



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

Start, stop, quiesce, unquiesce a DB2 pureScale memberYesYes

Configure a DB2 for Linux, UNIX, and Windows instanceYesYes

Configure a DB2 pureScale memberYesYes
Object management



Create, alter, drop DB2 or IDS server objectsYesYes

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

Impact analysis - report on dependenciesYesYes

Generate DDLYesYes

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

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

Data distribution viewerYesYes
Data management



Export and import tableYesYes

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

Sample contentsYesYes

Load dataYesYes

Unload using Optim High Performance Unload (separate purchase)YesYes

Edit dataYesYes
Application development



Integrated Query Editor (SQL and XQuery) with query formattingYesYes

SQL BuilderYesYes

Advanced query formattingYesYes

Visual ExplainYesYes

Access plan graph (enhanced Visual Explain)YesYes

Single query statistics advisorYesYes

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

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

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.

    No comments:

    Post a Comment

    Note: Only a member of this blog may post a comment.

    Google Analytics Alternative