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.

Creating customised profiles

2 posts in Cluster Last posting was on 2009-04-17 08:30:02.0Z
M Paul Posted on 2009-04-16 22:18:02.0Z
From: M Paul
Newsgroups: sybase.public.ase.cluster
Subject: Creating customised profiles
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <>
Date: 16 Apr 2009 15:18:02 -0700
X-Trace: forums-1-dub 1239920282 (16 Apr 2009 15:18:02 -0700)
X-Original-Trace: 16 Apr 2009 15:18:02 -0700,
Lines: 3
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:131
Article PK: 48413

Has anybody created a customised profile for a high oltp
environment with automatic failovers and also round robin
routing baed on logins.

Rob V [Sybase] Posted on 2009-04-17 08:30:02.0Z
Reply-To: "Rob V [Sybase]" <>
From: "Rob V [Sybase]" <>
Newsgroups: sybase.public.ase.cluster
References: <>
Subject: Re: Creating customised profiles
Lines: 42
Organization: Sypron BV / TeamSybase / Sybase Inc
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
Message-ID: <49e83e0a$1@forums-1-dub>
Date: 17 Apr 2009 01:30:02 -0700
X-Trace: forums-1-dub 1239957002 (17 Apr 2009 01:30:02 -0700)
X-Original-Trace: 17 Apr 2009 01:30:02 -0700,
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:133
Article PK: 48416

Basically this means that you need to weigh the 'user connection' attribute
quite heavily compared to the other ones. That will not give you round-robin
distribution though, but a sort-of even distribution of user connections
over the different instances (which is not the same, though it may often
work out in a similar way). Of course, your logical lcuster definitions will
determine which instances can participate.
A general remark: a typical downside of this approach for OLTP is that you
may lose performance becuase the different instances are writing to the same
transaction log concurrently, and this will result in additional
coordination messaging happenng between the instances. Performance might be
better if you keep all those OLTP sessions together in one instance.

The HA comes for free with anything you do, provided you let the client app
use the HA conenction attribute (e.g. 'isql -Q').


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
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666

<M Paul> wrote in message
> Has anybody created a customised profile for a high oltp
> environment with automatic failovers and also round robin
> routing baed on logins.