Sybase Error – ‘%2’ command is not allowed on temp store files, when server started with -iqnotemp switch. %1

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.