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.

Change database page size

2 posts in General Discussion Last posting was on 2010-09-24 18:45:47.0Z
Manuel Espinoza <jmespinoza_no_spam Posted on 2010-09-24 18:33:12.0Z
From: Manuel Espinoza <jmespinoza_no_spam@seicom_dot_com_dot_mx>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.9.2.8) Gecko/20100802 Thunderbird/3.1.2
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Change database page size
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: <4c9ceee8$1@forums-1-dub>
Date: 24 Sep 2010 11:33:12 -0700
X-Trace: forums-1-dub 1285353192 10.22.241.152 (24 Sep 2010 11:33:12 -0700)
X-Original-Trace: 24 Sep 2010 11:33:12 -0700, vip152.sybase.com
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29603
Article PK: 78836

Hi,

I'd like to know if there is any command to change the "database page
size" in ASE 15.

I need to restore a DB which was using 2K page size, but on my laptop I
didn't realize I was installing a different page size parameter(4K) so I
can't restore a sample of that DB
(I'm a developer, not a DBA BTW)

Any directions?



thnks in advance!

Laptop env:
ASE 15.02
Windows XP pro


Actual Server:
ASE 15.03
Windows Server 2003 R2


"Mark A. Parsons" <iron_horse Posted on 2010-09-24 18:45:47.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Change database page size
References: <4c9ceee8$1@forums-1-dub>
In-Reply-To: <4c9ceee8$1@forums-1-dub>
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: <4c9cf1db$1@forums-1-dub>
Date: 24 Sep 2010 11:45:47 -0700
X-Trace: forums-1-dub 1285353947 10.22.241.152 (24 Sep 2010 11:45:47 -0700)
X-Original-Trace: 24 Sep 2010 11:45:47 -0700, vip152.sybase.com
Lines: 31
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29604
Article PK: 78834

There is no way to *change* a dataserver's page size ... you have to build a new dataserver.

For your case you could just create a second dataserver on your PC that uses the desired page size.

Manuel Espinoza wrote:
> Hi,
>
> I'd like to know if there is any command to change the "database page
> size" in ASE 15.
>
> I need to restore a DB which was using 2K page size, but on my laptop I
> didn't realize I was installing a different page size parameter(4K) so I
> can't restore a sample of that DB
> (I'm a developer, not a DBA BTW)
>
> Any directions?
>
>
>
> thnks in advance!
>
> Laptop env:
> ASE 15.02
> Windows XP pro
>
>
> Actual Server:
> ASE 15.03
> Windows Server 2003 R2