IBM Data Studio is a Windows software for interacting with IBM databases in various formats like Db2, Informix and Big SQL. There is a web based console for monitoring and managing remote servers as well. It is worth noting that IBM Data Studio is a paid product. There is no free trial version.

Database management

The program provides graphical tools and wizards for creating, altering or dropping individual database objects. Instruments for importing and exporting data are included. Similar to MySQL Administrator, users can run custom SQL statements and scripts.

It is possible to debug stored procedures and functions. There are tools for generating detailed activity reports for troubleshooting purposes. IBM Data Studio is fully compatible with other IBM platforms such as Data Server Manager, InfoSphere Optim and Cognos Analytics.

Advanced functionality

You are able to optimize complex queries and analyze overall database performance. Moreover, flexible workload management options are included. Separate data blocks can be moved and transformed in real time.

Users can configure various security parameters and specify account permissions. This is helpful for managing databases with shared access.

Features

requires a license to download and use;
offers you an integrated development environment for manipulating IBM databases;
it is possible to execute SQL statements and analyze the results;
users can debug stored procedures;
compatible with all modern versions of Windows.