IDERA SQL Debugger for Linux, Unix, and Windows Setup

From DBArtisan
Jump to: navigation, search

Go Up to Setting up the IDERA SQL Debugger

IDERA SQL Debugger for IBM DB2 for Linux, Unix, and Windows requires proper configuration of the server and client.

For more information, see:

Prerequisites for Adding and Compiling Stored Procedures

The IDERA SQL Debugger for IBM DB2 for Linux, Unix, and Windows requires the following products and components.

Client

  • IBM DB2 for Linux, Unix, and Windows
  • DB2 Application Development Client
  • DB2 Administration Client
  • Communications Protocols
  • Stored Procedure Builder
  • Applications Development Interfaces
  • System Bind Files
  • DB2 Connect Server Support
  • Documentation
  • Base DB2 for Windows/Unix Support
  • Administration and Configuration Tools

Server

  • IBM DB2 for Linux, Unix, and Windows
  • DB2 Enterprise Edition
  • Communications Protocols
  • Stored Procedure Builder
  • Applications Development Interfaces
  • System Bind Files
  • DB2 Connect Server Support
  • Documentation
  • Base DB2 for Windows/Unix Support
  • Administration and Configuration Tools
  • Microsoft Visual Studio, Visual C++
Note: The server must have a local directory structure and file C:\program files\sqllib\function\routine\sr_cpath.bat. This file is installed with IBM DB2 and includes the C compiler options needed to compile the procedure on the server. If it is not found, install the IBM DB2 Administration and Configuration Tools option on the server.

Configuring the IBM DB2 for Linux, Unix, and Windows Server for Procedures

You can create procedures on the targeted server.

To create or run any procedure, set up the configuration environment and enable the C compiler options on the server.

To configure your server, do the following:

  1. Open a DB2 Command Window, and then type:
DB2set DB2_SQLROUTINE_COMPILER_PATH="C:\program files\sqllib\function\routine\sr_cpath.bat"
DB2 sets the DB2_SQLROUTINE_COMPILER_PATH DB2 registry variable to call the required initialization script for the C compiler on the server.

To enable the C compiler options on your server:

  1. Open the file C:\program files\sqllib\function\routine\sr_cpath.bat.
  2. Remove the REM (remarks) prefix on the lines that match the version of Visual Studio that is installed on the server. VCV6 = version 6.0 and VCV5 = version 5.0.
    Note: Only remove the REM prefix on the lines that apply to your installation of Visual Studio
  3. Restart the DB2 services on the server.

Prerequisites for Debugging Procedures

To enable debugging on the server, do the following:

  1. Open a DB2 Command window and type:
Db2set DB2ROUTINE_DEBUG=ON
Note: Availability of this feature depends on your licensing.

Topics

Retrieved from "https://docwiki.embarcadero.com/DBArtisan/180/e/index.php?title=IDERA_SQL_Debugger_for_Linux,_Unix,_and_Windows_Setup&oldid=6245"