How to find if instance is cluster or non-cluster

[Virendra]

I need to figure out programmatically if an instance is a cluster or
non-cluster. Also, if it is a cluster what are nodes and associated
cluster directories in the instance. All I know is the instance name.

I am looking for this information for MSSQL, Oracle, DB2 and Sybase
databases.

Thanks in advance for any help.

[DA Morgan]

Virendra wrote:

I need to figure out programmatically if an instance is a cluster or
non-cluster. Also, if it is a cluster what are nodes and associated
cluster directories in the instance. All I know is the instance name.

I am looking for this information for MSSQL, Oracle, DB2 and Sybase
databases.

Thanks in advance for any help.

I'm not sure why you would ask about Oracle here but as you have, in
SQL*Plus:

set serveroutput on

DECLARE
inst_tab dbms_utility.instance_table;
inst_cnt NUMBER;
BEGIN
IF dbms_utility.is_cluster_database THEN
dbms_utility.active_instances(inst_tab, inst_cnt);
dbms_output.put_line('-' || inst_tab.FIRST);
dbms_output.put_line(TO_CHAR(inst_cnt));
ELSE
dbms_output.put_line('Not A Clustered Database');
END IF;
END;
/
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
da******@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

[Dan Guzman]

I am looking for this information for MSSQL, Oracle, DB2 and Sybase

databases.

The result of the following query will be non-empty if the Microsoft SQL
Server instance is clustered.

SELECT * FROM sys.dm_os_cluster_nodes;

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Virendra" <vi********@hotmail.comwrote in message
news:e5**********************************@t54g2000 hsg.googlegroups.com...

>I need to figure out programmatically if an instance is a cluster or
non-cluster. Also, if it is a cluster what are nodes and associated
cluster directories in the instance. All I know is the instance name.

I am looking for this information for MSSQL, Oracle, DB2 and Sybase
databases.

Thanks in advance for any help.

[Virendra]

On Jun 7, 10:50*am, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.netwrote:

I am looking for this information for MSSQL, Oracle, DB2 and Sybase
databases.

The result of the following query will be non-empty if the Microsoft SQL
Server instance is clustered.

SELECT * FROM sys.dm_os_cluster_nodes;

--
Hope this helps.

Dan Guzman
SQL Server MVPhttp://weblogs.sqlteam.com/dang/

"Virendra" <[e-mail] in message

news:e5**********************************@t54g2000 hsg.googlegroups.com...

I need to figure out programmatically if an instance is a cluster or
non-cluster. Also, if it is a cluster what are nodes and associated
cluster directories in the instance. All I know is the instance name.

I am looking for this information for MSSQL, Oracle, DB2 and Sybase
databases.

Thanks in advance for any help.- Hide quoted text -

- Show quoted text -

Thanks both of you.

I noticed that sys.dm_os_cluster_nodes table/view does not exist for
SQL 2000. I believe SQL2000 has clustering support.

Thanks again.

[Dan Guzman]

I noticed that sys.dm_os_cluster_nodes table/view does not exist for

SQL 2000. I believe SQL2000 has clustering support.

Yes SQL 2000 has clustering support. Another method to detect clustering is
with SERVERPROPERTY:

SELECT SERVERPROPERTY('IsClustered')

This will return 1 if clustered (otherwise 0) and can be used with SQL 2000
and later versions.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Virendra" <vi********@hotmail.comwrote in message
news:93**********************************@x41g2000 hsb.googlegroups.com...
On Jun 7, 10:50 am, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.netwrote:

I am looking for this information for MSSQL, Oracle, DB2 and Sybase
databases.

The result of the following query will be non-empty if the Microsoft SQL
Server instance is clustered.

SELECT * FROM sys.dm_os_cluster_nodes;

--
Hope this helps.

Dan Guzman
SQL Server MVPhttp://weblogs.sqlteam.com/dang/

"Virendra" <[e-mail] in message

news:e5**********************************@t54g2000 hsg.googlegroups.com...

I need to figure out programmatically if an instance is a cluster or
non-cluster. Also, if it is a cluster what are nodes and associated
cluster directories in the instance. All I know is the instance name.

I am looking for this information for MSSQL, Oracle, DB2 and Sybase
databases.

Thanks in advance for any help.- Hide quoted text -

- Show quoted text -

Thanks both of you.

I noticed that sys.dm_os_cluster_nodes table/view does not exist for
SQL 2000. I believe SQL2000 has clustering support.

Thanks again.

[Plamen Ratchev]

In addition to Dan's comments, it is possible to enumerate SQL Server
instances and get information if the instance is clustered via using
ADO.NET:
http://msdn.microsoft.com/en-us/library/a6t1z9x2.aspx

HTH,

Plamen Ratchev
http://www.SQLStudio.com