Question Re: Implementation Guidelines for Sybase ASA 12 on Linux in Technology Q&A

Implementation Guidelines for Sybase ASA 12 on Linux

Former Member — Wed, 11 Jan 2012 14:34:35 GMT

I'm trying to find an implementation guide for ASA 12 that can help us figure out what tuning parameters we need to be looking at and implementing. We're on Red Hat ES5

Any help would be greatly appreciated.

Re: Implementation Guidelines for Sybase ASA 12 on Linux

MarkCulp — Wed, 11 Jan 2012 16:32:52 GMT

What type of "tuning parameters" are you looking for? OS tuning parameters or Database server tuning parameters or something else?

Note that the database server is designed to not require the developer/user to tune the server - yes there is always exceptions but out-of-the-box the server will adapt to the environment on which it is run.

Re: Implementation Guidelines for Sybase ASA 12 on Linux

Former Member — Wed, 11 Jan 2012 17:14:48 GMT

so no need to worry about shmmax settings or other sort of environmental tweaks like one needs on other databases? how about setting caching parameters and things of that nature

Re: Implementation Guidelines for Sybase ASA 12 on Linux

Dan_Cummins — Thu, 12 Jan 2012 08:17:01 GMT

This White Paper comes to mind:

http://www.sybase.com/detail?id=1092313

"SQL Anywhere I/O Requirements for Windows and Linux"

Re: Implementation Guidelines for Sybase ASA 12 on Linux

MarkCulp — Thu, 12 Jan 2012 08:19:00 GMT

SQL Anywhere uses file based shared memory on Unix platforms and therefore the setting of shmmax (and related values) is irrelevant.

You may want to read this whitepaper on SQL Anywhere I/O Requirements for Windows and Linux to make sure that your disk that holds your database is configured correctly: http://www.sybase.com/detail?id=1092313 - disks that are configured to not respect flush commands may lead to database corruption.