DB2 ODBC connection Tracelevel
Posted on 2006-05-11
I am really not familiar with UDB, but recently am having issue with client application written in VB that will connect to UDB database.... So need somebody's help!
Actually that VB app will just through SQL to UDB dataserver to retrieve data (just select statement) and then write that into flat text file.
Normally this task finish quickly like in few seconds, but once a two-three weeks, suddenly ODBC timeout happens and it fails.
At that time, if I try to use different PC, no issues can be seen.... Also no special errors are available on dataserver side it seems...
Assuming this is PC side whatever the issue, but cannot point out what is exactly wrong. So tried to turn on trace option in ODBC property dialog on Client XP PC and tried to see errors in that, but seems that, it is not writing anything into log even if there is some event (such as logon to dataserver, execute select statement etc...)..
So assuming there will be some options to generate ODBC logs more or having something odbctrace.dll thing that can be used for this kind of debugging...
If somebody have good tool/way of debugging for this case, would you please let me know?