Sybase IQ Operations

Descriptions of known issues and workarounds for Sybase IQ operations.

Interactive SQL issues
CR#	Description
652471	ASE 15.5 ESD 3 installation causes library error on Interactive SQL (dbisql) startup – The IQ installer sets the following parameters in the Interactive SQL executable: "$SYBASE_JRE6/bin/java" -ms20m -mx120m -d64 -Disql.helpFolder="$DBISQL_DIR/help" -Djava.security.policy="$DBISQL_DIR/lib/java.policy" -Dpath="$path" -Disql.repositoryDirectory="$DBISQL_DIR/bin" -classpath "$DBISQL_DIR/lib/:$aseisqlplugin_jar:$isql_jar:$jlogon_jar:$jodbc_jar:$xml4j_jar: $asa_jar:$jconn_jar:$dsparser_jar:$jcomponents_jar:$jh_jar:$jsyblib_jar:$planviewer_jar: $sceditor_jar:$uafclient_jar:$jinicore_jar:$jiniext_jar:$jmxremote_jar:$jmxri_jar: $commonslogging_jar:$log4j_jar" sybase.isql.ISQLLoader "$@" However, the ASE 15.5 ESD 3 installer overwrites the `-ms20m -mx120m -d64` parameters, returning the following error when you attempt to start Interactive SQL (dbisql): DBLIB library can not be loaded. Workaround – Add the `-ms20m -mx120m -d64` parameters to the Interactive SQL (dbisql) command line startup script. This issue will be corrected in the next ESD of ASE 15.5.
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 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.3.