SAP IQ VLDM option

[Former Member]

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

[hans-juergen_schwindke · Accepted solution]

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

[Former Member · Accepted solution]

Thank you Juergen for helpful information.

Martin

[Former Member · Accepted solution]

Jurgen,

one more question.

What will happen when customer has for example 8TB DBspaces and they want to buy "only" 6TB for VLDM option. Will it be working or not?

Thank you.

Martin

[hans-juergen_schwindke · Accepted solution]

Hi,

usually it works like this: the customers buys a certain quantity and then they are only able to use this. In advance they have to specify this value in IQ:

sp_iqlmconfig 'allow', 'IQ_VLDBMGMT', 1;

Best regards,

Juergen

[markmumy · Accepted solution]

A customer cannot buy less VLDB license than they have space.  The VLDB option is tied to the total storage for all IQ main store dbspaces that IQ is managing.  If you license the VLDB option, then it must be able to contain the total space (not just in-use) of all IQ main dbspaces.

Per the other posts, when you add space and it exceeds the license that will fail.

Mark

[c_baker · Accepted solution]

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