Restrictions

This information applies to servers and databases of this version of SAP Sybase IQ16.0 that have been upgraded from any earlier version of SAP Sybase IQ, unless specified otherwise.

Database Name Length Restriction [CR #365281]

The dbbackup utility truncates the database name to 70 characters and creates a target file with a truncated name. SAP Sybase IQ uses dbbackup when synchronizing secondary servers. Due to dbbackup restrictions, database names must be less than 70 characters long.

Dbspace Management and File Placement

When you allocate file system files for dbspaces (System, IQ main, or IQ temporary), do not place the files on a file system that is shared over a local area network. Doing so can lead to poor I/O performance and other problems, including overloading the local area network. Do not place IQ dbspace files on network drives or Network File System (NFS) file systems.

To avoid conflicts, Sybase recommends that dbspace management be performed by a single database administrator on a single connection.

Dbspace Naming in RESTORE Command [CR #561366]

If the dbspace name contains a file extension such as .iq, .iqtmp, or .iqloc, you must enclose the dbspace name in double quotation marks when specifying the name in a RESTORE command RENAME clause. For example:

RENAME local1 TO '/work/local1_res.iqloc.iqloc' 
DBSPACENAME "local1_res.iqloc"

or

RENAME "test_prod2.iq" TO '/test/test_prod7.iq'

Unexpected Query Results

In a few unusual circumstances, differences in semantics between SQL Anywhere and SAP Sybase IQ may produce unexpected query results. These circumstances are:

A query is issued from inside a user-defined function
A SELECT statement has no FROM clause
A FROM clause contains some tables that were created IN SYSTEM and others that were not created IN SYSTEM

In these circumstances, subtle differences between the semantics of SQL Anywhere and SAP Sybase IQ may be exposed. These differences include:

SAP Sybase IQ treats the CHAR and VARCHAR data types as distinct and different; SQL Anywhere treats CHAR data as if it were VARCHAR.
When the RAND function is passed an argument, the behavior is deterministic in SAP Sybase IQ and nondeterministic in SQL Anywhere.