Known Issues for Sybase IQ Operations

Descriptions of known issues and workarounds for Sybase IQ operations.

Open Client issues
CR#	Description
662422	Remote query performance degrades with DATETIME column – Sybase IQ 15.4 and the default Open Client/Server included with Sybase IQ 15.4 support the TDS `BIGDATETIME` data type for remote queries. When a Sybase IQ server executes a remote query using Open Client and fetches a `DATETIME` column on an IQ/SA remote server, the return data type is `BIGDATETIME`, instead of `DATETIME`. This may degrade performance. This performance degradation may not occur, when the remote server is an ASE server. To prevent the return of `BIGDATETIME` values, apply this workaround. Workaround – Add these lines to the Open Client and Open Server configuration file $SYBASE/$SYBASE_OCS/config/ocs.cfg to prevent the return of `BIGDATETIME` values: [Sybase IQ] CS_CAP_RESPONSE = CS_DATA_NOBIGDATETIME See also Open Server 15.0, Open Client 15.0, and SDK 15.0 > Open Client Client-Library/C Reference Manual > Client-Library Topics > Using the runtime configuration file.

Server startup issues
CR#	Description
663054	Database recovery fails if server started with -iqro 1 flag – A 15.2 database that is archived cannot be recovered if you specify the read-only flag -iqro 1 on the startup command in Sybase IQ 15.4.