Sybase IQ Operations

Descriptions of known issues and workarounds for Sybase IQ operations.

Interactive SQL issues
CR# Description
644210
  • Interactive SQL (dbisql) online help is not available – Online help is not available for either the Interactive SQL (dbisql) utility or the deprecated Interactive SQL Classic (dbisqlc) utility.

Open Client issues
CR# Description
662422
  • Remote query performance degrades with DATETIME column – Sybase IQ 15.3 and the default Open Client/Server included with Sybase IQ 15.3 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

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.3.
Related concepts
Installation and Configuration
SySAM Licensing
Multiplex Environment
Sybase Central
Related reference
Restrictions