You want to create another database schema in an existing SAP IQ database. The SQL statement end up with the following error,
Could not execute statement.
Authorization required to attempt checkout IQ_VLDBMGMT license
SQLCODE=-1006276, ODBC 3 State=”HY000″
Line 1, column 1
Solution
First and foremost, your SAP IQ database must entitled and equipped to the correct license.
Referring to SAP Note 2047526 – Authorization Required to attempt checkout IQ_LOB License – SAP IQ, the steps to the resolution are as below,
Step 1: Launch and login to the DBISQL. Ensure your logged ID is having the appropriate authorization.
Step 2: Execute below SQL statement. The number 2 below is just the example of applicable license to your IQ database (please check further with SAP licensing team).
sp_iqlmconfig 'allow', 'IQ_VLDBMGMT', 2
Step 3: To confirm the change, use sp_iqlmconfig command to see the license state and status. If you see below screenshot, the IQ_VLDBMGMT value is now Yes (Allowed). You can re-run the above failed SQL statement again.
sp_iqlmconfig
Reference
- 2047526 – Authorization Required to attempt checkout IQ_LOB License – SAP IQ
- 2301767 – Why couldn’t the second user dbspace be created in IQ16 sp11 after applied license IQ_VLDBMGMT?
- 2040456 – [SAP IQ] Unable to use an optional license features on IQ16 SP08
