In this blog post, you’ll learn more about the Sybase Error ‘%2’ command is not allowed on temp store files, when server started with -iqnotemp switch. %1 and the reason for receiving this error
Sybase SQL Error Message
‘%2’ command is not allowed on temp store files, when server started with -iqnotemp switch. %1
Reason for this Error
When the server is running with -iqnotemp switch, certain alter dbspace operations are not allowed. For e.g. alter dbspace add file.