Changed Functionality in This Version

This section lists the changed functionality of Adaptive Server.

For complete information about added functionality, see the “System Changes” chapter of the Users Guide to Clusters.

Support for db2 Server Class

Adaptive Server does not support server class db2. To use db2, migrate your db2 server class to direct_connect class.

Using sp_configure

When using sp_configure with the Cluster Edition:

Configure an instance-specific value only for the instance to which you are currently connected.
Configuration options that are “strictly cluster-wide”—that is, the small group of configuration options that are the same on all instances—cannot be made instance-specific.
Reconfiguring a cluster-wide value does not overwrite an instance-specific configuration.

Accessing temporary objects shareable across sessions

Applications created since Adaptive Server version 12.5.0.3 may create shareable tables in user-created temporary databases. To enable existing applications to continue to work with the Cluster Edition, drop user-created temporary databases that include these shareable tables, and re-create them as as global temporary databases with the same names.

Managing assigned temporary database inside an application

The default temporary database assigned to a session is a local, temporary, instance-specific database. It is not the system tempdb (with a dbid of 2). After upgrading from a nonclustered environment, you may need to modify applications that previously assumed the default temporary database as system tempdb (with a dbid of 2) in their actions, so that these actions are now applied to the assigned local temporary database in the Cluster Edition.

For example, in a nonclustered environment, an application truncates the log of the default temporary database when you execute:

dump tran tempdb with truncate_only

In the Cluster Edition, modify the application to truncate the log of the default temporary database:

declare @tempdbname varchar(30)
select @tempdbname = db_name(@@tempdbid)
dump tran @tempdbname with truncate_only