| Author |
Message
|
| lvraa |
 Posted: Fri Jun 04, 2004 12:58 am Post subject: Debugging message flow that access a databse |
 |
|
Novice
Joined: 18 May 2004
Posts: 12
Location: Denmark
|
I am trying to debug a message flow in WBIMB 5.0 that access a DB2 database (actually the Broker DB). For some reason the debugging is halting when the "SELECT ... FROM Database...." statement is executed and control is lost. The flow is running perfectly without debugging.
Does anyone know if WBIMB debugging is limited in relation to database access? Or know if there is a solution for my problem?
_________________
Kind regards
Lars Vraa
lavr@lundbeck.com |
|
| Back to top |
|
 |
| JT |
| Posted: Fri Jun 04, 2004 4:27 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
Lars,
Activating the odbc trace provides details of database activity Set the following parameter in the .odbc.ini file:
Solaris example:
| Quote: |
[ODBC]
Trace=1
TraceFile=/var/wmqi/odbc/odbctrace.out
TraceDll=/usr/opt/wmqi/merant/lib/odbctrac.so
InstallDir=/usr/opt/wmqi/merant |
Review the odbctrace.out file for details. |
|
| Back to top |
|
|
| lvraa |
| Posted: Fri Jun 04, 2004 4:35 am Post subject: |
|
|
Novice
Joined: 18 May 2004
Posts: 12
Location: Denmark
|
My Broker is running on WIN2K. Does anyone now how to configure this on Windows and if its the reason why the debugger is halting?
_________________
Kind regards
Lars Vraa
lavr@lundbeck.com |
|
| Back to top |
|
|
| JT |
| Posted: Fri Jun 04, 2004 5:23 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
On the Windows platform:
| Quote: |
Use the Tracing tab of the ODBC function, as follows:
Click Start > Settings > Control Panel > Administrative Tools.
Double-click Data Sources.
Select the Tracing tab.
Click the Start Tracing Now button.
Click OK.
To stop ODBC tracing, go to the same panel and click the Stop Tracing Now button, then click OK. |
|
|
| Back to top |
|
|
| lvraa |
| Posted: Fri Jun 04, 2004 8:53 am Post subject: |
|
|
Novice
Joined: 18 May 2004
Posts: 12
Location: Denmark
|
Hi JT
Thanks for your reply. Turning ODBC tracing on as you describe does not help. Debugging still freezes when executing ESQL that access a database. Did turning ODBC tracing on help your debugging?
_________________
Kind regards
Lars Vraa
lavr@lundbeck.com |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Sat Jun 05, 2004 7:05 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What CSD level of WBIMB are you running? What version of IBM Agent Controller?
Maybe if you upgrade both of these to the most recent levels, you won't have this problem.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
