RE: How to temporarily end and stop ODBC connections ?

From Client Access on the PC and using the Java Toolkit (both over TCP/IP)
you are connecting to the DDM servers if you are doing record level access
(ie OLEDB).  Otherwise you are connecting to the *DATABASE Host Server.
Don't just kill QSERVER since the *FILE and NetServer stuff runs there also.
You need to end the *DATABASE host server, End the *DDM servers to prevent
new connections.  Then you will need to end all the QZDASOINIT & QZDASSINIT
jobs in QSERVER that are not in a PSRW status to end existing connections.
You can also use NETSTAT *CNN and end all connection with a local port of
as-database.

> -----Original Message-----
> From: Chris Bipes [SMTP:chris.bipes@cross-check.com]
> Sent: Sunday, July 08, 2001 9:59 PM
> To:   'MIDRANGE-L@midrange.com'
> Cc:   'kgoins@aracnet.com'
> Subject:      RE: How to temporarily end and stop ODBC connections ?
> 
> Well the OBDC server and the DDM server both fall under the DDM server.
> So
> you can ENDTCPSVR *DDM to block access to OBDC, that is if they are
> connection via TCP/IP.  If I am wrong, it would then fall under host
> servers
> and probably the data base server.  Any how it is the DRDA server
> listening
> at port 446.  I really do believe it is controlled by the DDM TCP/IP
> server.
> 
> HTH
> 
> Christopher K. Bipes  mailto:ChrisB@Cross-Check.com
> Operation & Network Mgr       mailto:Chris_Bipes@Yahoo.com
> CrossCheck, Inc.      http://www.cross-check.com
> 6119 State Farm Drive Phone: 707 586-0551 x 1102
> Rohnert Park CA  94928        Fax: 707 586-1884
> 
> 
> 
> -----Original Message-----
> From: Kirk Goins [mailto:kgoins@aracnet.com]
> Sent: Sunday, July 08, 2001 6:56 PM
> To: MidrangeList
> Subject: How to temporarly end and stop ODBC connections ?
> 
> 
> I have client that now has a number of PC's running an automated data
> collection
> process and updating the 400 via ODBC. We need to block access for an a
> short
> period of time once each day. The old way they used was via an APPC
> conenction
> and they would just end the job and vary off the devices.
> 
> I'm thinking
> 1. Disable the usrprf being used but that won't running processes.
> 2. Ending QSERVER sbs since ODBC is the only thing currently using it.
> 3. ??
> 
> Any other ideas?
> 
> Thanks
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---