While progressing the upgrade for SAP IQ database, your execution is interrupted while running on SQL statement, “alter database upgrade”
The error message is saying,
Could not execute statement.
Not allowed while ‘DBA’ is using the database
SQLCODE=-211, ODBC 3 State=”40001″
Solution
Taken the solution shared from SAP website. We did solved the issue by using the Workaround 2.
Workaround 1
Start the SAP IQ with the option, -gm 2 where this option will allows 2 connections.
Workaround 2
Step 1: Use sp_iqwho to determine the active “DBA” user session.
Step 2: Drop the “DBA” user connection. You can refer to this article for further steps.
Workaround 3
Temporary start your SAP IQ database with different port. Use option -x while starting up the database.
