Preparing the AE Database
The Automation Engine supports different databases. Some infrastructural requirements apply to all of them, but the individual preparation steps differ from database to databases.
This page includes the following:
Infrastructure Requirements
The following requirements apply to all databases:
- Use an external disk subsystem with a connection via Fibre Channel for the data files. Under no circumstances should local disks with software RAID be used, as this could negatively affect the performance of the database and thereby that of the entire AE system.
- Latency periods should not be too long when the Automation Engine (server) accesses the database (ping response with 8 K packet size < 1 ms). The same requirement applies when using RAC or Data Guard for the communication between database nodes.
- The database server must have sufficient RAM and a suitable swap area on the local disk.
- o < 2 GB => SWAP = RAM;
- o > 2 GB => SWAP = RAM x 0.75
- o No swap-in (SI) may take place.
- The database system(s) must have enough CPUs appropriate to the load. The run queue length of the available processors under high load can serve as a guideline here. If the run queue is frequently longer than 1, you may need to employ more CPUs.
- RUN QUEUE LENGTH <= COUNT of CORES
- The number of active components such as routers, switches or firewalls on the path between the Automation Engine and the database should be minimized so as not to slow down access and to avoid single points of failure.
Supported Databases
Next step: