Avaya Customer Interaction Express 1.0, User Manual

Page: 315 / 344

Database maintenance and repair
Edition: 1.1 03/08/2007 315
Advanced database configuration
The following topics provide tips for configuring a database.
Working memory (max memory) used
You can define the working memory (max memory) used for Sybase ASE.
Limitation
You can set a max memory of up to 1.4 GB. If you use a higher value, Sybase may not function properly.
After you change the size of the working memory, you must always change the size of the default data
cache accordingly.
Settings
To change the working memory used (max memory), follow these steps.
1. Start ISQL in a command prompt (DOS box). Enter the following commands.
isql -U sa -P password
2. To change the working memory size, enter the following commands. The size of the working memory
used is specified in megabytes (500 Mbytes in this example).
1>sp_configure "max memory", 0, "500M"
2>go
3. You must also change the default data cache accordingly. Enter the following commands.
1>setup..set_default_data_cache
2>go