Re: Question about Informix OnLine Licencing

We went through this a few months back with Informix. It true, that they do not have a "governor" in the engine controlling the number of concurrent connections. It's all on the honor system! However, when you involve Web or Middleware, I think it gets more confusing. Like Art said, it does make negotiations interesting! To count your connections, you can do an "onstat -g ath | grep sqlexec" to get the current connections. We actually put this is a cron job and let it run for a week to get an accurate idea of connections. Steve Romankiw Simpson, Don wrote: > Art S. Kagel wrote: > > >Andrzej Piotrowski wrote: > >> > >> Does anybody know, how it works? Does Informix OnLine consume one licence > or > >> two licences when I,m trying to establish 2 connections using the same > >> account from 2 different clients? Sorry, if this question is obvious, but > I > >> don't know to much obout Informix OnLine. > > >Physically Informix does not count license accesses so it does not > >matter to the server, you cannot run out of licenses at runtime. > > >Last time I spoke to Informix on the subject, legally, their license > >agreement counts multiple connections by the same user on the same > >client as one concurrent connection for license purposes so you would > >be counted as two connections in your scenario. BTW this caused > >Informix no end of grief licensing us since we have thousands of users > >but the client programs NEVER connect to the database only our own > >middleware-like data servers which all run as the same user on the > >server box itself, so ONLY ONE user! Fun negotiations, anyway enjoy. > > Art, aren't you concerned about what user is actually hitting the database? > Say some user is doing something on the client application and for whatever > reason it causes your middleware to send some intense query to the server. > How would you be able to identify who is doing it? I guess you don't do > much with grants or roles then either. How do you handle table security? > > There's been talk here at my site about doing something like this but as the > DBA I'm strongly against the idea. I want to see the 'real' user hitting my > databases. And I'm surprised Informix ok'd such a scheme. My understanding > is that all lines in your onstat -u output count as a user connection, > regardless to how many may be the same user. If I'm understanding it wrong > I sure would like to know because I'm paying a butt load for support. > > Don.