We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Easy way of changing page size

kennethxu
kennethxu asked
on
Medium Priority
5,134 Views
Last Modified: 2007-12-19
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!
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I would apprecate if you can elaborate it. I'm creating a new database. why do I need to migrate?
CERTIFIED EXPERT

Commented:
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?

Author

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.
Sybase DBA
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
thanks for the help. alpmoon, any idea of this one:
https://www.experts-exchange.com/Databases/Sybase/Q_20942982.html
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.