Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Clustered ASE?

2 posts in General Discussion Last posting was on 2009-11-19 16:18:42.0Z
rick_806 Posted on 2009-11-18 23:02:32.0Z
From: rick_806
Newsgroups: sybase.public.ase.general
Subject: Clustered ASE?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <>
Date: 18 Nov 2009 15:02:32 -0800
X-Trace: forums-1-dub 1258585352 (18 Nov 2009 15:02:32 -0800)
X-Original-Trace: 18 Nov 2009 15:02:32 -0800,
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28649
Article PK: 77889


How do you know if a ASE server is part of a cluster?


J Posted on 2009-11-19 16:18:42.0Z
From: (J)
Newsgroups: sybase.public.ase.general
Subject: Re: Clustered ASE?
Message-ID: <>
References: <>
X-Newsreader: Forte Free Agent 1.21/32.243
Date: 19 Nov 2009 08:18:42 -0800
X-Trace: forums-1-dub 1258647522 (19 Nov 2009 08:18:42 -0800)
X-Original-Trace: 19 Nov 2009 08:18:42 -0800,
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28652
Article PK: 77896

On 18 Nov 2009 15:02:32 -0800, rick_806 wrote:

What kind of cluster are you talking about? ASE has SMP and CE
(Clustered Edition) products in the current 15.0.3 offerings. Also ASE
has an HA option which requires cluster hardware.

the sql command "select @@version" is a good start as others can tell
you capabilities based upon the product version. You may need more
command to see what is configured?

"select @@clustermode" -> "shared disk cluster" for Cluster Edition
-> "smp" for SMP

sp_configure "HA" should show the clustering on the SMP product.


>How do you know if a ASE server is part of a cluster?