Skip to Content
avatar image
Former Member

SAP IQ VLDM option

Hello all,

I would like to ask about one detail of IQ VLDB Option.

Our customer wants to buy 6TB license and they asked us what will happen when the license limit will be exceeded. Server will stop, nothing will happen, warning in IQMSG log or .... ?

Is here anybody who knows it? :-)

Thank you a lot.

Regards,

Martin

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 13, 2016 at 08:27 AM

    Hi Martin,

    on your console you will expand the database and reach the limit. During this operation you'll see an error message like this:

    (DBA)> alter dbspace IQ_store alter file data08 add 200GB;

    Execution time: 0.593 seconds

    (DBA)> Could not execute statement.

      Insufficient quantity authorization available for IQ_VLDBMGMT license

      SQLCODE=-1006277, ODBC 3 State="HY000"

      Line 1, column 1

      alter dbspace IQ_store alter file data08 add 200GB

    Press ENTER to continue...

    So the limit is not reached automatically, you extend the database and then it happens.

    Best regards,

    Juergen

    Add comment
    10|10000 characters needed characters exceeded

    • IQ_VLDB allows the use of partitions, some larger datatypes, and additional dbspaces beyond IQ_SYSTEM_MAIN.

      You must have the license in place to use those features and expand the database in the first place.  With the license in place, IQ will prevent the total size of any dbpaces beyond the size of the license.

      AFAIK, substituting a smaller license after the fact, may prevent the server from starting, if the total size of main dbspaces exceeds the allowance of the license (this is also a compliance issue w.r.t. the license terms the customer has with SAP).

      The only way to safely reduce the license as you discuss, is to drop dbfiles or create dbspaces with the smaller size so only 6TB is even requested from the license, and set the lower limit in sp_iqlmconfig.

      Chris