Character set translation enabled by default (behavior change) In previous versions, character set translation was turned off by default and you had to specify the -ct command line option to enable character set translation. Character set translation is now enabled by default, but can be disabled using the -ct- command line option.
When the server determines that the connection's character set differs from the database's character set, the server applies character set translation to all the character strings sent to and from the server for that connection.
The server disables character set translation for a connection when it determines that the database and the connection have equivalent character sets.
In most cases, character set translation should be enabled. One possible change in behavior occurs when binary data is inserted into a database and is fetched as character data, or vice versa. In this case, the data may not be returned exactly as it was entered because the server applies character set translation only to character data. To avoid this problem, applications should not send or fetch character data using a binary type.
For more information, see Chapter 1, “Running the Database Server” in Sybase IQ Utility Guide.
-cw command line option This server option lets you use Catalog Store cache sizes up to 64 GB on Windows 2000, Windows XP, and Windows Server 2003.
For more information, see Chapter 1, “Running the Database Server” in Sybase IQ Utility Guide.
Dynamic Catalog cache sizing more aggressive (behavior change) Dynamic cache sizing for the Catalog Store is now more aggressive at resizing the cache after a new database is started or when a file grows significantly. Prior to this change, statistics were sampled and the cache was resized at most once per minute. Now, after a database is started or a file grows significantly, statistics are sampled and the cache may be resized every five seconds for thirty seconds. To ensure appropriate behavior, start your server with the recommended minimum or higher for -c. For more information, see Chapter 1, “Running the Database Server” in Sybase IQ Utility Guide.
-e option replaced by -ec (behavior change) The -e command line option and the -e option in the Data Source Utility, used to encrypt client/server communications, have been replaced by the -ec option. On the server, -ec simple uses the same encryption algorithm as -e in previous versions.
For more information on new encryption features, see “Security enhancements”.
-iqsmem server option is deprecated This option to specify unwired memory is not needed for any platform supported for version 12.6. It has been removed from the documentation, and from the IQ plug-in.
-d server option no longer supported (behavior change) As a result of enhancements to NetWare support, the -d server option is no longer required.
Server's quiet mode enhanced The server's quiet mode and error logging switches have been enhanced to allow the server to suppress a variety of messages. Additionally, the -qw option has replaced the -q option, and the -qi option has replaced the -Q option. For more information, see Chapter 1, “Running the Database Server” in Sybase IQ Utility Guide.
-qp and -qs options The -qp server option lets you suppress messages about performance in the database server window. On Windows servers, the -qs server option suppresses startup error dialogs. For more information, see Chapter 1, “Running the Database Server” in Sybase IQ Utility Guide.
Obtain the most recently prepared SQL statement for a connection The database server -zl command line option turns on capturing of the most recently prepared SQL statement for each connection to the database on a server. You can also turn on this feature using the sa_server_option stored procedure with the remember_last_statement setting.
When this feature is turned on, the LastStatement property function and the sa_conn_activity system procedure return the most recently prepared SQL statement for the current connection and all connections to the database on a server respectively.
For more information on -zl, see Chapter 1, “Running the Database Server” in Sybase IQ Utility Guide.
For more information on sa_conn_activity and sa_server_option, see Chapter 9, “System Procedures” in Sybase IQ Reference Manual.
For more information on the LastStatement property, see the Adaptive Server Anywhere Database Administration Guide.
START DATABASE statement allows log truncation on checkpoint and read-only mode, and password for strong encryption The START DATABASE statement now allows a database to be started either with log truncation on checkpoint enabled, or in read-only mode. It also lets you specify a key (password) to start a strongly encrypted database.
For more information, see START DATABASE statement [DBISQL] in Chapter 6, “SQL Statements” of the Sybase IQ Reference Manual.
