Uda Wiki Web

  • Topic
  • Discussion
  • doc.FAQ.MyDriversOccasionallyFailToDisconnectWhatDoIDo





      • Use your database native transaction monitor to see if OpenLink drivers are locked in pending transactions. OpenLink drivers cannot disconnect from a database while they are still engaged in transactions.
      • Ensure that your application does not enforce manual commits. Use of manual commit may encourage the behavior described above.
      • Check the database native error logs for failures that may contribute to this problem.
      • Create a client-side ODBC trace. Examine the trace to ensure that the application sends the proper sequence of SQLFree()s and SQLDisconnect()s to the driver.
      • Ensure OpenLink 's Progress drivers connect to Progress databases in sockets mode. A Progress shared memory library bug causes failure to disconnect.
      • Contact OpenLink Product Support, if you use Progress 91C or 91D. OpenLink is working to resolve occurrences of lingering agents that are not associated with the shared memory bug.
      • Recreate the problem.
      • Run oplshut -s on a command line.
      • Observe the number of OpenLink database agent processes.
      • Compare the output of oplshut -s with a Unix ps -ef or Windows Task Manager.
      • Upgrade if oplshut -s or the Windows Task Manager shows more agent processes.