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.

@@pagesize vs @@maxpagesize

4 posts in General Discussion Last posting was on 2011-08-06 12:02:06.0Z
Mark Gearhart Posted on 2011-07-28 20:35:33.0Z
Sender: 3dc9.4e31c41b.1804289383@sybase.com
From: Mark Gearhart
Newsgroups: sybase.public.ase.general
Subject: @@pagesize vs @@maxpagesize
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e31c815.3fc3.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Jul 2011 13:35:33 -0700
X-Trace: forums-1-dub 1311885333 10.22.241.41 (28 Jul 2011 13:35:33 -0700)
X-Original-Trace: 28 Jul 2011 13:35:33 -0700, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30397
Article PK: 72576

We created an 8K server, and sure enough @@pagesize=2k and
@@maxpagesize=8k just as expected.

But, I don't understand. What does @@pagesize=2k actually
mean? The documentation says "virtual page size". What does
that mean for an 8K server?

Thanks,
Mark Gearhart


Bret Halford Posted on 2011-07-28 21:40:53.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110616 Thunderbird/3.1.11
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: @@pagesize vs @@maxpagesize
References: <4e31c815.3fc3.1681692777@sybase.com>
In-Reply-To: <4e31c815.3fc3.1681692777@sybase.com>
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: <4e31d765@forums-1-dub>
Date: 28 Jul 2011 14:40:53 -0700
X-Trace: forums-1-dub 1311889253 10.22.241.152 (28 Jul 2011 14:40:53 -0700)
X-Original-Trace: 28 Jul 2011 14:40:53 -0700, vip152.sybase.com
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30399
Article PK: 72578


On 7/28/2011 2:35 PM, Mark Gearhart wrote:
> We created an 8K server, and sure enough @@pagesize=2k and
> @@maxpagesize=8k just as expected.
>
> But, I don't understand. What does @@pagesize=2k actually
> mean? The documentation says "virtual page size". What does
> that mean for an 8K server?
>
> Thanks,
> Mark Gearhart

Not much beyond the fact that an 8K logical page consists
of 4 2k virtual pages. Note the wording in the docs for
http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc01165.1550/doc/html


"Very Large Storage Support
...The new architecture allows you to create up to 2,147,483,647 disk
devices, each of which can be as large as 2,147,483,648 2K blocks or 4
terabytes."


Rob V [ Sybase ] Posted on 2011-07-28 21:45:52.0Z
From: "Rob V [ Sybase ]" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110616 Lightning/1.0b2 Thunderbird/3.1.11
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: @@pagesize vs @@maxpagesize
References: <4e31c815.3fc3.1681692777@sybase.com>
In-Reply-To: <4e31c815.3fc3.1681692777@sybase.com>
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: <4e31d890$1@forums-1-dub>
Date: 28 Jul 2011 14:45:52 -0700
X-Trace: forums-1-dub 1311889552 10.22.241.152 (28 Jul 2011 14:45:52 -0700)
X-Original-Trace: 28 Jul 2011 14:45:52 -0700, vip152.sybase.com
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30401
Article PK: 72580


On 28-Jul-2011 22:35, Mark Gearhart wrote:
> We created an 8K server, and sure enough @@pagesize=2k and
> @@maxpagesize=8k just as expected.
>
> But, I don't understand. What does @@pagesize=2k actually
> mean? The documentation says "virtual page size". What does
> that mean for an 8K server?
>
> Thanks,
> Mark Gearhart

I think @@pagesize doesn't really have any meaning anymore today,it's
kind of a remnant of a distant past. I recall that in the days when
Sybase SQL Server ran on Stratus, @@pagesize was 4KB on Stratus. But on
all other platforms, it has always been 2KB until ASE 12.5 came along.

HTH,

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 www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"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
-----------------------------------------------------------------


sybanva Posted on 2011-08-06 12:02:06.0Z
Sender: 76ce.4e3d2c54.1804289383@sybase.com
From: sybanva
Newsgroups: sybase.public.ase.general
Subject: Re: @@pagesize vs @@maxpagesize
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e3d2d3e.76fa.1681692777@sybase.com>
References: <4e31d890$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Aug 2011 05:02:06 -0700
X-Trace: forums-1-dub 1312632126 10.22.241.41 (6 Aug 2011 05:02:06 -0700)
X-Original-Trace: 6 Aug 2011 05:02:06 -0700, 10.22.241.41
Lines: 52
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30450
Article PK: 72630

All,

Is "page size" memory allocation page size as per below
sybook note?
Secondthing , Is ASE using @@pagesize (i.e. 2k) for logical
i/o and @@maxpagesize for physical i/o?

The logical page size is not the same as the memory
allocation page size. Memory allocation page size is always
2K, regardless of logical page size, which can be 2, 4, 8,
or 16K. Most memory-related configuration parameters use
units of 2K for their memory page size.

> On 28-Jul-2011 22:35, Mark Gearhart wrote:
> > We created an 8K server, and sure enough @@pagesize=2k
> > and @@maxpagesize=8k just as expected.
> >
> > But, I don't understand. What does @@pagesize=2k
> > actually mean? The documentation says "virtual page
> > size". What does that mean for an 8K server?
> >
> > Thanks,
> > Mark Gearhart
>
> I think @@pagesize doesn't really have any meaning anymore
> today,it's kind of a remnant of a distant past. I recall
> that in the days when Sybase SQL Server ran on Stratus,
> @@pagesize was 4KB on Stratus. But on all other platforms
> , it has always been 2KB until ASE 12.5 came along.
>
> HTH,
>
> 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
> www.sypron.nl/shop): "Tips, Tricks& Recipes for Sybase
> ASE" (ASE 15 edition) "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
> ----------------------------------------------------------
> -------
>