In Sybase IQ 12.6, sp_iqrelocate does
not check for appropriate dbspace modes before running. It parses
and executes the command even if the net result is that nothing
moves. In 12.7, sp_iqrelocate checks
for the existence of at least one dbspace in relocate mode and at
least one dbspace in read-write mode immediately after parsing the
target string. If the dbspace check fails, the command returns the
error “There must be at least one read-write
dbspace and one relocate dbspace to relocate data.”
You cannot alter a dbspace directly from read-write to read-only mode if there are active read-write transactions. You must first alter the dbspace to relocate mode and then alter it again to read-only mode after all read-write transactions that were active while the dbspace was read-write have completed.
