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
