How to deploy VLDB license?

[former_member232292]

Dear all,

   Currently, my IQ server is running with Core license -- PE=EE and LT=CP -- But with a new license file for VLDB -- PE=EE and LT=TB. I found the IQ server instance can only find the Core license and enable the Core feature. --

I. 08/18 08:32:40. 0000000000 Using licenses from: /asiq160/SYSAM-2_0/licenses/bigDataIQ_20160818_101513.lic:/asiq160/SYSAM-2_0/licenses/bigDataIQ_20160818_103050.lic:/iq_data/spx/*.lic

I. 08/18 08:32:40. 0000000000 Checked out license for 8 IQ_CORE (2017.10220/22-oct-2017/0D98 EC24 A72F FCE9) will expire Mon 23 Oct 2017 12:00:00 AM GMT.

I. 08/18 08:32:40. 0000000000 WARNING: IQ functionality that requires the IQ_CORE license will be disabled on Mon 23 Oct 2017 12:00:00 AM GMT, unless a suitable IQ_CORE license is obtained before that date.

I. 08/18 08:32:40. 0000000000 This product is licensed to: SAP Internal License Key

I. 08/18 08:32:40. 0000000000 OpenDatabase Completed

   And there are 2 lic files in the licenses folder -- 1 for the core feature another for the VLDB  --

cat *.lic

...

INCREMENT IQ_EE SYBASE 2017.10220 22-oct-2017 uncounted \

...

INCREMENT IQ_VLDBMGMT SYBASE 2017.10220 22-oct-2017 uncounted \

    And the sp_iqlmconfig's output --

Property,Value

'Licence Notice ','SAP Internal License Key'

'Edition ','EE'

'License Type ','CP'

'Application Type ','IQ'

'IQ_CORE License Count in use','8 (CPU core based)'

'Optional license in use : IQ_UDA','No (Disallowed)'

'Optional license in use : IQ_LOB','No (Disallowed)'

'Optional license in use: IQ_SECURITY','No (Disallowed)'

'Optional license in use: IQ_MPXNODE','No '

'Optional license in use: IQ_VLDBMGMT','No (Disallowed)'

'IQ_VLDBMGMT License Count in use','0 (Max Allowed : 0)'

'Optional license in use: IQ_UDF','No (Disallowed)'

'Optional license in use: IQ_IDA','No (Disallowed)'

'Optional license in use: IQ_URIDA','No (Disallowed)'

'Email Severity','NONE'

    Please kind help. Thanks in advance for any help.

Regards

Eisen

[tayeb_hadjou · Accepted solution]

Hi Eisen,

Please review KBA

  2047526 - Authorization Required to attempt checkout IQ_LOB Licnese

Example, for IQ_VLDBMGMT license feature, before using this feature DBA should authorize using:

            sp_iqlmconfig 'allow', 'IQ_VLDBMGMT', <number>

Where <number> is the quatinty to auhtorize.

Regards,

Tayeb.

[former_member232292 · Accepted solution]

Dear Tayeb,

    Thanks a lot... It's fixed...

Regards

Eisen