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.

Is there a maximun/recommend Max database size in ASE15.5?

4 posts in General Discussion Last posting was on 2010-08-19 04:46:18.0Z
Tom Posted on 2010-08-18 19:04:14.0Z
Sender: 4862.4c6c294e.1804289383@sybase.com
From: tom
Newsgroups: sybase.public.ase.general
Subject: Is there a maximun/recommend Max database size in ASE15.5?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c6c2eae.48eb.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Aug 2010 12:04:14 -0700
X-Trace: forums-1-dub 1282158254 10.22.241.41 (18 Aug 2010 12:04:14 -0700)
X-Original-Trace: 18 Aug 2010 12:04:14 -0700, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29472
Article PK: 78703

I am planning to upgrade from ASE 15.02 to 15.5. My upgrade
will actually be a new install of 15.5, create the db's and
bcp tables in from 15.02 environment. I am changing the
page size and re-arranging db devices. I current have a db
that is 45 gig.
This 45 gig is spread over about 30 2 gig or less devices.
I was thinking of create fewer but much large devices
These devices are actually on a Solaris disk array. Anyone
think of any plus or minus's for doing this. Any
recomendataion on device max size.
Thanks.


Tom Posted on 2010-08-18 19:07:23.0Z
Sender: 4862.4c6c294e.1804289383@sybase.com
From: tom
Newsgroups: sybase.public.ase.general
Subject: Re: Is there a maximun/recommend Max database device size in ASE15.5?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c6c2f6b.4903.1681692777@sybase.com>
References: <4c6c2eae.48eb.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Aug 2010 12:07:23 -0700
X-Trace: forums-1-dub 1282158443 10.22.241.41 (18 Aug 2010 12:07:23 -0700)
X-Original-Trace: 18 Aug 2010 12:07:23 -0700, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29473
Article PK: 78704

I should have said Max database device size.

> I am planning to upgrade from ASE 15.02 to 15.5. My
> upgrade will actually be a new install of 15.5, create the
> db's and bcp tables in from 15.02 environment. I am
> changing the page size and re-arranging db devices. I
> current have a db that is 45 gig.
> This 45 gig is spread over about 30 2 gig or less devices.
> I was thinking of create fewer but much large devices
> These devices are actually on a Solaris disk array.
> Anyone think of any plus or minus's for doing this. Any
> recomendataion on device max size.
> Thanks.


ET Posted on 2010-08-18 21:22:30.0Z
From: ET <dbccjob@gmail.Com>
Reply-To: ET
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.2.8) Gecko/20100802 Thunderbird/3.1.2
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Is there a maximun/recommend Max database device size in ASE15.5?
References: <4c6c2eae.48eb.1681692777@sybase.com> <4c6c2f6b.4903.1681692777@sybase.com>
In-Reply-To: <4c6c2f6b.4903.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: <4c6c4f16$1@forums-1-dub>
Date: 18 Aug 2010 14:22:30 -0700
X-Trace: forums-1-dub 1282166550 10.22.241.152 (18 Aug 2010 14:22:30 -0700)
X-Original-Trace: 18 Aug 2010 14:22:30 -0700, vip152.sybase.com
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29474
Article PK: 78705

Max device size is 4 TB. I would go for bigger devices too although it
is always hard to say if many devices would help more than a few.
I would say it depends on your disk array layout and your possibility to
create your devices on different volumes and place 'hot' database
objects, in order to spread I/O. Check your OS doc to see the max
supported file size.

Emmanuel


Le 18/08/2010 21:07, tom a écrit :

> I should have said Max database device size.
>> I am planning to upgrade from ASE 15.02 to 15.5. My
>> upgrade will actually be a new install of 15.5, create the
>> db's and bcp tables in from 15.02 environment. I am
>> changing the page size and re-arranging db devices. I
>> current have a db that is 45 gig.
>> This 45 gig is spread over about 30 2 gig or less devices.
>> I was thinking of create fewer but much large devices
>> These devices are actually on a Solaris disk array.
>> Anyone think of any plus or minus's for doing this. Any
>> recomendataion on device max size.
>> Thanks.


Michael Peppler [Team Sybase] Posted on 2010-08-19 04:46:18.0Z
From: "Michael Peppler [Team Sybase]" <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: Is there a maximun/recommend Max database device size in ASE15.5?
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2010.08.19.04.46.15.720030@peppler.org>
Newsgroups: sybase.public.ase.general
References: <4c6c2eae.48eb.1681692777@sybase.com> <4c6c2f6b.4903.1681692777@sybase.com> <4c6c4f16$1@forums-1-dub>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 18 Aug 2010 21:46:18 -0700
X-Trace: forums-1-dub 1282193178 10.22.241.152 (18 Aug 2010 21:46:18 -0700)
X-Original-Trace: 18 Aug 2010 21:46:18 -0700, vip152.sybase.com
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29475
Article PK: 78708

It also depends on the actual physical layout of the IO subsystem, number
of channels, number of disks, etc.

I've tended to go to 16GB for the devices for databases that are in the
50-100GB size range.

Michael

On Wed, 18 Aug 2010 14:22:30 -0700, ET wrote:

> Max device size is 4 TB. I would go for bigger devices too although it
> is always hard to say if many devices would help more than a few.
> I would say it depends on your disk array layout and your possibility to
> create your devices on different volumes and place 'hot' database
> objects, in order to spread I/O. Check your OS doc to see the max
> supported file size.
>
> Emmanuel
>
>
> Le 18/08/2010 21:07, tom a écrit :
>> I should have said Max database device size.
>>> I am planning to upgrade from ASE 15.02 to 15.5. My
>>> upgrade will actually be a new install of 15.5, create the
>>> db's and bcp tables in from 15.02 environment. I am
>>> changing the page size and re-arranging db devices. I
>>> current have a db that is 45 gig.
>>> This 45 gig is spread over about 30 2 gig or less devices.
>>> I was thinking of create fewer but much large devices
>>> These devices are actually on a Solaris disk array.
>>> Anyone think of any plus or minus's for doing this. Any
>>> recomendataion on device max size.
>>> Thanks.