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.

Maximum number of groups in an ASE db?

2 posts in General Discussion Last posting was on 2013-03-21 08:10:57.0Z
Jean-Pierre Dareys Posted on 2013-03-21 01:42:46.0Z
Sender: 4efc.514a656b.1804289383@sybase.com
From: Jean-Pierre Dareys
Newsgroups: sybase.public.ase.general
Subject: Maximum number of groups in an ASE db?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <514a6596.4f06.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 20 Mar 2013 17:42:46 -0800
X-Trace: forums-1-dub 1363830166 172.20.134.41 (20 Mar 2013 17:42:46 -0800)
X-Original-Trace: 20 Mar 2013 17:42:46 -0800, 172.20.134.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31732
Article PK: 1308535

Greetings,

Old question and perhaps irrelevant, but does anyone know
the maximum number of groups that can be created in a
database?

32 rings a bell, but from the stone age. It must have
changed, and I can´t find it in the documentation.

Regards,

Jean-Pierre


Rob V Posted on 2013-03-21 08:10:57.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/20130307 Thunderbird/17.0.4
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Maximum number of groups in an ASE db?
References: <514a6596.4f06.1681692777@sybase.com>
In-Reply-To: <514a6596.4f06.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <514ac091$1@forums-1-dub>
Date: 21 Mar 2013 00:10:57 -0800
X-Trace: forums-1-dub 1363853457 172.20.134.152 (21 Mar 2013 00:10:57 -0800)
X-Original-Trace: 21 Mar 2013 00:10:57 -0800, vip152.sybase.com
Lines: 46
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31733
Article PK: 1308539


On 21-Mar-2013 02:42, Jean-Pierre Dareys wrote:
> Greetings,
>
> Old question and perhaps irrelevant, but does anyone know
> the maximum number of groups that can be created in a
> database?
>
> 32 rings a bell, but from the stone age. It must have
> changed, and I can?t find it in the documentation.
>
> Regards,
>
> Jean-Pierre
>

The only limits are the values of @@mingroupid and @@maxgroupid. In
other words, about a million groups are possible.



******
Please note that these newgroups will go offline soon.
See
http://nntp-archive.sybase.com/nntp-archive/action/article/%3C513726e2%40forums-1-dub%3E
for more details about the new location of the forums
******


--
HTH,

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

Certified Professional DBA for Sybase ASE, IQ, Replication Server

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

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------