Note the following differences in starting and managing databases and servers:
Sybase IQ uses the server start-up command start_asiq, instead of the Adaptive Server Anywhere network server start-up command.
Sybase IQ does not support personal servers.
Sybase IQ supports many Adaptive Server Anywhere server command line options but not all. Other server options are supported for Sybase IQ but not for Adaptive Server Anywhere.
Sybase IQ provides the stop_asiq utility to shut down servers.
Clauses permitted in the BACKUP and RESTORE statements differ in Sybase IQ and Adaptive Server Anywhere.
SQL Remote is supported in Sybase IQ for multiplex operations only.
Sybase IQ supports many Adaptive Server Anywhere database administration utilities, but not all.
The following Adaptive Server Anywhere utilities are not supported by Sybase IQ: backup, compression, console, initialization, license, log transfer, log translation, rebuild, spawn, some transaction log options (-g, -il, -ir, -n, -x, -z), uncompression, unload, upgrade, and write file.
Sybase IQ supports the Adaptive Server Anywhere validation utility on the Catalog Store only. To validate the IQ Store, use sp_iqcheckdb.
