PUG Challenge US 2014 Westford MA The Audit

PUG Challenge US 2014 – Westford, MA The Audit coming Click to edit is Master title style The Audit is coming Presented by: Mike Furgal 1 PUG Challenge EU 2013

Introductions • Mike Furgal – – 2 Progress employee from 1989 -2012 Director of the Database Group at Brave. Point since 2012 Progress Open. Edge Database Expert MFurgal@Brave. Point. com PUG Challenge EU 2013

Introduction - Brave. Point • FACTS • • • The Largest Progress consulting group in the world Founded in 1987 Formerly called United Systems Inc (USI) Sponsor of the Bunker Tests The Managed Database Team has 4 former Progress Employees • Dan Foreman, John Harlow • Purveyor of many Open. Edge related books 3 PUG Challenge EU 2013

I AM NOT… • Not a Licensing Expert • Not the Licensing police • Since Progress is doing License Compliance surveys, it’s good to have a discussion on the subject 4 PUG Challenge EU 2013

A Progress Audit • • • 5 Understand the Progress Audit Process Know what information is needed Be able to make sure you are in compliance PUG Challenge EU 2013

Open. Edge End User License Agreement 7. Audit Rights. Progress may install, enable and utilize automated license tracking, management and/or enforcement solutions with the Products, which Licensee may not disrupt or alter. Licensee shall maintain books and records in connection with this Agreement and the use of the Products and any Updates and/or services provided hereunder. Such books and records shall include at a minimum the number of licenses purchased and being used by Licensee. At its expense and with reasonable written notice to Licensee, Progress or a third party appointed by Progress may audit the books, records, and if necessary, the systems on which the Product or any Update is installed for the sole purpose of ensuring compliance with the terms of this Agreement. Progress shall have the right to conduct follow-up audits as necessary. All audits shall be conducted during regular business hours at Licensee's offices and shall not interfere unreasonably with Licensee's activities. Progress shall treat all such records and books as confidential information. If any audit reveals that Licensee has underpaid license or support fees, Licensee shall be invoiced for all such underpaid fees based on Progress list price in effect at the time the audit is completed. If the underpaid fees are in excess of five percent (5%) of the fees previously paid by Licensee, then Licensee shall also pay Progress’s reasonable costs of conducting the audit and enforcement of this Agreement. 6 PUG Challenge EU 2013

The Fine Print • 7 All audits shall be conducted during regular business hours at Licensee's offices and shall not interfere unreasonably with Licensee's activities. Progress shall treat all such records and books as confidential information. If any audit reveals that Licensee has underpaid license or support fees, Licensee shall be invoiced for all such underpaid fees based on Progress list price in effect at the time the audit is completed. If the underpaid fees are in excess of five percent (5%) of the fees previously paid by Licensee, then Licensee shall also pay Progress’s reasonable costs of conducting the audit and enforcement of this Agreement. PUG Challenge EU 2013

The Chosen One • License Reviews are announced via email either to direct end users or to application partners. • When they are announce to an Application Partner, Progress usually provide a random selection of end user they wish to review • Customers are randomly chosen for the review process 8 PUG Challenge EU 2013

The Exceptional One • On occasion, customers do approach Progress on their own requesting an audit – To make sure they are in license compliance – To have the audit occur on their schedule 9 PUG Challenge EU 2013

License Models • • 10 Concurrent User License Model Registered Client License Model Named User License Model Access Agent License Model Machine License Model Transaction Agent License Model Open. Edge Add-On License Model PUG Challenge EU 2013

What Is Required For The Audit Process • Progress will send you out a questionnaire • Progress will ask for a bunch of files – – – 11 Database log files Database license files App. Server Broker and Server log files Web. Speed Broker and Server log files Unified Broker Configuration files Progress License files PUG Challenge EU 2013

Questionnaire – Application Partners • Application Partners – What is the application – What products are deployed – What is the architecture • Client/server, App. Server, etc – Do you manage your end users environment 12 PUG Challenge EU 2013

Questionnaire – End Users • End Users Checklist – Server Details • How many Production machines • How many Test machines • How many Disaster Recover machines 13 PUG Challenge EU 2013

For Servers • For each Server machine… • Progress. cfg • For each Database of Server machine… Database. lic o Database. lg o • DLC/properties/ubroker. properties • For each App. Server or Web. Speed broker o 14 Get broker. log and server. log PUG Challenge EU 2013

Disaster Recovery and Development • Disaster Recovery – Provide an overview of the DR environment • Development – If you do development, how many developers to you have 15 PUG Challenge EU 2013

DLC/progress. cfg • This is the license file for the install • Determines what features you are entitled to • Use showcfg or showcfgd to read it Company Name: Mike’s Enterprises Product Name: OE Enterprise RDBMS Installation Date: Tue Dec 20 09: 36 2011 User Limit: 68 Expiration Date: None Serial Number: 004265060 Control Numbers: Z 8 F 8 S - 2 P 8 XN - K 4 CY 8 Version Number: 10. 2 B Machine Class: KB 16 Port Number: 43 PUG Challenge EU 2013

Datababse. lic file • Every hour on the hour a line is written to this file. 06/03/14 16: 00 175 236 257 235 185 208 184 51 53 48 • • • 17 Date 06/03/14 Time 16: 00 Licensed Users 175 Current # connections 236 Max connections 257 Min connections 235 • • • Current Interactive 185 Max interactive 208 Min interactive 184 Current batch 51 Max batch 53 Min batch 48 PUG Challenge EU 2013

Datababse. lic file • Every hour on the hours a line is written to this file. Date Time Lic Con 06/03/14 16: 00 175 236 257 235 185 208 184 51 53 48 • This looks out of compliance – 174 Licensed Users – 236 Concurrent Connection • Open. Edge is typically licensed by named user • Another way to think of it is concurrent keyboards 18 PUG Challenge EU 2013

Database. lg file • Records login and logout events • Much more useful than the. lic file • Holds much more information than just login and logout 19 PUG Challenge EU 2013

Database. lg file [[2013/09/24@20: 33: 39. 836 -0700] P-8454444 [2013/09/24@20: 47: 08. 219 -0700] P-41222572 [2013/09/24@21: 00: 31. 557 -0700] P-16973970 [2013/09/24@21: 00: 46. 986 -0700] P-38469662 [2013/09/24@21: 38: 11. 578 -0700] P-6029756 [2013/09/24@21: 48: 11. 003 -0700] P-23527428 [2013/09/24@21: 51: 38. 534 -0700] P-37552516 [2013/09/24@22: 09. 322 -0700] P-15728766 [2013/09/24@22: 36: 46. 712 -0700] P-23658540 [2013/09/24@22: 44: 34. 558 -0700] P-38469696 [2013/09/24@23: 21: 07. 180 -0700] P-22216714 [2013/09/24@23: 25: 51. 258 -0700] P-31850654 • 20 T-1 T-1 T-1 I ABL 72: (452) Login by jalvarez on /dev/pts/8. I ABL 73: (452) Login by amadriga on /dev/pts/19. I ABL 73: (452) Login by amadriga on /dev/pts/10. I ABL 76: (452) Login by cmang on /dev/pts/14. I ABL 77: (452) Login by hjohn on /dev/pts/18. I ABL 78: (452) Login by lflorent on /dev/pts/15. I ABL 55: (452) Login by lflorent on /dev/pts/10. I ABL 55: (452) Login by lferrer on /dev/pts/14. I ABL 73: (452) Login by skinzel on /dev/pts/10. I ABL 54: (452) Login by amadriga on /dev/pts/12. I ABL 72: (452) Login by scrawfor on /dev/pts/15. How many licenses are being used above? PUG Challenge EU 2013

Database. lg file [[2013/09/24@20: 33: 39. 836 -0700] P-8454444 [2013/09/24@20: 47: 08. 219 -0700] P-41222572 [2013/09/24@21: 00: 31. 557 -0700] P-16973970 [2013/09/24@21: 00: 46. 986 -0700] P-38469662 [2013/09/24@21: 38: 11. 578 -0700] P-6029756 [2013/09/24@21: 48: 11. 003 -0700] P-23527428 [2013/09/24@21: 51: 38. 534 -0700] P-37552516 [2013/09/24@22: 09. 322 -0700] P-15728766 [2013/09/24@22: 36: 46. 712 -0700] P-23658540 [2013/09/24@22: 44: 34. 558 -0700] P-38469696 [2013/09/24@23: 21: 07. 180 -0700] P-22216714 [2013/09/24@23: 25: 51. 258 -0700] P-31850654 • 21 T-1 T-1 T-1 I ABL 72: (452) Login by jalvarez on /dev/pts/8. I ABL 73: (452) Login by amadriga on /dev/pts/19. I ABL 73: (452) Login by amadriga on /dev/pts/10. I ABL 76: (452) Login by cmang on /dev/pts/14. I ABL 77: (452) Login by hjohn on /dev/pts/18. I ABL 78: (452) Login by lflorent on /dev/pts/15. I ABL 55: (452) Login by lflorent on /dev/pts/10. I ABL 55: (452) Login by lferrer on /dev/pts/14. I ABL 73: (452) Login by skinzel on /dev/pts/10. I ABL 54: (452) Login by amadriga on /dev/pts/12. I ABL 72: (452) Login by scrawfor on /dev/pts/15. I count 8 licenses being used by these 12 logins PUG Challenge EU 2013

Database. lg file • Program to parse the database log file – – – – 22 For each Login or Logout Parse the name Store the name in a temp-table If login add 1 to a use count If logout decrement 1 from a use count If use-count = 0 then delete row Keep track of how many rows in the temp-table PUG Challenge EU 2013

Batch User Counts • Batched users, which can be servers, have special cases for counting • If the number of users (keyboards) is larger than the batch connections, then the batch connections are ignored • If the batch connections are more that the keyboard users, then only the batch connections are counted 23 PUG Challenge EU 2013

Batch Examples • • Scenario 1 50 concurrent users 25 batch connections 75 Total concurrent connections • • Scenario 2 50 batch connections 45 concurrent users 95 total concurrent connections • 50 user is more than batches • 50 batch connections is more than 45 concurrent users – The users are dedupped as 20 Unique users – 20 is the count 24 – 50 is the count PUG Challenge EU 2013

$DLC/properties/ubroker. properties [UBroker. AS. qadfin_ASprod] appservice. Name. List=qadfin_ASprod broker. Log. File=/apps_sh/prod/qdt/logs/qadfin_ASprod. broker. log controlling. Name. Server=NS 1 description=Financials App. Server environment=qadfin_ASprod initial. Srvr. Instance=3 max. Srvr. Instance=40 min. Srvr. Instance=1 operating. Mode=Stateless • • 25 Each Instance is a license If you don’t need them all, set this lower PUG Challenge EU 2013

App. Server and Web. Speed Broker Logs • Used to count how many Server Processes have been started – This is recorded in the database log – These logs are used as a redundancy check 26 PUG Challenge EU 2013

Disaster Recovery • If a database is ever restored for Disaster Recovery Purposes…. – A disaster Recovery License is required – Even if it’s on the same machine as production • The Disaster Recovery license is a percentage of the production license cost • Open. Edge Replication includes a Disaster Recovery license. 27 PUG Challenge EU 2013

Miscellaneous • An Application that has a connection to more than 1 database is still counted as 1 license – This is considered a “bolt on” to the application • Examples – QAD has many databases • Prod, hlp, admin, custom – The Qxtend bolt-on has additional databases • Qxo and qxe – Named connections to all these databases are counted as 1 license 28 PUG Challenge EU 2013

Summary • Progress is performing License Audits • This presentation uncovered the process • You can’t prevent an audit from happening, but you can be prepared and confident that if you get audited, no harm will come from it 29 PUG Challenge EU 2013

Questions THANK YOU FOR YOUR TIME 30 PUG Challenge EU 2013

Thank You! Questions? 31 PUG Challenge EU 2013