Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - 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 System Tables

3 posts in Cluster Last posting was on 2009-10-13 14:57:41.0Z
Jamis Posted on 2009-10-12 15:45:12.0Z
Sender: 6614.4ad346f0.1804289383@sybase.com
From: Jamis
Newsgroups: sybase.public.ase.cluster
Subject: Clustered ASE System Tables
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ad34f08.66e3.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Oct 2009 08:45:12 -0700
X-Trace: forums-1-dub 1255362312 10.22.241.41 (12 Oct 2009 08:45:12 -0700)
X-Original-Trace: 12 Oct 2009 08:45:12 -0700, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:181
Article PK: 48463

Hi,

Are there published system table schema for the clustered
edition? For example, what table(s) is/are affected when
one issues an sp_cluster command to add a logical cluster?

Thanks in advance


Rob V [ Sybase ] Posted on 2009-10-12 16:06:19.0Z
Reply-To: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.cluster
References: <4ad34f08.66e3.1681692777@sybase.com>
Subject: Re: Clustered ASE System Tables
Lines: 37
Organization: Sypron BV / TeamSybase / Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ad353fb$1@forums-1-dub>
Date: 12 Oct 2009 09:06:19 -0700
X-Trace: forums-1-dub 1255363579 10.22.241.152 (12 Oct 2009 09:06:19 -0700)
X-Original-Trace: 12 Oct 2009 09:06:19 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:182
Article PK: 48461

There will be a system tables poster for ASE 15.5 (expected early 2010) that
includes the system table information for ASE CE.
The CE-specific aspects are mostly just the sysinstances tables, as well as
a column 'instanceid' in a number of existing tables. The current CE
documentation describes these.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

<Jamis> wrote in message news:4ad34f08.66e3.1681692777@sybase.com...
> Hi,
>
> Are there published system table schema for the clustered
> edition? For example, what table(s) is/are affected when
> one issues an sp_cluster command to add a logical cluster?
>
> Thanks in advance


J Posted on 2009-10-13 14:57:41.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.cluster
Subject: Re: Clustered ASE System Tables
Reply-To: J@bogusemailAddress.com
Message-ID: <4ad49539.848439@forums.sybase.com>
References: <4ad34f08.66e3.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 13 Oct 2009 07:57:41 -0700
X-Trace: forums-1-dub 1255445861 10.22.241.152 (13 Oct 2009 07:57:41 -0700)
X-Original-Trace: 13 Oct 2009 07:57:41 -0700, vip152.sybase.com
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:183
Article PK: 48462

On 12 Oct 2009 08:45:12 -0700, Jamis wrote:

In addition to Rob's comments, the source for the sp_cluster sproc is
also in the installmaster script for your viewing of the details.

Jay

>Hi,
>
>Are there published system table schema for the clustered
>edition? For example, what table(s) is/are affected when
>one issues an sp_cluster command to add a logical cluster?
>
>Thanks in advance