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.