In the eternal fight among the databases rulers like Oracle, IBM and Microsoft the GUI are getting better and better as time goes by. Now we have the brand new IBM Data Studio that comes with several utilities.
Data Studio provides DBAs, Developers and Consultants to administer and develop anything through a visual and intuitive interface connected to DB2 and/or Informix.
Below are some of the features I got from IBM website:
- Create, alter, and drop objects, manage privileges, view data distributions
, and update statistics on those objects. - Invoke enhanced administration support for DB2 on Linux, UNIX, and Windows including commands, utilities, and configuration support for pureScale databases.
- Simplify query building and editing, including support for XQuery.
- Speed data development with wizards and editors to create, test, debug, and deploy routines, such as stored procedures and user-defined functions.
- Create Web services that easily expose database operations (SQL SELECT and DML statements, XQuery expressions, or calls to stored procedures) to client applications.
- Install either a small, self-contained administration tool or a fully extensible platform for database development, administration, and tuning. For more information about these two downloadable packages
As you can with several tools, Data Studio requires a good machine to run on and also consumes a large space in the HD.
With so many features a free eBook comes on a perfect time. To download the eBook simple click here. And to download Data Studio and DB2 Express-C click here.
