Adaptive Server Clusters Users Guide

Using sp_showplan

Add this text to the "Additional Topics" chapter:

You cannot use sp_showplan across multiple nodes of a shared-disk cluster. It is specific to a single connection to a node.

Setting cluster redundancy level configuration parameter

Add this text to "Enabling multiple simultaneous failover" in the "Instance Recovery" chapter:

For the cluster to start, the value of the cluster redundancy level configuration parameter must be at least one less than the value of maximum number of instances as specified in cluster.cfg or the quorum file. Thus, the cluster cannot start if you set either of these:

The value of maximum number of instances to a value that is equal to or less than the value of cluster redundancy level.
The value of cluster redundancy level to a value equal to or greater than the value of maximum number of instances.

Upgrading from Adaptive Server 12.5.4 or earlier versions

Add this text to the "Upgrade" chapter:

Note: When upgrading a 12.5.4 or earlier database to the Cluster Edition, make sure you execute all steps in the upgrade sequence from the same node. That is, you must load the database and execute online database on the same node.

Changing the character set or sort order with the Veritas Cluster Server (VCS)

Add this text to the "Using the Cluster Edition with the Veritas Cluster Server" chapter:

To change the character set or sort order:

Use VCS commands to shut down Adaptive Server.
Change the membership mode to native:
>qrmutil -Q quorum_file --membership-mode="native"
Restart a single instance in the cluster either manually or using sybcluster.
To change the character set, run charset. For example:
>$SYBASE/ASE-15_0/bin/charset -Usa -P nocase.srt utf8
To change the sort order, reset the default sortorder id configuration parameter. For example:
>isql -Usa -P 1>sp_configure 'default sortorder id', 101, 'utf8'
From isql, shut down the cluster.
Restart an instance. Adaptive Server reconfigures the character set and sort order, and shuts down.
Change the membership mode back to VCS:
>qrmutil -Q quorum_file - -membership-mode='vcs'
Use VCs commands to restart the cluster.

Changing the number of user connections with the Veritas Cluster Server (VCS)

Add this text to the "Using the Cluster Edition with the Veritas Cluster Server" chapter:

When you increase the number of user connections, you must also increase the file descriptor limit. However, Veritas running over VCS does not propogate file descriptor limit changes from one user session to another.

For example, if you change the file descriptor limits in your current session using: ulimit -n 8194, subsequent UNIX sessions continue to use the default setting (1024) for the number of file descriptors. Consequently, while the Veritas VCS manages the cluster and brings instances online, it logs in to the Linux operating system as the user "sybase" (starting a new UNIX session), and uses the default value for the number of file descriptors.

To ensure that all sybase user sessions have the correct file descriptor limit, add these lines to /etc/security/limits.conf:

sybase hard nofile 8096

sybase soft nofile 8096