This section describes all of the database configuration that is required for running a ServiceOptimizer instance. Certain areas will only need to be set up once, when the database is first created. Others will need to be reconsidered/altered on each upgrade of the code, or where an existing database is to be used for a different instance (e.g. where a production database is imported into a development instance). All of the following questions need to be considered in each case:
| Question | Sections to consider | New Database | Reusing/upgrading Database |
|---|
 How should the various processes be spread across the one or more server machines to be used?
| Example Configuration System Start Up 14.1 Distributed System | - resources of each server
- size of the processes
- expected throughput of the processes
- required restart times for the processes (based on timezones)
| - Has the size of any one of the processes changed (more employees added, larger volume of jobs?
- Has there been a reorganisation of the geography, hence bringing about the above?
|
Are multiple gantt routers required?
| Multiple GanttRouters | - how many gantts required for whole instance
- how many gantts required for each FRU
- how will their login be spread time wise
| - has either the number, or spread, of gantt users changed
|
Which UI features are required by the business?
| UI Support | - Required Gantt Reports?
- Is ServiceManager being used?
- Does the gantt need access to ServiceManager
| - Any change in the required Gantt Reports?
- Any change in use of ServiceManager?
|
Does the API interface need to be secure?
| System Start Up | - what is the security strategy for integrations?
- is there an SSL certificate available
| - is a different certificate needed for this instance?
|
Does any business functionality need to be enabled directly in the database?
| Business Functionality | - what functionality does the business require?
- what has been set up by the ServicePower consultants
- instance calendar
- booking ranges
| - Any change in business usage?
|
How should the logfiles work?
| Application Logfiles | - Available resources
- Is auditting switched on
| - Any change in available resources
- Is there a need for support on a specific component?
|
What Travel Matrix (or Travel Matrices) should be used?
| How the Travel Matrix works | - does a single TM suffice for the whole instance
- is the instance distributed
| - are you adding a new geography
- has there been a change in the distribution of processes
|
What auditting is required within the system?
| Auditing | - what logging is required for automated processes
- what logging is required for manual processes
- what support needs are there
| - is there a specific need for support
- is there a specific need for performance
|
What time zones are required for the vaious parts of the business and business processes?
| Time Zones | - what geographies are covered by the instance
- what is the TM of the server(s)
| - have the geographies changed
- have new geographies been added
- have the servers been moved
|
What is the auto-restart/recovery strategy?
| 14.1 Setting up Auto-Recovery of Components | - resource constraints
- uptime constraints
| |
What is the planned restart strategy?
| Planned restart of Components | - time zones
- dispatch requirements
| - changes to dispatch requirements
- new/changed geographies
|
