SAP Knowledge Base Article - Preview

2291835 - Cannot drop a dbfile from IQ_SYSTEM_MAIN if RLV is enabled - SAP IQ 16


When the dbspace IQ_SYSTEM_MAIN contains several dbfiles, and RLV is enabled on the database, then dropping one of the dbfiles from IQ_SYSTEM_MAIN would fail with this error:

Drop disallowed for dbspace C:\IQ16\IQ-16_0\demo\
One or more of the file(s) are in use by the database.
-- (slib\s_db.cxx 4062)
SQLCODE=-1009156, ODBC 3 State="HY000"

Even though, there is no other connection on the database and the dbfile is empty.
Stop and restart the IQ sever does not help.



  • SAP IQ 16.0
  • SAP IQ 16.1


SAP IQ 16.0


CR 796690 ; 796690 ; RLV ; IQ_SYSTEM_MAIN ; drop ; dbfile ; Drop disallowed for dbspace ; One or more of the file(s) are in use by the database ;  SQLCODE=-1009156 ; , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.