Preparing the AE Database

The Automation Engine supports DB2, 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 Automic Automation System Requirements and Sizing.

Preparing the Supported Databases

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:

Reviewing the AE and AWI Default Ports