Re: How to kill ODBC

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

If prompt the ENDHOSTSVR command, you'll see that there's a parameter 
for "End active connections".

midrangel@xxxxxxxxxxxxx wrote:
> 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