Understanding NLS (Near Line Storage) Licensing

Hi Everyone,

In this blog I am going to explain you about how licensing of Near Line storage (NLS)/ cold storage is done. With Moving on to HANA Database there is increase in use of cold storage among various customers. In this blog i will be explaining the licensing part of SAP IQ database. how it can be applied.

Installation of NLS and configuration with HANA application is explained in detail in below mentioned link

https://www.sap.com/documents/2013/03/d2ff3a4c-577c-0010-82c7-eda71af511fa.html

For NLS we require we need 4 components to be activated and licensed in SAP IQ database

IQ_CORE

IQ_VLDBMGMT

IQ_LOB 

IQ_UDA

License for all this components are required to be generated from service market place.

This License can we generated based on Item description. Please check below table for more detail

Apart from this we have to choose License type according to system in which we are applying

for example :

CP : CPU License  == Production Environment

DT : Development and Testing == Development or QA environment

Here is our case we have installed Sybase IQ EE (Enterprise Edition) with License Type DT (Development and Testing)

Hence we require license for all four components (IQ_CORE , IQ_VLDBMGMT , IQ_LOB , IQ_UDA) in license type DT

We have to generate this license first so click on generate

here you have to insert Host ID. It can be found on the link provided on this screen.

As our host was linux we got host ID by command :  /sbin/ifconfig eth0

on completing this step we will get out license and we can download it from the service market place

This way we have to generate all 3 license (IQ_CORE , IQ_VLDBMGMT , IQ_UDA) (Note : IQ_LOB is runtime license and can be activated using command mentioned below)

Once all 3 license are downloaded we have to place this license files in $sybase/SYSAM02-2/license/ and restart IQ server.

It will read the license file from there and it can be seen from .msg log file of SAP IQ

After this license is applied we have to activate all the components in SAP IQ

If you installed SAP IQ 16 sp08 and above or higher, please notice that the way of activating the correct license key has changed. After the license is installed, you have to activate the IQ_VLDBMGMT option as follows:

sp_iqlmconfig ‘allow’, ‘ALL’;
sp_iqlmconfig ‘allow’, ‘IQ_VLDBMGMT’ , ‘<number>’ ;

The Very Large Database Management Option (IQ_VLDBMGMT) lets you logically partition very large data sets into smaller subsets.

The IQ_UDA option can be activated by the creation of a the TEXT indexes and the Text Configuration Object.

CREATE TABLE dbo. udatest (U1 integer NOT NULL, U2 long varchar NULL, PRIMARY KEY(U1)) <– IQ_LOB is enabled
CREATE TEXT INDEX udaidx ON dbo. udatest(U2) CONFIGURATION default_char; <– IQ_UDA is enabled

upon running above steps you can check activate component information using below command

sp_iqlmconfig

I hope this information will help to you to generate and apply license for SAP IQ for using it as an cold storage/ near line storage.

Below is few reference SAP Notes which can be helpful here.

https://launchpad.support.sap.com/#/notes/2372218  (Requisite IQ licenses for SAP-NLS solution – SAP BW with SAP IQ Nearline-Storage)

https://launchpad.support.sap.com/#/notes/2047526 (Authorization Required to attempt checkout IQ_LOB License)

https://launchpad.support.sap.com/#/notes/1985209 (How to enable a IQ_UDA license – SAP IQ)

Regards

Bhargav Bhatt