Setting the Routine debugger preferences

The Routine debugger preference page allows you to set preferences for routine run times, variable character limits, error tracing, and the debug session manager.

About this task

Selecting Window > Preferences from the workbench menu bar opens the Preferences dialog box. Routine debug settings specified in this dialog box do not take effect until the start of the next session.

In the dialog box, choose Run/Debug > Routine Debugger to select the preferences for debugging. Select the database server for the routines you are debugging. For example, select IBM.

The following table shows preferences that you can set for debugging routine. Depending on the database server you are using, some preferences might not apply.

Routine debugger preferences - IBM® page
Number of seconds of inactivity before the routine runs to completion
If you stop debugging an SQL routine for the length of time specified in this field, the debug session will terminate and the routine will run to completion. The minimum value of this setting is 30 seconds and the maximum value is 1800 seconds. The default value of this setting is 300 seconds.
Number of characters per line in Variables View Details Pane
This controls the position at which characters will wrap in the Details Pane in the Variables view. Each line of the Details Pane will have the number of characters specified and then wrap to the next line. The default value of this setting is 72 characters.
Diagnostic error trace level on database server
This determines the level of error tracing on the database server. Valid entries in this field are:
  • 0 - Indicates that no tracing will occur. This is the default value.
  • 2 - Indicates that all trace messages will be logged.
IBM Routine Debug Session Manager Location
The session manager connects the debugger user interface to the IBM server and must be running before the debug session can start. In this preference section, you can choose to use a session manager on the server the routine is being run on or use an existing session manager.
Use the built-in session manager
Select this option to use the session manager that is included with the product. If the port manager is not available on the database server, the built-in session manager will act as the port manager.
Run the session manager on each connected server
Select this option to use the session manager on the server that the routine is being debugged on. If the session manager is not currently running on the server, it will be started automatically when you start debugging. The Session manager timeout in minutes field specifies how long a newly created session manager will sit idle after completing a debug session before stopping automatically.
Use already running session manager
Select this option to use an existing session manager. In the Host field, enter the host name or IP address of the machine that the session manager is running on. In the Port field, enter the port that the session manager is running on.

A standalone session manager can be used when the DB2® server that you are debugging does not have a session manager available.

To start a standalone session manager, run the db2dbgm batch file under the install directory for this product (there are two different batch files: db2dbgm.bat is for Windows and db2dbgm is for Linux). You can modify the batch file to specify a different port value if the default value is not available.

You must start the standalone session manager before you try to use it with this product.

Routine debugger preferences - Oracle PL/SQL page
Number of characters per line in the Variables View Details Pane
This setting controls the position at which characters will wrap in the Details Pane in the Variables view. Each line of the Details Pane will have the number of characters specified and then wrap to the next line. The default value of this setting is 72 characters.

Feedback