• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4884
  • Last Modified:

Easy way of changing page size

I have very little experience with Sybase. We need a database with 8K page size. but our server is already build with 2k page and there are over twenty existing databases running on the server.

I need options on what's the easiest way to get my new database with 8K page size.

Thanks!
0
kennethxu
Asked:
kennethxu
  • 3
  • 2
2 Solutions
 
namasi_navaretnamCommented:
0
 
kennethxuAuthor Commented:
I would apprecate if you can elaborate it. I'm creating a new database. why do I need to migrate?
0
 
namasi_navaretnamCommented:
Well, I do not have 12.5.1 yet. So I am not sure if you have databases that use different pagesizes in the same server?
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
kennethxuAuthor Commented:
all other database uses 2k pages, they are updated from old version. I need a new database with 8K page size on the same server. reason being:
1. I need to store records longer then 2K bytes.
2. I'm not sure if the index limit has anything to do withit (I have another Q for that);

So I need to know what's the easiest way of getting the new database on the server.
I appreciate your help so far namasi.

anybody have 12.5 please comment.
0
 
alpmoonCommented:
You need to create a new server rather than just a database in existing server:
"The logical page size is a server-wide setting; you cannot have databases with varying size logical pages within the same server. All tables are appropriately sized so that the row size does not exceed the current page size of the server. That is, rows cannot span multiple pages."

Read details at:

http://sybooks.sybase.com/onlinebooks/group-as/asg1251e/utility/@Generic__BookView;pt=784?DwebQuery=Building+a+new+master+device
0
 
kennethxuAuthor Commented:
thanks for the help. alpmoon, any idea of this one:
http://www.experts-exchange.com/Databases/Sybase/Q_20942982.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now