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:
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.
| Group | Details | Data Studio Standalone | Data Studio IDE |
|---|---|---|---|
| Architecture data modeling | |||
| Database overview diagrams |  |
|
|
| Instance management | |||
| Start, stop, quiesce, unquiesce a DB2 for Linux, UNIX, and Windows instance | |
|
|
| Start, stop, quiesce, unquiesce a DB2 pureScale member | |
|
|
| Configure a DB2 for Linux, UNIX, and Windows instance | |
|
|
| Configure a DB2 pureScale member | |
|
|
| Object management | |||
| Create, alter, drop DB2 or IDS server objects | |
|
|
| View and edit privileges for DB2 and IDS data server objects and authorization IDS | |
|
|
| Impact analysis - report on dependencies | |
|
|
| Generate DDL | |
|
|
| Generate commands for DB2 for Linux, UNIX, and Windows - start, stop, quiesce, etc. | |
|
|
| Generate utilities for DB2 for Linux, UNIX, and Windows - backup restore, reorg, etc | |
|
|
| Data distribution viewer | |
|
|
| Data management | |||
| Export and import table | |
|
|
| Extract data, extract as XML (from SQL results) | |
|
|
| Sample contents | |
|
|
| Load data | |
|
|
| Unload using Optim High Performance Unload (separate purchase) | |
|
|
| Edit data | |
|
|
| Application development | |||
| Integrated Query Editor (SQL and XQuery) with query formatting | |
|
|
| SQL Builder | |
|
|
| Advanced query formatting | |
|
|
| Visual Explain | |
|
|
| Access plan graph (enhanced Visual Explain) | |
|
|
| Single query statistics advisor | |
|
|
| SQL query environment capture for serviceability (z/OS only) | |
|
|
| SQL routine editor and debugger (including PL/SQL for DB2 for Linux, UNIX, and Windows deployments) | |
|
|
| Java routine editor and debugger | |
||
| SQLJ development | |
||
| XML editor, schema editor, and annotated XSD mapping editor | |
||
| Data Web Services development and deployment | |
||
| General | |||
| Shell sharing with other Rational or Optim products | |
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