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.