Customer Ingres Licensing Training – Presentation


Ingres Licensing


Ingres License Key Manager

The interface that allows customers the capability of managing their own license keys. Accessible via the customer portal at

Ingres License Key Generator

Part of the Ingres License Key Manager that actually allows a customer to generate their licenses.

General Ingres Licensing Questions

Why is Actian changing the Ingres licensing mechanism?

The updated Ingres licensing mechanism is part of an Actian-wide initiative to consolidate and streamline our licensing infrastructure and to tie it more closely to our 360 degree customer support systems. Actian’s objective for this licensing update is to ensure that all Ingres deployments are valid and that all customers have licenses that fit their business requirements. Ensuring valid licenses means that Ingres customers know exactly what their deployments should be and that Actian support focuses its resources on licensed installations. Our number one priority is to deliver this transition with no business disruption to customers.

What changes are being made to Ingres licensing?

Only the mechanism for Ingres licensing is changing – Ingres licensing policy is unchanged. With the updated mechanism, Ingres licenses will be server specific and will have a start date and an expiration date. Customers will create licenses on the Customer Portal and utilities for license file creation and test will be included in Ingres patches and future releases. A new license will need to be generated each year (matching the annual subscription).

What versions of Ingres will be affected?

Ingres 10.x and later.

When will these changes be implemented?

The roll out of the licensing update will be in four phases:

  • Underway Now – New Ingres patches include two utilities – lichostinfo (to collect information required to create a new license) and cilicchk (to validate new licenses).
  • Initially lichostinfo, and cilicchk will be made available on ESD under Ingres / Ingres Licensing Utilities.
  • Q2 2016 – Deployment of the Ingres License Key Manager on the Customer Portal to allow customers to create license files. At this stage customers will be able to generate and validate license keys.
  • Q4 2016 (October 15, 2016) – Deployment of server side license checking in all Ingres downloads. Once this phase is underway, a valid license file will be required for applying any new patches and for new installations to complete.

Will this licensing technology be added to OpenROAD, EA and EDBC?

At this point, the new licensing affects only Ingres. It is in development for OpenROAD but no delivery date has been set. There are no plans at this point to add these licensing features to EA or EDBC.

What planning do I need to do for my Ingres installation?

Actian will send email notifications when the Ingres License Key Manager is available for testing. You will be able to login to the Actian Customer portal and get familiar with using the lichostinfo program to display the host details needed to complete the license generation and license.xml file delivery process on the portal. This will allow you to confirm in advance of applying patches that include the license upgrade that an instance of Ingres has a valid license.

What do I need to create a new Ingres license?

You will access the self-service Ingres License Key Manager in the Actian Customer Portal ( to create license files. The license info utility (lichostinfo) will provide the information (for example, the correct number of cores) needed to input into the fields on the License Key Generator page so that the license file can be generated. You can use the License Key Generator to create, replace or transfer licenses to other installations. The portal will track and enable reporting on all of these activities.

Am I required to update my copies of Ingres with these licensing changes?

The customer’s obligation to update their Ingres deployments to adopt the latest licensing features is determined by their contract. Actian recommends the update because it will be easier to keep track of and manage Ingres licenses. If you have questions about your contract, contact your Account Manager.

How do I get access to the Ingres License Key Manager?

Customers will use their existing customer portal login at The License Key Generator page will be accessible to all users who have an account with active purchased product records as a result of a valid contract with Actian Corporation. When the Ingres License Key Manager page becomes available customers with a current contract will receive an email with access instructions.

How do I create a login if I don’t have one yet? And, how can I download product and patches?

  • To get you started you will need your Account number which is a 7-byte unique identifier.
  • To download the software you must be registered:
  • Complete initial registration here.
  • An email will be immediately sent requiring you activate your registration.
  • Once your account is activated you can download the software here.
  • Once your initial registration is complete, and you have activated your account, an Actian Customer Portal account will be created for you as long as you entered the above account number in your registration. You will receive a notification once your enrollment has been completed.
  • Actian Customer Portal is a 24×7 online product support application for Actian customers. Customers can open new issues, check the status and update existing issues, as well as search the Actian Knowledge Base to obtain help or improve your Actian knowledge. You can access our online system here.

I need to be able to license Ingres for a higher number of cores during peak periods. How do I do this?

Contact your account manager or

Where do I install the license.xml file?

The license.xml file can be placed in any directory to which Ingres has access. The file owner and/or permissions of the license.xml file must allow the Ingres installation owner to read the file. When Ingres licensing is fully activated, patch and base installers will prompt for the directory and store it in the Ingres configuration file (config.dat). The cilickchk utility takes an absolute path as a parameter and can be used to validate an installed license file before Ingres Licensing is fully activated.

Can I put all of my license files in one place or file?

A single location can be used for licenses as long as the individual license.xml files are concatenated into a single license.xml file. To concatenate keys you need to following the instructions in this detailed knowledge document.

Will Ingres start without a valid license?

No. If the machine finger print does not match, the number of cores has been exceeded, the license file content has been edited or the license is not valid for any other reason Ingres will not start up. The only exception is an expired license that is otherwise valid and is within the 30 day grace period.

I have a contract for less cores than there on my host because I am using core affinity but Ingres licensing reports that I am not licensed for enough cores. What do I do?

Many core affinity mechanisms provide a preferred set of cores and do not strictly limit the execution of a program to the defined subset of cores. As such Ingres may run on more cores than those specified by the core affinity mechanism you are using. Ingres Licensing will require a license for the total number of cores available on your host. If you have an existing core affinity agreement in place please your account manager or

Licensing Details

What is the process for creating a new license?

Customers will access the self-service Ingres License Key Manager in the Actian Customer Portal ( to create license files. The license info utility (lichostinfo) will provide the information (for example, the correct number of cores) needed to input into the fields on the License Key Generator page so that the license file can be generated. This utility can be downloaded through the customer portal or directly at The License Key Generator can create, replace or transfer licenses to other installations. The portal will track and enable reporting on all of these activities.

What value must I enter in field ‘License Usage’ and what is it for ?

This is a free text field that allows the user to add a reference or comment that will be meaningful to the user. A project name, end customer name or application name for example.

How do I get an eval license for Ingres?

Contact Actian Sales at

Can a license order for multiple cores be split across multiple machines?

Yes, customers are permitted to create multiple licenses against an order as long as the number of cores represented in the licenses created is not more than the purchased number of cores.

Can licenses be moved from one machine to another?

No. Because licenses are specific to a server, lichostinfo output must be entered into the Ingres License Manager to create a new license on each machine. If you are moving your installation from one machine to another then you need to replace your existing license key with a new license key using the ‘replace’ option within the customer portal.

What happens when licenses expire?

60 days prior to expiration, the license check will start writing warning messages to the Ingres log file (visible to DBA’s but not ‘normal’ users). The DBA will also be able to configure Ingres to send email notifications to a list of recipients. Once past the expiration date, the warnings state that the software will stop working 30 days past the expiration date and will count down the number of days remaining. At 30 days past the expiration date, Ingres is paused until a new license is installed. No new sessions or transactions can be initiated. Transactions in progress will be paused until a valid license is detected. When a valid license is installed, paused transactions will be automatically resumed. Ingres does not need to be shut down to install a new license file.

Do I need to generate a new license each time my current license expires?

Yes. Licenses will expire at the end of a subscription period. Actian will send fulfilment letters as part of the renewal process. Customers will generate new licenses for the subscription renewal period. Once the new licensing is in place, Ingres will require a valid license to start.

How does licensing work in a virtual environment?

Ingres Licensing treats a virtual machine as if it was a physical machine. Each Virtual Machine will require its own license file just as if it were a physical machine.

I’m running Ingres in a cluster. How does this need to be licensed?

Ingres needs to be licensed for each machine it will run on. That remains true if the machines are part of an Ingres or OS cluster. In an active-active clustered Ingres installation all hosts need to be licensed as production hosts. In an Active-Passive Ingres Cluster or an OS cluster in which Ingres is only actively running on one node at a time, one host must be licensed for production and the remaining hosts must be licensed for hot-standby.

I’m running Ingres on a Hardware-Threaded (e.g. Hyper-Threaded) system and lichostinfo reports threads instead of cores. What should I do?

If you are running Ingres on a Hardware-Threaded system, contact your account manager to discuss how to set up your license.

Do I need to pay for a license on a DR server?

Yes. Hot-Standby is changed at full price and Cold-Standby is charged at 50%. DR servers need a license file as the server ‘fingerprint’ will be different to that of the production server so the license file won’t migrate.

How is licensing a DR server different from an HA server?

High Availability/Failover servers (currently licensed on an ING-HS-…. product code) require fully paid licenses. The distinction is that DR servers are not powered up until the production system fails so the Ingres installation is never active at the same time as the production server whereas a HA or failover system is powered up all the time and the Ingres installation is actively being kept in synch with the production server.

Do I need a license on a client only installation?

No. License are only required on server installations.

Will my license remain valid if I upgrade my instance of Ingres?

License.xml files will remain valid (as long as the server hasn’t been changed) with all currently supported versions of Ingres. For example, if a license file is created for an instance of Ingres 10.0, that license file will be valid if the instance is upgraded to Ingres 10.2. If the instance is being upgraded to a version of Ingres that was not available when the license was created, the license will need to be replaced.

How should I manage licensing for hardware or OS upgrades?

Contact your account manager to discuss your upgrade testing requirements and to determine if you need a temporary license for the test period. If you use a temporary license for testing the upgrade, you will need to replace the original production license with one for the new hardware/OS.

Will my license be affected by a NIC change?

The lichostinfo utility automatically detects the use of multiple NICs and generates a license key that will remain valid even if the host is rebooted and the NIC order changes. If all of the NICs in a machine are replaced, the license will need to be replaced.

Will licensing affect pricing?

No, Ingres pricing is unaffected by the licensing update.

I have installed the DBMS package into a client install in order to use utilities like copydb over Net. I am not running an Ingres DBMS on the client but the patch and release installers now ask for a valid license on my client install. What do I do?

Setup of the DBMS package will hang without a valid license file. This is why the base installers prompt for a valid license before installing the DBMS package. Without a valid license the Ingres DBMS package will not start. If you are only using utilities such as copydb from a client installation you will need an evaluation license to be able to install the utilities that form part of the DBMS package when installing from a base release. Contact your account manager or to obtain an evaluation license. Patch installers will prompt for a valid license the first time a license enabled patch is installed. To prevent this prompt run “iisetres ii.HOSTNAME.config. license_dir DIRNAME” where HOSTNAME is the hostname as it appears in other config.dat entries for the host and DIRNAME is a valid directory path for your operating system. This will not allow you to run an Ingres DBMS without a valid license. It will allow you to patch DBMS utilities such as copydb without a valid license. The startup counts for DBMS Server and Star Server should be changed to zero on a “client” install. Longer term Actian Engineering will separate DBMS utilities such as copydb from the core DBMS package.

I have multiple Ingres installations running on the same host. Do they need separate license keys?

No. Ingres is licensed by host. The same license.xml can be used by all Ingres installations on the same host as long as the relevant Ingres version number of each installation is present in the license.xml. The license.xml can be copied to an installation specific directory and each installation configured to point to its own copy of the license.xml or all installations can be configured to point to a single directory containing a single copy of the license.xml.


Who should I contact for Ingres licensing support?

Contact your Actian Account Executive, the Actian Partner you have purchased your product through, or email with any licensing problems.

What if I can’t generate a new license when my current license has expired?

Contact Actian sales at and ask for a temporary license or an extension to your existing license. Temporary and extension licenses are 30-days plus a 30-day grace period. Because the new licensing starts delivering warning messages 60 days before pausing, these licenses will generate warning messages as soon as they are installed.

How can a license become invalidated?

There are only a few ways an updated Ingres license can become invalid. They include increasing the number of cores on a server and deleting, moving or changing the license.xml file.

What happens if my license becomes invalidated while Ingres is running?

A running installation that detects changes that invalidate the license will continue to run for three days before pausing Ingres. A new license can be generated and added during this period, or the machine can be returned to its original configuration. Ingres Licensing error messages in the errlog.log can be used to help identify the reason why the license file has been invalidated. If necessary the license.xml file can be recovered by downloading a copy from the Ingres License Manager.

I am getting an error when trying to create a new license for a number of cores that is less than or equal to my remaining cores. What should I do?


How do I find out why an Ingres License Check has failed?

Check the Ingres errlog.log for licensing errors. If the license file has not been modified Ingres will generate specific error messages for specific failures.

I’m an Ingres OEM, will I need to generate individual licenses for each host at each of my customer sites?

Contact your account manager or