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.

Farming out sysdevices' vdevno to increase total size limit

6 posts in Product Futures Discussion Last posting was on 2002-04-12 23:18:15.0Z
Anthony Mandic Posted on 2002-04-12 12:10:14.0Z
Message-ID: <3CB6CEA6.3670BD6D@start.com.au>
Date: Fri, 12 Apr 2002 22:10:14 +1000
From: Anthony Mandic <sp_am_block@start.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Farming out sysdevices' vdevno to increase total size limit
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 23
NNTP-Posting-Host: DC-24-181.bpb.bigpond.com 203.40.24.181
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:548
Article PK: 93715

As many of you should be aware, Sybase ASE stores the vdevno in the 8
most significant bits in the low and high fields of master..sysdevices.

This, unfortunately, means that only 256 devices are possible, putting
a cap on overall size of only a few terabytes (dependant of maximum
device size which is platform dependant).

While this should not be a hindrance to the average user, it does
become a problem when using ASE for VLDBs.

I, for one, could never fathom the reasoning behind this design but
I think its about time it was addressed. I see no reason why the
vdevno can't be placed into its own field of either a smallint
(for 64K of possible devices) or an int (for a phenomenal number).

Not only will this solve the current sizing cap but it will also
simplify the way calculations need to be done between sysusages and
sysdevices.

-am © 2002


Bret Halford Posted on 2002-04-12 15:00:18.0Z
Message-ID: <3CB6F682.C00345DA@sybase.com>
Date: Fri, 12 Apr 2002 09:00:18 -0600
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Farming out sysdevices' vdevno to increase total size limit
References: <3CB6CEA6.3670BD6D@start.com.au>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 26
NNTP-Posting-Host: 157.133.80.180
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:546
Article PK: 93721

Hi Anthony,

Feature request CR 65821 is open on this issue.

-bret

Anthony Mandic wrote:

> As many of you should be aware, Sybase ASE stores the vdevno in the 8
> most significant bits in the low and high fields of master..sysdevices.
>
> This, unfortunately, means that only 256 devices are possible, putting
> a cap on overall size of only a few terabytes (dependant of maximum
> device size which is platform dependant).
>
> While this should not be a hindrance to the average user, it does
> become a problem when using ASE for VLDBs.
>
> I, for one, could never fathom the reasoning behind this design but
> I think its about time it was addressed. I see no reason why the
> vdevno can't be placed into its own field of either a smallint
> (for 64K of possible devices) or an int (for a phenomenal number).
>
> Not only will this solve the current sizing cap but it will also
> simplify the way calculations need to be done between sysusages and
> sysdevices.
>
> -am © 2002


Anthony Mandic Posted on 2002-04-12 15:26:47.0Z
Message-ID: <3CB6FCB7.DA1D4A82@start.com.au>
Date: Sat, 13 Apr 2002 01:26:47 +1000
From: Anthony Mandic <sp_am_block@start.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Farming out sysdevices' vdevno to increase total size limit
References: <3CB6CEA6.3670BD6D@start.com.au> <3CB6F682.C00345DA@sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 5
NNTP-Posting-Host: DC-24-181.bpb.bigpond.com 203.40.24.181
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:545
Article PK: 93714


Bret Halford wrote:

> Feature request CR 65821 is open on this issue.

I knew I should have checked first. Any timeframe for this
or are there no firm plans yet?

-am © 2002


Sethu Posted on 2002-04-12 19:13:47.0Z
Message-ID: <3CB731EB.BB051517@sybase.com>
Date: Fri, 12 Apr 2002 12:13:47 -0700
From: Sethu <sethu@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Farming out sysdevices' vdevno to increase total size limit
References: <3CB6CEA6.3670BD6D@start.com.au> <3CB6F682.C00345DA@sybase.com> <3CB6FCB7.DA1D4A82@start.com.au>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 8
NNTP-Posting-Host: 10.22.91.118
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:542
Article PK: 93710

We are working on it.

Sethu

Anthony Mandic wrote:

> Bret Halford wrote:
>
> > Feature request CR 65821 is open on this issue.
>
> I knew I should have checked first. Any timeframe for this
> or are there no firm plans yet?
>
> -am © 2002


Anthony Mandic Posted on 2002-04-12 23:18:15.0Z
Message-ID: <3CB76B37.3C7B51FA@start.com.au>
Date: Sat, 13 Apr 2002 09:18:15 +1000
From: Anthony Mandic <sp_am_block@start.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Farming out sysdevices' vdevno to increase total size limit
References: <3CB6CEA6.3670BD6D@start.com.au> <3CB6F682.C00345DA@sybase.com> <3CB6FCB7.DA1D4A82@start.com.au> <3CB731EB.BB051517@sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 2
NNTP-Posting-Host: DC-24-99.bpb.bigpond.com 203.40.24.99
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:536
Article PK: 93703


Sethu wrote:
>
> We are working on it.

Excellent!

-am © 2002


Bret Halford Posted on 2002-04-12 18:17:21.0Z
Message-ID: <3CB724B1.7ECC2579@sybase.com>
Date: Fri, 12 Apr 2002 12:17:21 -0600
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Farming out sysdevices' vdevno to increase total size limit
References: <3CB6CEA6.3670BD6D@start.com.au> <3CB6F682.C00345DA@sybase.com> <3CB6FCB7.DA1D4A82@start.com.au>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 11
NNTP-Posting-Host: 157.133.80.180
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:543
Article PK: 93711


Anthony Mandic wrote:

> Bret Halford wrote:
>
> > Feature request CR 65821 is open on this issue.
>
> I knew I should have checked first. Any timeframe for this
> or are there no firm plans yet?
>
> -am © 2002

Hi Anthony,

I don't know of any timeframes for it (but then I don't tend to be
informed of things
happening at the planning stages). The CR was opened in 1995.

-bret