To view the full article in its entirety, please visit InfoQ: DB2 Debugging in Visual Studio 2010

IBM is offering a DB2 stored procedure debugger as part of the DB2 Add-ins for Visual Studio 2010. They claim it offers "full end to end debugging for SQL procedures for VB and C# apps”, though you will need hotfix KB2106584 from Microsoft to set break points.

This beta comes with standard ADO.NET providers for DB2 LUW, IDS, DB2 for z/OS and DB2 for IBM i. An Entity Framework provider is also included, with support for database first scenarios and canonical functions.

On the designer-side, you get a server explorer for creating/modifying databases, tables, views, etc. The stored procedure editor includes syntax highlighting. Unfortunately the on-line documentation is quite light.

The installation instructions for the database providers and add-ons show a distinct lack of professionalism. Unlike most vendors, IBM is requiring that their database providers be installed into the Global Assembly Cache. However, they cannot be bothered to offer a simple installer for this. Instead you just get a batch file. This batch file will partially fail unless it is run in a console window launched via the “Visual Studio Command Prompt”. Keep in mind that this is for the “IBM Data Server Provider”, not the add-on itself, which in turn suggests that they expect you to install Visual Studio on your test machines just to run their compiled application. Installing the add-on is another batch file, which doesn’t require the VS command prompt, but this doesn’t include the help files. To install those you must follow these steps...