And check for any locking issues (Glance would show impeded processes
but you can also use some LISTF options to discover if processes are all
queing up to access a file). 

We've set our ODBC driver so that it never updates or FLOCKs any files.
(This breaks the ACID rules for a database,  but is sufficient for our
needs). 

This is no different to accessing SQL server databases - get your
locking strategy wrong and it bites back when you start to scale up to
more users.  

You may also have to check whether your ODBC driver is configured to a
maximum number of sessions and/or whether sessions are automaticaly
disconncected if idle.  

No idea on the detail - again glance might be able to tell you then
number of processes running under a particular job (or listf could tell
you then number of accessors of a particular program file). 

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of J Dolliver
Sent: 20 July 2007 12:34
To: [log in to unmask]
Subject: Re: [HP3000-L] odbc drivers

What queue are the ODBC jobs running in? You may want to have them run
in a faster queue than the DQ.
A special E queue with settings between 175 and 220

TUNE EQ=175,220

make sure you have your Queue settings in SYSSTART as well as the JOBPRI
0

HTH
Joe

-------------- Original message from john pitman <[log in to unmask]>:
-------------- 


> We are now using odbc connections a lot more than in the past, and now

> we find that the connections seem to hang, go unresponsive, refuse new

> connections, and we have to abort the listener job and restart it.
> 
> 
> 
> Does anybody have any pearls of wisdom in this area they could share ,

> which might shed some light on this please? Currently using the std 
> code supplied with 7.5 - are there better alternatives to this?
> 
> 
> 
> thanks,
> 
> John
> 
> 
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

The contents of this email are confidential to the intended recipient and may not be disclosed. Although it is believed that this email and any attachments are virus free, it is the responsibility of the recipient to confirm this.

Details of Smith & Williamson group companies and Nexia Smith & Williamson Audit Limited and their regulators (where applicable), can be found at this URL

http://www.smith.williamson.co.uk/disclosure

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *