Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I have an existing database with 1 kb page size i want to increase that to 16kb and increase cache to take advantage of my memory for best performance. sybase documentations said you can't change page size of database but you can create new empty database with preferred page size, so how can i move my data to from old db to new database with big page size؟؟

share|improve this question
What performance problems are you facing? Locks? How much data are you dealing with? – Phil Nov 13 '12 at 1:22
the system design is so bad so bad , when user make a search for a name it may takes 2 minutes to finish and it hangs up(not responding) during this period, another problem that happen frequently that connected users stay connecting and logged off users cannot login with error message "cann't find database server", this is solved by only one thing is to restart engine or the whole server,the problems happen especially when there are a lot of clients at the same time(about 30 PCs at average) – Ahmed safan Nov 13 '12 at 6:50
I'm not certain I understand how changing the page size of your database is going to solve the few problems you listed here. For example, it won't help an issue with having hit the max number of connections. – SQLRockstar Nov 13 '12 at 14:15

1 Answer

up vote 0 down vote

Take a look at the dbunload utility, particularly the -an and -ap switches. You didn't say what version you are using, but here are the docs on v12.0.1.

share|improve this answer
the working engine and db is version 6.0 but i'm intending to upgrade to version 9.0 – Ahmed safan Nov 13 '12 at 6:44
I used the dbunload and it gave an error message saying page size is very big, i used sybase central to unload the database the wizard disable the radio buttons for choosing page size – Ahmed safan Nov 14 '12 at 12:22

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.