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.

how to increase paging in sybase 8 and 9 without copying data from one db to another

3 posts in General Discussion Last posting was on 2005-09-08 03:17:45.0Z
Patricia Ramírez Posted on 2005-08-17 16:20:39.0Z
Reply-To: "Patricia Ramírez" <pramirez@innova.com.mx>
From: "Patricia Ramírez" <pramirez@innova.com.mx>
Newsgroups: ianywhere.public.general
Subject: how to increase paging in sybase 8 and 9 without copying data from one db to another
Lines: 15
Organization: Innova
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: server.innova.com.mx
X-Original-NNTP-Posting-Host: server.innova.com.mx
Message-ID: <430363d7$1@forums-1-dub>
Date: 17 Aug 2005 09:20:39 -0700
X-Trace: forums-1-dub 1124295639 200.76.225.51 (17 Aug 2005 09:20:39 -0700)
X-Original-Trace: 17 Aug 2005 09:20:39 -0700, server.innova.com.mx
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4699
Article PK: 8495

Sybase 5.5

Hi there,
We need to increase pages in data bases created initially with 1024
(default) to 8196. The way we are doing it right now is creating a new date
base with 8196 pages and then copying the data into it. Is there any way to
do it without creating a new one?

--
Patricia Ramírez Mendoza
Innova Desarrollo
6865 53-44-53
servicio@innova.com.mx


Greg Fenton Posted on 2005-08-17 16:23:43.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: how to increase paging in sybase 8 and 9 without copying data from one db to another
References: <430363d7$1@forums-1-dub>
In-Reply-To: <430363d7$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: gfenton-t30.sybase.com
X-Original-NNTP-Posting-Host: gfenton-t30.sybase.com
Message-ID: <4303648f@forums-1-dub>
Date: 17 Aug 2005 09:23:43 -0700
X-Trace: forums-1-dub 1124295823 10.25.98.144 (17 Aug 2005 09:23:43 -0700)
X-Original-Trace: 17 Aug 2005 09:23:43 -0700, gfenton-t30.sybase.com
Lines: 21
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4700
Article PK: 8494


Patricia Ramírez wrote:
> We need to increase pages in data bases created initially with 1024
> (default) to 8196. The way we are doing it right now is creating a new date
> base with 8196 pages and then copying the data into it. Is there any way to
> do it without creating a new one?

No, page size is established at database file creation time. The only
way to change page size of the file is to create a new file.

BTW: is there a particular reason you are not using the (highly
recommended) 4k page size? Have you done measurements that show that an
8k page size offers you better performance?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


"Leo Tohill" <lit Posted on 2005-09-08 03:17:45.0Z
From: "Leo Tohill" <lit@spammersgoaway_cbord.com>
Newsgroups: ianywhere.public.general
References: <430363d7$1@forums-1-dub>
Subject: Re: how to increase paging in sybase 8 and 9 without copying data from one db to another
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Response
X-Original-NNTP-Posting-Host: cpe-24-59-97-98.twcny.res.rr.com
Message-ID: <431fad55$1@forums-2-dub>
X-Original-Trace: 7 Sep 2005 20:17:41 -0700, cpe-24-59-97-98.twcny.res.rr.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 7 Sep 2005 20:17:42 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 7 Sep 2005 20:17:45 -0700
X-Trace: forums-1-dub 1126149465 10.22.108.75 (7 Sep 2005 20:17:45 -0700)
X-Original-Trace: 7 Sep 2005 20:17:45 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4756
Article PK: 8526

Yes, you need to create a new database. But if you are copying by any means
other than rebuilding, you are probably doing it the hard way. You could
instead create a batch file that contains three steps:

1. dbunload
2. dbbinit with -p 8192
3. dbisql -read reload.sql

And I agree with Greg, 8192 is an unusually large page size and is not
usually the best choice.

"Patricia Ramírez" <pramirez@innova.com.mx> wrote in message
news:430363d7$1@forums-1-dub...
> Sybase 5.5
>
> Hi there,
> We need to increase pages in data bases created initially with 1024
> (default) to 8196. The way we are doing it right now is creating a new
> date base with 8196 pages and then copying the data into it. Is there any
> way to do it without creating a new one?
>
> --
> Patricia Ramírez Mendoza
> Innova Desarrollo
> 6865 53-44-53
> servicio@innova.com.mx
>