Difference of "Allowed/Disallowed" vs "Yes/No" in sp_iqlmconfig

[Former Member]

Hi IQ Gurus,

I am not sure if this is simple. But I can not find a clear answer for this thus I posted this question.

What is the impact of the Yes/No of an optional license in sp_iqlmconfig? It seems to have a diff effect compared to allow/disallow. In our setup we were able to successfully implement NLS with our SAP BW with IQ_LOB and IQ_VLDBMGT value equal to No(Allowed).

So what is the use of changing it to Yes? and how do you change it?

Regards,

Joan

[Gisung]

Hi,

You can change the value to "allowed" like below.

Run sp_iqlmconfig with the allow or disallow parameter to enable or disable an optional license.

The ALL keyword enables or disables all optional licenses, except IQ_VLDBMGT:

  sp_iqlmconfig 'allow', 'ALL'                   // enable all, except IQ_VLDBMGT

  sp_iqlmconfig 'disallow', 'IQ_SECURITY'        // disable IQ_SECURITY

Use the IQ_VLDBMGT and <quantity> parameters to change the number of available IQ_VLDBMGT licenses:

  sp_iqlmconfig 'allow', 'IQ_VLDBMGMT', '8'              // increase by 8

  sp_iqlmconfig 'disallow', 'IQ_VLDBMGMT', '2'           // decrease by 2

And Try to test with the following example after enabling the feature using sp_iqlmconfig.

1) create table test_lob (c1 clob) //for LOB license test

2) CREATE TABLE test_vldb (id int) //for VLDB license test

    PARTITION BY RANGE(id) (p1 VALUES <= (10),

    p2 VALUES <= (100))

Here is a useful KBA for this.

2040456 - [SAP IQ] Unable to use an optional license features on IQ16 SP08.

https://launchpad.support.sap.com/#/notes/2040456

Best Regards,

Gi-Sung Jang

[Former Member]

Hi Gi-Sung Jang,

Thanks for the info above. Our NLS implem is working smoothly in the cycles from sandbox towards qa. Attaching here the before and after. We allowed IQ_UDA, IQ_LOB and IQ_VLDBMGMT since we have unserved licenses for these.

Before:

After

though, disregard the IQ_CORE count, the images above are from diff enviroments.

No issues encountered and we actually moved large data from bw to iq and create a 1tb user dbspace but I am expecting to see only "Allowed" as the value for Optional license in use : IQ_UDA. But why does it show as "No (Allowed)"?

And when would it be "Yes (Allowed)"?

I am now clear with the concept of enabling the required license aside from IQ_CORE but I don't understand yet what No/Yes stands for? Because in the sql we only change the value as Allowed or Disallowed...

Regards,

Joan

[Gisung]

Hi,

Is it same as before when executing below example query?

1) create table test_lob (c1 clob) //for LOB license test

2) CREATE TABLE test_vldb (id int) //for VLDB license test

    PARTITION BY RANGE(id) (p1 VALUES <= (10),

    p2 VALUES <= (100))

Please attach the following details after executing the above example.

1. iqmsg file

2. output of "sysam diag" (~/SYSAM-2_0/bin)

3. output of sp_iqlmconfig

Best Regards,

Gi-Sung Jang