Consider information about restrictions to avoid unexpected results from your system.
This information applies to servers and databases of this version of Sybase IQ that have been upgraded from any earlier version of Sybase IQ, unless specified otherwise.
Due to security fixes in IQ 15.3, the Sybase IQ 15.4 plug-in for Sybase Central™ and Sybase Central Agents are not compatible with versions of Sybase IQ earlier than 15.2 ESD #3. You can use the 15.4 plug-in only with Sybase IQ servers that are 15.2 ESD #3 or later, including 15.4; you cannot use the 15.4 plug-in to connect to 12.x servers or servers earlier than 15.2 ESD #3.See New Features Summary.
The dbbackup utility truncates the database name to 70 characters and creates a target file with a truncated name. Sybase IQ uses dbbackup when synchronizing secondary servers. Due to dbbackup restrictions, database names must be less than 70 characters long.
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.
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'