http://archive.midrange.com/midrange-l/200904/msg00299.html
Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com
-----Original Message-----
Subject: How to kill ODBC
We though we were ending ODBC at night but it appears that the QZDASOINIT
jobs continue to stay active for any pre-existing ODBC connections.
Here's how we try to stop ODBC:
ENDHOSTSVR SERVER(*DATABASE *FILE)
New connections are refused.
When ODBC is started back up the existing connections are deemed alive and
well.
Here's how we start ODBC:
STRHOSTSVR SERVER(*DATABASE *FILE)
How can we kill the existing sessions as we need to obtain exclusive locks
on some files for night processing.
Jerry
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
