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.

Max memory that can be used by Sybase ASE 12.5 & 15

3 posts in General Discussion Last posting was on 2010-02-05 17:03:13.0Z
Satish Posted on 2010-02-03 13:53:01.0Z
Sender: 1fb8.4b697ef3.1804289383@sybase.com
From: Satish
Newsgroups: sybase.public.ase.general
Subject: Max memory that can be used by Sybase ASE 12.5 & 15
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b697fbd.1fd9.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Feb 2010 05:53:01 -0800
X-Trace: forums-1-dub 1265205181 10.22.241.41 (3 Feb 2010 05:53:01 -0800)
X-Original-Trace: 3 Feb 2010 05:53:01 -0800, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28939
Article PK: 78184

I want to know the max memory that can be used/allotted
by/to Sybase ASE 12.5 & 15 running on IBM Power5 series with
OS of AIX 5200.
Thnx for the info


Michael Peppler [Team Sybase] Posted on 2010-02-03 20:06:39.0Z
From: "Michael Peppler [Team Sybase]" <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: Max memory that can be used by Sybase ASE 12.5 & 15
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2010.02.03.20.06.38.530801@peppler.org>
Newsgroups: sybase.public.ase.general
References: <4b697fbd.1fd9.1681692777@sybase.com>
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: 3 Feb 2010 12:06:39 -0800
X-Trace: forums-1-dub 1265227599 10.22.241.152 (3 Feb 2010 12:06:39 -0800)
X-Original-Trace: 3 Feb 2010 12:06:39 -0800, vip152.sybase.com
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28940
Article PK: 78179


On Wed, 03 Feb 2010 05:53:01 -0800, Satish wrote:

> I want to know the max memory that can be used/allotted
> by/to Sybase ASE 12.5 & 15 running on IBM Power5 series with
> OS of AIX 5200.

I don't know the exact number - but in 64bit mode it's usually more than
you can fit in the machine (several hundreds of gigabytes, at the very
least)

Michael


Bret Halford Posted on 2010-02-05 17:03:13.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.7) Gecko/20100111 Thunderbird/3.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Max memory that can be used by Sybase ASE 12.5 & 15
References: <4b697fbd.1fd9.1681692777@sybase.com> <pan.2010.02.03.20.06.38.530801@peppler.org>
In-Reply-To: <pan.2010.02.03.20.06.38.530801@peppler.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b6c4f51$1@forums-1-dub>
Date: 5 Feb 2010 09:03:13 -0800
X-Trace: forums-1-dub 1265389393 10.22.241.152 (5 Feb 2010 09:03:13 -0800)
X-Original-Trace: 5 Feb 2010 09:03:13 -0800, vip152.sybase.com
Lines: 28
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28957
Article PK: 78198


On 2/3/2010 1:06 PM, Michael Peppler [Team Sybase] wrote:
> On Wed, 03 Feb 2010 05:53:01 -0800, Satish wrote:
>
>> I want to know the max memory that can be used/allotted
>> by/to Sybase ASE 12.5& 15 running on IBM Power5 series with
>> OS of AIX 5200.
>
> I don't know the exact number - but in 64bit mode it's usually more than
> you can fit in the machine (several hundreds of gigabytes, at the very
> least)
>
> Michael
>

This document is for versions 12.0 and 12.5; I don't recall there
is any change in 15.x until you get to cluster edition.

http://www.sybase.com/detail?id=1026830

But to summarize, most 64-bit platforms theoretically support 16
Etabytes (Etabyte = 1024 Petabytes). Testing has been done up to
256 GB.

Cluster Edition would change this in that each instance on the
cluster could have this much memory - so a 4-instance cluster
could (in theory) use up to 64 Etabytes.