• 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.