Castelle Office Direct OfficeDirect Storage Server Installation Manual download pdf (Page 93)

Sage Sage Intergy 7.00 Install Guide 5 - 1

Chapter 5: Database Tuning

All Sage Intergy 7.00 databases should be manually tuned before client connections are

permitted. This applies to all newly implemented installations as well as all Sage Intergy

upgrades. Database tuning must also occur in the event of large scale changes to an existing

Sage Intergy installation, such as a serialization change that adds new user licenses, or a

hardware replacement that changes the specifications of the database server. The

instructions in this chapter apply to both new installations and existing installations, but only

for Sage Intergy 7.00 and no other version.

Different computing environments may require different data to be entered. In some cases,

you will calculate an entry based on a formula. In other cases, you may need to refer to a

chart. Note also that many database tuning value labels are not literal, or are otherwise

misleading. For example, the field ‘Maximum Servers’ refers to the number of server

connections, rather than the number of server devices. For all tuning parameters, read the

instructions carefully to ensure that the correct values are being entered.

When tuning parameters have been successfully applied, a reboot of the database server is

necessary to apply all changes.

Typical Installation Settings . . . . . . . . . . . . . . . . . . . . . . .5-2

Sage Intergy Database Tuning Instructions . . . . . . . . . . . . . . .5-3

Database Shutdown . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-3

Database Configuration Parameter Changes . . . . . . . . . . . . . . . . . . 5-4

Open Database Default Configuration . . . . . . . . . . . . . . .5-4

General Default Configuration . . . . . . . . . . . . . . . . . . .5-4

Application server configuration changes . . . . . . . . . . . . . . . . . . . . 5-7

Application Server settings . . . . . . . . . . . . . . . . . . . . .5-8

Name Server Logging Settings . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-9

Progress Application Server Text File Tuning Settings . . . . . . . . . . . 5-10

Reboot Requirement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-10

Next Steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-10

1 2 ... 88 89 90 91 92 93 94 95 96 97 98 ... 283 284

No comments

Castelle Office Direct OfficeDirect Storage Server Installation Manual Page 93