SQL Anywhere Server and Database Startup and Administration

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

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

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

The following 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 SQL Anywhere validation utility only on the catalog store. To validate the IQ main store, use sp_iqcheckdb.