IBM Database Add-Ins for Visual Studio  

Starting and Using the Debugger Session Manager Manually with DB2 Version 8 Servers

One approach for debugging SQL procedures in C# and Visual Basic applications against a DB2 Version 8 server, is to start and use the debugger session manager manually.

Two files are installed in the \bin directory that is under the directory where you installed the IBM® Database Add-Ins for Visual Studio:

db2dbgm.jar
The Java JAR file that contains the session manager code.
db2dbgm.bat
A command line batch file that specifies the full command line for running the debugger session manager. This file simplifies the launch of the debugger session manager.

Prerequisite:  To use the debugger session manager, you must have JVM Version 1.4, or later, installed on your workstation, and it must be specified in the PATH environment variable.

Normally, the debugger session manager terminates after being inactive for a timeout period of 50 minutes. You can change the timeout period by editing the db2dbgm.bat file.

To start and run the debugger session manager manually:

  1. Locate the \bin directory that is under the directory where you installed the IBM Database Add-Ins for Visual Studio.
  2. Optional: Edit the db2dbgm.bat file to change the timeout period.
  3. Double-click the db2dbgm.bat file. A new command window opens.
  4. Leave the command window open for as long as you want to debug by using the local debugger session manager.

    You can minimize the command window, but do not close it as long as you are debugging.

  5. Enable IBM SQL debugging in the project that contains the application.
  6. Debug the SQL procedures in the CLR application.
  7. When are finished debugging the application and are finished using the debugger session manager, close the command window to close the debugger session manager.

See Also

Debugging CLR Applications against DB2 Version 8 Servers


.NET Development Forum   DB2 FAQs

© Copyright IBM Corporation 2002, 2019. All Rights Reserved.