Re: How to temporarly end and stop ODBC connections ?

[thomas@xxxxxxxxxxx]

Kirk:

Although it's probably best to work with the actual pre-start and other jobs 
for various servers rather than bluntly ending the subsystem, you might be able 
to get by with something like the following.

At the time you want to block the service, run these two commands:

 ===>  endhostsvr server(*database *file)
 ===>  endsbs qserver

Then when you want to open it back up:

 ===>  strsbs qserver
 ===>  strhostsvr server(*database *file)

The two sets of commands would likely be in two CL programs (or in a single 
program that accepts a parm value either to start or to stop the services). Use 
the job scheduler to run the CL. You might want/need to fine tune the command 
parms for example for example to choose option(*immed/*cntrld) or to include 
other code to verify that the servers were ended, that the subsystem ended, 
that errors were handled, etc.; but the basics are there.

Or you could have much finer control by using exit programs. This is also much 
more complex, but could conceivably block all accesses except from specific 
locations or users such as database administrators or others who could be 
allowed access at all times for possible emergencies.

Tom Liotta

On Sun, 08 July 2001, Kirk Goins wrote:

> 
> 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?

-- 

___________________________________________________
The ALL NEW CS2000 from CompuServe
 Better!  Faster! More Powerful!
 250 FREE hours! Sign-on Now!
 http://www.compuserve.com/trycsrv/cs2000/webmail/




+---
| 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
+---