SAP SQL Anywhere Server and Database Startup and Administration

Starting and managing databases and servers differs between SAP Sybase IQ and SAP SQL Anywhere.

SAP Sybase IQ uses the server startup command start_iq, instead of the SAP SQL Anywhere network server startup command.
SAP Sybase IQ does not support personal servers.
SAP Sybase IQ supports many SAP SQL Anywhere server command line options, but not all. Other server options are supported for SAP Sybase IQ but not for SAP SQL Anywhere.
SAP Sybase IQ provides the stop_iq utility (UNIX) to shut down servers.
Clauses permitted in the BACKUP DATABASE and RESTORE DATABASE statements differ in SAP Sybase IQ and SAP SQL Anywhere.
SQL Remote is supported in SAP Sybase IQ only for multiplex operations.

SAP Sybase IQ supports many SAP SQL Anywhere database administration utilities, but not all:

The following SAP SQL Anywhere utilities are not supported by SAP 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
- write file
SAP Sybase IQ supports the SAP SQL Anywhere validation utility only on the catalog store. To validate the IQ main store, use sp_iqcheckdb.