Question Concurrent Appserver Connection

rzr

Member
We are working on renewing licensing with Progress. Is there a way to know how many concurrent AppServer connection are being made for a given appserver (from VST or log files)?
 

TheMadDBA

Active Member
Did they switch the licensing model for AppServer again? Isn't it agent (not user) based?

This command will give you some of the info you asked for... just not sure you need it.

asbman -name <appservername> -query
 

Etienne Begin

New Member
Your number of concurrent appserver connections may change, depending on the ubroker.properties file.

Progress should give you proper methods to determine licensing requirements, and you should not have to guess what they need. The licensing agreements vary from client to client and its a burden Progress must carry.
 

RealHeavyDude

Well-Known Member
Plus, to complicate matters, Progress allowed customers to keep the concurrent user licensing model when migrating from V9 to OE10 and then to OE11 ( like us ). It is just lately that we were "forced" to switch to a named user license model to get to an agreement with Progress.

IMHO it is a PITA that Progress insists on audits whether customers are compliant with the license model providing no solution for the customer to prove that they are. Suspicious minds could be inclined to think that this might be on purpose ...

Heavy Regards, RealHeavyDude.
 

TomBascom

Curmudgeon
Progress is aggressively auditing customers. This isn't just a Progress thing -- Microsoft, Oracle, IBM and so on have been doing it forever.

It is a very good idea to self-audit your licenses at least annually. You do not want to be surprised when the audit team comes calling. The penalties for being out of compliance are quite painful.

If you need help figuring out your licenses we have been doing quite a few engagements with customers on this stuff -- the best time is *before* you get the letter from the audit team. But even if you already have the letter we can help a *lot*. The engagement more than pays for itself.
 

LarryD

Active Member
We are in the process of having 10 of our customers audited. I can only echo the caveats here regarding licenses. Progress's view of a "user" and what I would consider a user are two different things.

I will say that during our first review they (Progress) admitted that the EULA is purposely vague, so be aware. YMMV
 

rzr

Member
there is audit coming (I think) ...

So, what I found so far is you can get from the database-name.lic file the number of active "interactive" connections. Going to write a quick code to see what the average interactive count is are for a given day and then figure out if our default min and max are setup correctly. I'm not a DBA so do not off hand if there's an easier way to get this information. I did look at asbman query option but it did not have this info.

Progress KB - What is the database license file?

Example: databasename.lic

06/24/04 19:00:00 64 1 2 1 0 1 0 1 1 1
06/24/04 20:00:00 64 1 1 1 0 0 0 1 1 1
06/24/04 21:00:00 64 3 3 0 2 2 0 1 1 0
06/24/04 22:00:00 64 8 9 3 7 8 2 1 1 1


Here's what the columns denote:

1. Current date
2. Current time
3. Number of licensed users specified by the configuration file (if -1 shows, it means that an unlimited number of users are licensed)
4. Current number of total connections
5. Maximum number of total connections
6. Minimum number of total connections
7. Current number of interactive connections
8. Maximum number of interactive connections for the last hour
9. Minimum number of interactive connections for the past hour

10. Current number of batch connections
11. Maximum number of batch connections for the past hour
12. Minimum number of batch connections for the past hour
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
I'm not a DBA so do not off hand if there's an easier way to get this information.
This info comes from the _License VST but it only contains one record, for the current sample. So there is no way to get the historic data, which is available in dbname.lic, from the database.
 

tamhas

ProgressTalk.com Sponsor
Note that the .lic file is connections, which may or may not correspond to users in your license. If you have a concurrent user license, then the big question is whether your users create multiple simultaneous sessions from the same device. If they create 3 sessions, that is 3 connections in .lic, but only one user.
 
Top