The licensing for the PSQL database engine can get VERY confusing for certain configurations, so we have put together this description of how Actian licenses their product.
The Tools You Need
Please read this information carefully! Actian does NOT allow product returns on their software once it is delivered! If you order the wrong product, you may need to order the correct version and have no recourse for returns. Goldstar Software is the premier reseller in the United States, but we must still work within the rules provided by Actian. If you want to see the end user license agreement before purchase, you can find the license documents here. With the exception of the MultiHost Licenses, each PSQL engine license purchased may be used on ONE computer only, so if you have two computers hosting database files, you'll need two licenses.
If you have multiple users sharing access to the same set of database files, then you would purchase one license to go on the computer with the data with a proper user count or size for your environment. In the PSQL engine license model, a "user" is considered a unique network address that is accessing the database engine. The number of users is limited by the engine type and license purchased. For example, if I have applications running on 3 workstations and accessing the same database engine on a remote server, I need a minimum of 3 user licenses.
If I have applications running on 8 workstations AND a service running on the database server that is also accessing the database, then I need a minimum of 9 user licenses.
Note that Terminal Services and Citrix sessions are counted as separate users. So, If I have one Terminal Server which is hosting 18 concurrent user logon sessions, each running a database application, then I must have a minimum of 18 user licenses. The user count is concurrent -- this means that I can have 50 workstations installed and configured in my environment, but if I have only 20 that will access the database applications at the same time, then I only need 20 user licenses.
Any users attempting to access the database above the licensed maximium will get a Status Too Many Users error code. It is up to the application to trap and report that error properly. Your first goal in selecting the right PSQL license for your environment is to determine which engine type you need. Let's look at these three differences briefly here:.
The Workgroup Engine is designed for stand-alone machines, machines accessing local database files like in a POS systemand for small networks of less than 5 concurrent users. You can NOT build a multi-user Workgroup system for more than 5 users at the same time! If you think you will expand to more than 5 users at some point, we recommend purchasing one of the other two license types instead. The Server Engine is designed for larger, multi-user environments of 6 concurrent users or more.
It offers a number of additional features over the Workgroup Engine that pertain mainly to performance and scalability, including:. The differences in the licensing models are shown here:. It is possible to run the bit Windows Workgroup engine on a bit operating system -- it will just run in bit mode with all the capabilities and limitations that mode offers. The Workgroup Engine, as previously stated, supports a maximum of 5 concurrent users.
It should be licensed for the number of concurrent workstations that will be accessing the database engine simultaneously. The current "base" licenses available are 1U, 3U, and 5U. Note that you cannot get over 5 concurrent users -- this is a stated maximum for the WGE. The Server Engine can be licensed for a number of users starting at 6U and going up from there. However, you can have only ONE base license installed on a server at a time.
However, economies of scale will kick in due to the reduced pricing of the Server Engine for the larger user counts, so this seldom makes sense. In many cases, it may be cheaper to simply over-size the license to the next user count and avoid using UCI's, which can save you money on future upgrades as well. As such, we recommend checking all of your options carefully to identify the price points of every eligible configuration before purchasing. This can be done via a Size Upgrade moving from one size to a larger size or via a Data Size Increase.
Size Upgrades are usually the better deal, because this makes you eligible for a upgrade pricing on a future version at the larger size.
However, the 10GB Data Size Increases available in permanent or day temporary keys may be a more cost effective way to add data size to your engine license.Did you know you can now get notified on all new releases and patches for Actian products just go to our new Broadcast Groups and join now! Follow Us:. Login Register Portal. The Tools You Need Seamlessly manage and connect your operational and analytic data for superior performance, insights, and business outcomes.
Electronic Software Distribution. Show only items I can download. Actian Zen database family is the most reliable, small-footprint, low-maintenance, high-performance database management system DBMS in the world, purpose-built for Edge data management — whether in the Cloud, remote and branch offices or in Mobile and IoT settings.
The latest release is Zen v14 Service Pack 1 If you have already purchased Zen v13, download the latest release v If you need an older Zen v13 release, download Service Pack 2 v Btrieve 2 Release Btrieve 2.
ActiveX Release ActiveX. Btrieve Release Btrieve. Subscribe Did you know you can now get notified on all new releases and patches for Actian products just go to our new Broadcast Groups and join now!Quickly and easily load diverse data sets from hundreds of on-premise and SaaS applications into Actian Avalanche Hybrid Cloud Data Warehouse for comprehensive insights delivered at the speed of business.
Kiabi sales and marketing teams can make data-driven decisions based on both real-time and historical analytics. Actian Avalanche enabled Kiabi to analyze terabytes of sales data from more than 20 million customers, with query response times as much as x faster than on the old Oracle database.
Actian Avalanche queries over million records and scales to terabyte datasets to power the analytics for more than 20 million Kiabi customers.
License Problems with Pervasive PSQL, Actian PSQL, or Actian Zen
A single data management platform to provide for the needs of the most demanding analytics use cases and mission-critical applications, from the Edge, to on-premises, to the Cloud. Actian Avalanche delivers unparalleled analytics performance for the data-driven enterprise, no matter where their data resides.
Actian DataConnect is a versatile hybrid integration solution that empowers anyone to integrate anything, anywhere, anytime. Actian Zen offers developers a single database platform that covers all your Edge data management requirements. Equian cuts claim settlement times in half with Actian. If you are thinking about modernizing your legacy data warehouse, you may be looking at cloud data warehouses as a logical next step.
Read this report by Early Adopter Research to understand why not all cloud data warehouses are created equal.
Data warehouse modernization. Sounds like a no-brainer. Move your Netezza, Terada or Exadata warehouse that likely runs on obsolete, proprietary hardware to a shiny new system that runs in the cloud. But is it that easy? Support Developers Downloads Careers. Analyze petabytes of data with the fastest analytics engine. Actian DataConnect.
Quickly and easily connect data and apps, on-premises and in the Cloud. Learn More. Read More. Weekly Avalanche Live Demo From data to insights in 30 min. Thursdays 9am PT. Real-Time Connected Data Warehouse Quickly and easily load diverse data sets from hundreds of on-premise and SaaS applications into Actian Avalanche Hybrid Cloud Data Warehouse for comprehensive insights delivered at the speed of business.
Kiabi gains customer insights with real-time and historical analysis of data Kiabi sales and marketing teams can make data-driven decisions based on both real-time and historical analytics. Read the Customer Story. Empowering the Data-Intensive Enterprise A single data management platform to provide for the needs of the most demanding analytics use cases and mission-critical applications, from the Edge, to on-premises, to the Cloud.
Hybrid Cloud Data Warehouse. Actian Avalanche delivers unparalleled analytics performance for the data-driven enterprise, no matter where their data resides Learn More.
Enterprise Data Integration. Actian DataConnect is a versatile hybrid integration solution that empowers anyone to integrate anything, anywhere, anytime Learn More. Edge Data Management. Actian Zen offers developers a single database platform that covers all your Edge data management requirements Learn More.
Talk to an Expert. Read the Report.PSQL products offer two license models: concurrent user and capacity-based. The concurrent user model counts users, while the capacity-based model measures the data in use. In both models, once a set limit is reached, whether users or data, no additional database activity is allowed.
For the user count model, no new users can access any data. For the data capacity model, no new data access requests are accepted. Once user count or data usage fall below the limit, new activity is allowed. With the concurrent user license model, each product key specifies a licensed user count. A user count allows the specified number of concurrent connections to the PSQL database engine. Users are counted by network address.
Each computer that accesses the PSQL as a client session counts as one user. Multiple applications on a single client computer are counted as one user, not separate users.
Actian Zen/PSQL v13 Licensing Primer
Internally, PSQL assigns each machine a serial number and counts all connections with the same serial number as coming from one machine. A machine with multiple NICs, for example, is recognized as one machine.
Each Terminal Server session also counts as one user. Collectively, all applications that access the database engine using the same network protocol and address and running on the same machine as the engine are counted as one user.
A user is counted for each unique incoming protocol from the same client computer session. If different address formats of the same protocol are used, only one user is counted. For example, if one application uses IPv4 and another uses IPv6, only one user is counted if both applications run on the same machine.
An initial user count is provided as part of the product key. This product key is issued by Actian Corporation or by your application vendor if the PSQL database engine is embedded in an application. You may also increase the user count beyond the initial amount provided by the product key. See Increasing User Count. The capacity model shifts the emphasis from how many users to how much work the database server performs. The model is based on the process capacity of the engine determined by the amount of data in use.
This amount is the total size of data files authorized to be opened concurrently. Data in use is defined as the total size of all concurrently open data files. A data file is a file created by an application to provide the data processed by that application. Data in use limit is the maximum permitted amount of all concurrently open data files as granted by a license agreement.
The value for data in use increases when a data file is first opened.01 License Generation
Subsequent opens to an already open data file do not add to the total. Data in use also increases if an open file increases in size. Operations on an already open file continue to be permitted even if the size of the open file increases beyond the data in use limit. The value for data in use decreases when a data file is closed by the final user to have the file open.
Since more than one user can access the same data file, all opens must be closed before data in use decreases. Messages pertaining to data in use are logged to the various PSQL logging repositories.
See Message Logging. The database engine uses various files for its own internal processes, such as PSQL system files, metadata files, dbnames.Edge applications and devices increasingly rely on AI to improve automation and end-user decision support — whether that be human or machine — in stand-alone, peer-to-peer, local network, cloud or a mixed environment.
The underlying edge data management must be capable of leveraging a variety of hardware architectures, operating environments, networks, communications interfaces, and programming and scripting languages for the applications that make use of these resources.
The Actian Zen Edge Data Management solution delivers against this broad and demanding set of requirements. Avoid ETL between devices, gateways, branch and cloud environments — improve speed, integration cost, remove security vulnerabilities. Tracking attendance and assets using RF-ID technology and embedded database systems on K and higher education campuses. Read the Customer Story.
With Zen you get the simplicity of file system APIs with the robust functionality of a real-time database. Actian Zen is the database infrastructure, supporting extremely high-speed conveyor belt operations in manufacturing and transportation and logistics. AES bit encryption for data at rest plus Zero ETL avoids decryption between point of development and final deployment. Separate replication event handler and replication engine ensure zero impact on operational databases. From chronic disease management in healthcare to digital twinning in manufacturing, the breath and depth of use cases for edge intelligence is seemingly limitless.
The growth of IoT and Mobile and the coming infusion of AI into them is driving the need to harness and exploit the underlying data at the edge rather than simply tossing it or sending it back to the Cloud. With Actian Zen, developers get a simple NoSQL API or alternatively, Actian Zen also offers full SQL with ACID compliance that covers all their standalone embedded application needs at the device or gateway level and publish-subscribe support for s or s of downstream devices or upstream servers in traditional client-server, intranet or Cloud configurations.
And, all this capability can be accessed as CLI or through most popular programming and scripting languages. Actian Zen is based on PSQL and is backward compatible to and each version is supported at least seven years. View Now. Read Now. Support Developers Downloads Careers. Actian Zen Edge Data Management. Single, secure, scalable solution for IoT and mobile data processing and analytics. Explore Features. Learn More. Single architecture — from device to gateway, from server to cloud Multi-model, multi-platform, embedded in most popular languages No-ETL between clients, servers, and cloud.
Multi-model yet unparalleled performance across all data types — see benchmarks. Actian Zen Editions. Actian Zen Core. Actian Zen Edge. Actian Zen Cloud Server. Shared by all Editions.
Add-On Software. Actian DataExchange. Actian Backup Agent. Backup operational Zen and PSQL databases Works with all major 3rd party backup software API for use embeds in your application Maintains data integrity and continuity without service interruptions.Click on the status code in the table to go to the cause and solution. This key cannot be deauthorized because it was authorized on a machine with a different machine signature. It's pretty simple once you find the right place to look.
The Internet connection cannot acces the authorization server to obtain data needed for key validation. Possible causes include, but are not limited to, the following:. Actian Support Committed to your success. Status Code Description Product key is already used on another machine This key cannot be deauthorized because it was authorized on a machine with a different machine signature Product key is already used on this machine An error occurred acquiring the machine configuration User lacks the appropriate rights to authorize or deauthorize a key Internet connection cannot access licensing server.
For the most part, this process is simple and easy. However, experience has shown that there are several ways in which this process can break down:. Most of these problems will result in a Btrieve Status being returned to the application, which is simply a generic "License Exceeded" message.
Troubleshooting this status code can sometimes be difficult, especially if you are unfamiliar with the PSQL tools and utilities. This page should provide everything you need to fix your license problems! If you need help from Actian Corporation to address a licensing issue, here is their contact information:. The first task is to make sure you know which version of PSQL is installed.
Note the database engine Version v10, v11, etc. Once you have the above information, verify your license key. If you do not have server access, you can also do this from a workstation by entering the server name into the box provided and clicking "connect".
You should see an "Active" license indicating the same version, engine type, and platform. Note that newer licenses will indicate "Any" for the platform. This means that your license will work on any bit level. If you do not see the license data on this screen, then it is possible that your license key was never installed.
Apply the license.
If needed, you can find more explicit directions in our white paper on applying a license key. Of course, if you have not yet purchased your license, you should do so now. If you see a license for a different version, engine type, or platform, then it may be possible that the wrong software was installed.
For example, if your license is for a Workgroup Engine and a Server Engine was installed, the system will not function after the day trial. The solution is to remove the wrong software and reinstall the right one, then apply your license key. If needed, you can download the correct engine from Actian's web site. Be sure to check your license and download the software that you have purchased. The simplest solution is to change your hardware back to the original configuration, deactivate your license from the PSQL License Administratorthen change your hardware as needed, and re-apply your license key afterwards.
Be sure to have all of your critical information version, product serial number, license key, etc. Better yet, click on the big red button to the left titled "Fix My PSQL License" and it'll take you right to Actian's web site, with a list of everything that they would ask you for.
The License Administrator can return a number of numeric status or error codes. Here's a quick list of the most common ones and how to fix them:. If you are getting a Status when you have a valid license installed, then you are most likely exceeding the number of allowable connected workstations. Verify that the "Maximum" value matches the expected license count.
A mismatch could indicate a version problem. Then, verify that the "Peak" is hitting the "Maximum" value. If so, then you have these options:. Click on the first user in the upper-left corner of the window, and write down the Network Address data found in the lower left quadrant.
Press the down arrow to go to the next user session, and repeat this process for each database connection. If an address appears as a complete duplicate, you can skip it, because it has already been counted. You should get a number of unique network addresses that matches your current license count.