RE: Question about Informix OnLine Licencing

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.