3754973 - dropping a dbfile after running "sp_iqemptyfile" fails with "Drop disallowed for dbspace <DBSpace_name>" error - SAP IQ

running "alter dbspace" statement to drop a dbfile which "sp_iqemptyfile" ran with fails with following error.

(DBA)> alter dbspace <DBSpace_name> drop file <dbfile_name>
Could not execute statement.

Drop disallowed for dbspace <DBSpace_name>. One or more of the file(s) are in use by the database.
-- (dblib/db_createdb.cxx 4321)

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

SAP IQ 16.1

sp_iqemptyfile, rlv tables, lock table command not supported, SQLCODE -1717, HY000, rlv dbspace, cannot empty files in rlv store dbspace, alter dbspace drop file, drop disallowed for dbspace, SQLCODE -1009156, OkToDrop N, A blocks, isolation level 3, -gm 1, checkpoint , KBA , BC-SYB-IQ , Sybase IQ , Problem