Skip to Content

I have a Customer who failed to use a IQ_VLDBMGMT license after upgrading IQ16 SP03 to IQ16 SP08.

Error :
=====

     Could not execute statement.
     Authorization required to attempt checkout IQ_VLDBMGMT license
      SQLCODE=-1006276, ODBC 3
     State=”HY000″ Line 1, column 1

      create dbspace RYOHIST using file
      sybdata11 ‘/export/RYOPRD/sybdata/sybdata03’, file sybdata12 ‘/export/RYOPRD/sybdata/sybdata04’

Environment

     – IQ16 (more than) SP08.x

Cause

     New license checkout behavior requires the DBA to authorize access to any optionally licensed feature.
     SAP IQ will not attempt to check-out an optional license by default from IQ16SP08.

Resolution

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

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. William Woo

    Hi Gi-Sung,

    Thanks for sharing this behavior change in IQ 16 SP08! It is a good behavior change as it can prevent users from accidentially activating an unlicensed option on a licensed IQ server and throw the IQ server into grace mode.

    William

    (0) 
  2. Edgae Sanchez

    Hi Gi-Sung,

    Thanks for sharing this behavior change in IQ 16!

    I have a question, i hope you can help me.

    Do you know, where i can find the value of parameter <Quantity>?

    Edgar!

    (0) 
    1. Mark Mumy

      The QUANTITY parameter is the size of the license that you purchased.  For the VLDB option, the number represents the maximum amount of IQ main store (all main stores) space, in TB, rounded up.  So if you have 9.8 TB of main store space, you would need a quantity 10 license.

      Mark

      (0) 
    2. Gi-sung Jang Post author

      Hi Edgae Sanchez

      From IQ16 SP08 manual, <quantity> is an integer value from 0 to 4,294,967,295 that sets the number of available IQ_VLDBMGMT licenses.

      If you purchase IQ_VLDBMGMT with 10TB, You can see the value of quantity within license file as follows.

      -> CP=10

      It means that you purchased 10TB “IQ_VLDBMGMT” license and generated license with 10TB.

      ** Helpful KBA# 2121535

      https://i7p.wdf.sap.corp/sap/support/notes/2121535

      [Ex : IQ_VLDBMGMB licesce]

      # Sybase Software Asset Management License File. TB License for Sybase IQ Very

         # Large Database Management Option

         # License for ID_STRING=xxx hpita

         INCREMENT IQ_VLDBMGMT SYBASE 2016.05040 04-may-2016 uncounted \

               VENDOR_STRING=PE=EE;LT=TB;AP=IQ \

               ISSUER=”CO=Sybase, Inc.;V=15.0;AS=A;CP=10;MP=547;EGO=” \

      HTH

      Gi-Sung Jang

      (0) 
  3. Edgae Sanchez

    Hi, Mark and Gi-sung

    Thanks for you help! I reviewed the license file and i could see the value of quantity

    ->  CP = 16.

    Finally i could create partition tables.

    (0) 

Leave a Reply