How to generate SAP IQ database licensing?

The purpose of this blog article is to help and provide effective guidance in the database unserved license regeneration process. Since SAP IQ was not an SAP product originally (formerly Sybase IQ), the process is not straightforward; therefore some special steps must be performed.

SAP-IQ-Sybase.jpeg

The below steps are specific for implementation of SAP IQ database licensing.

Symptoms of License expiration in SAP IQ

When the SAP IQ license expires the database servers get down, and consequently there is no way to access the SAP IQ database.

The first symptom is that, when trying to start the database server from the Sybase Control Center (https://<host>:<port>/scc/#).

Log in with the following credentials:

·       Name: sccadmin

·       Password: sccadmin

SAP IQ license generation1.jpeg

Select the stopped IQ server, click on the arrow, and click Start Server button.

SAP IQ license generation2.jpeg

If the license has expired, the following error will appear:

SAP-IQ-license-generation3.jpeg

The best way to troubleshoot this error source, is analyzing 2 log files:

·       Path: ‘C:\ProgramData\SybaseIQ\logfiles\%DBname%.*.srvlog’

SAP-IQ-license-generation4.jpeg

·       Path: ‘C:\%DBfolder%\%DBname%.iqmsg’

SAP-IQ-license-generation5.jpeg

Generating a new license from SAP Market Place

This section describes the steps to generate the license from the SAP Market Place.

In this case we will suppose we want to generate an “unserved” license (one specific license for machine). To generate the license from the SAP Market Place, the Host ID needs to be specified. There are several ways to obtain the Host ID, I will only state the easiest one.

1.     Open the Cmd prompt, and navigate to the path ‘C:\SybaseIQ\SYSAM-2_0\bin’

2.     Once in this path, use the sysamcap utility by executing the command sysamcap MACHINE

SAP-IQ-license-generation6.jpeg

In our case we have 4 machines’ IDs. We will only need 1 of them to generate the license from the Market Place, and the specified name must include the literal “MACHINE-ID=…”. For instance, in our case we specified “MACHINE-ID=XXXXXXXXXXXX”.

As can be observed in the previous image, the last command also gives the number of processors, which is also a parameter to input in the SAP Martket Place.

  • Go to the SAP Market Place https://support.sap.com/licensekey Login with a valid S-user with permissions to generate new licenses
  • Click on Request Key From Install
SAP-IQ-license-generation7.jpeg
  •  Select your SAP IQ installation and system
  • Once you are on the generation of the license select un-served licenses
SAP-IQ-license-generation8.jpeg
  • Select the number of licenses (SAP IQ servers) to generate the license.
SAP-IQ-license-generation9.jpeg

In our example 1:

  •  Enter the Host-ID generated on the previous steps (step 2), the name of server in the domain and the number of licenses (cores of the server)
  • In our case, we entered the following parameters:

   Node Host ID: MACHINE-ID=XXXXXXXXXXXX

o   Host Name: %Hostname%

o   Number of Licenses: 16

SAP-IQ-license-generation10.jpeg

  •  Click generate your new license file is available to download. It will have a .lic extension, and will look similar to this one if opened with NotePad:
SAP-IQ-license-generation11.jpeg

Installing SAP IQ unserved license

This file must be placed in the licenses folder for SAP IQ instances, which can be found in the following path: ‘C:\SybaseIQ\SYSAM-2_0\licenses’.

SAP-IQ-license-generation-12.jpeg

After this step, the iq server must be started, either from the SAP Control Center, or from the command line, as desired.

From the SAP Control Center (https://<host>:<port>/scc/#), select the desired IQ server, click on the properties arrow, and click on Start Server button.

SAP-IQ-license-generation-13.jpeg

This time, the IQ database server should be successfully started!

SAP-IQ-license-generation-14.jpeg