Sybase Error – %2 is in use by another sp_iqemptyfile, sp_iqmovetablefromfile or ALTER DBSPACE command. %1

In this blog post, you’ll learn more about the Sybase Error %2 is in use by another sp_iqemptyfile, sp_iqmovetablefromfile or ALTER DBSPACE command. %1 and the reason for receiving this error

Sybase SQL Error Message

%2 is in use by another sp_iqemptyfile, sp_iqmovetablefromfile or ALTER DBSPACE command. %1

Reason for this Error

sp_iqemptyfile or ALTER DBSPACE commands disallow status change for the FILE(s) or DBSPACE. No other ALTER DBSPACE or sp_iqemptyfile command can run on those FILE(s) or DBSPACE.