Loading the AE Database

The delivery directory provides many versions of SQL scripts and database files in the DB directory. If the term <vers> is shown in the document, select the version you want to install.

	1.	Copying files in order to load the database

• Admin computer

• The files for the AE database are stored in IMAGE:DB. Copy the complete DB folder to the directory "Utility".
•  The DB directory must be stored at the location that has been specified using the INI-file parameter INPUT of the utilityAE DB Load. The folder that includes the BIN directory of the utilities is the default folder.

Example for Windows:

• Utilities in C:\AUTOMIC\UTILITY\BIN
• Database files in C:\AUTOMIC\UTILITY\DB
• Utilities - Windows:
  The files for the AE database are provided in IMAGE:DB. Copy the complete DB folder to the above directory.
• Utilities - UNIX:
  The database files are included in the archive db.tar.gz which is provided in the folder IMAGE:DB. To unpack the archive, use the following commands:
  gzip -d db.tar.gz bzw. gunzip db.tar.gz
  tar xvfo db.tar
  (Linux: tar -zxvf db.tar.gz)
  Copy the unpacked files to the defined directory.

	2.	Generating the database

• Admin computer
• Start the program AE DB LoadDas Dienstprogramm DB Load lädt Daten zu unterschiedlichsten Zwecken in die Automation Engine-Datenbank. in order to load the database.
• Select the file <DB directory>\DB\GENERAL\<vers>\UC_UPD.TXT
• A database scheme is created in the database, and the INITIAL and DEFAULT data are loaded.

	3.	Selecting the authentication method

• Admin computer
• As opposed to upgrade installations, new installations of AE DB Load do not display a mask in which you can select the authentication method. Start the program in batch mode using the parameters -T (authentication method) and -K (company key) in order to specify the authentication method. 

	4.	Installing partitioning with ILMSteht für Information Lifecycle Management, das sich auf eine breite Palette von Strategien zur Verwaltung von Speichersystemen auf Computing-Geräten bezieht. (optional)

• Admin computer
• A mask opens in which you can select the settings for partitioning with ILM. This step is optional.

Note that you cannot undo an AE database partitioning process.

	5.	Loading the licenses

• Admin computer
• Start the program AE DB Load in order to load licenses.
• Select the file Customer number.TXT that is provided by Automic Support. The utility enters the licenses in the AE database.

Potential Problems

• The code was not correctly converted when the ODBC access was set up. Correct: Ensure that the code is NOT converted.

Further Files

The directory IMAGE:\DB\database\UC4 version includes several useful SQL script files for your database that can be used as needed.