Preparing the AE Database
The Automation Engine supports MS SQL, Oracle and PostgreSQL databases. Some infrastructural requirements apply to all of them, but the individual preparation steps differ from database to databases.
This page includes the following:
Disk Space Required
The initial database space required for an Automation Engine installation depends on the type and size of the system:
-
Test systems: 1 GB
-
Production systems
-
Small systems: 5 - 20 GB
-
Medium systems: 20 - 50 GB
-
Large systems: > 50 GB
-
For more information, see CDA System Requirements and Sizing.
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.
-
The database COMMIT time must be less than 5ms.
-
Make sure that your system is performing well. When using managed database services, it is recommended to have the database in the same network as the rest of the installation or at least have it in the same region to avoid any performance issues. You can test your system performance using the Performance Index tool, see Performance Index.
Preparing the Supported Databases
Next step: