DB2 Version 10.1 for Linux, UNIX, and Windows

IBM Data Studio routine development support

IBM® Data Studio provides an easy-to-use development environment for creating, building, debugging, testing, and deploying stored procedures.

IBM Data Studio provides graphical tools which simplify the process of creating routines by allowing you to focus on the stored procedure logic rather than the details of generating the basic CREATE statement, building, and installing stored procedures on a DB2® database server. Additionally, you can develop stored procedures on one operating system and build them on other server operating systems.

IBM Data Studio is a graphical application that supports rapid development. You can use it to perform the following tasks:

Create new stored procedures.
Build stored procedures on local and remote DB2 database servers.
Modify and rebuild existing stored procedures.
Test and debug the execution of installed stored procedures. (Note: to utilize the debugging facilities offered by IBM Data Studio, the debugging user must be a member of the SYSDEBUG role).

IBM Data Studio allows you to manage your work in projects. Each IBM Data Studio project saves your connections to specific databases, such as DB2 for z/OS® servers. In addition, you can create filters to display subsets of the stored procedures on each database. When opening a new or existing IBM Data Studio project, you can filter stored procedures so that you view them based on their name, schema, language, or collection ID (for DB2 for z/OS servers).

For more information about IBM Data Studio, visit the IDM information center: http://publib.boulder.ibm.com/infocenter/idm/v2r2/index.jsp