Loading the AE Database

The following steps will help you load the AE Database.

This page includes the following:

Notes:

PostgreSQL
- To connect to the new database use the connect string format SQLDRIVERCONNECT=ODBCVAR=NNJNIORP,host=host01 port=5432 dbname=[database] user=[user name] password=[password] connect_timeout=10
  
  The string after the comma is a standard PostgreSQL connection string.
- When starting initial load, the utility shows a "DEADLOCK" error.

Once ILM has been activated, you cannot deactivate it. The ILM functionality can only be stopped. If ILM is stopped, no partition change or switch-out (MS SQL Server) is performed.
When using an Oracle database, make sure that there is only one Automation Engine schema within an Oracle instance used for ILM.

Installing the AE Database

Copy the files in order to load the database (Admin computer).

Windows

The files for the AE database are provided in IMAGE > DB folder. Copy the complete DB folder to the installation folder of the utilities. (in our case C:\AUTOMIC\UTILITIES\).

The DB directory must be stored at the location specified in the INI file parameter INPUT of the utility AE DB Load, which is set by default in the installation folder (in our case C:\AUTOMIC\UTILITIES\DB). For more information, see AE DB Load.

Example for Windows:

Utilities in C:\AUTOMIC\UTILITIES\BIN

Database files in C:\AUTOMIC\UTILITIES\DB

UNIX

The database files are included in the db.tar.gz archive located in the IMAGE > DB folder.

Use the following commands to unpack the archive:

gzip -d db.tar.gz or gunzip db.tar.gz

tar xvfo db.tar

(Linux: tar -zxvf db.tar.gz)

Copy the unpacked files to the defined directory.
Generate the database (Admin computer).
1. Run AE DB Load as administrator in order to load the database. Follow one of the three options below:
  - *G.EXE (ucybdbldg.exe): regular utility start (G stands for GUI).
    
    cmd="javaw" -Djava.library.path=..\libraries -jar -cp .;.\UC4LAF.jar UCYBDBAr.jar
  - *.EXE: program to which start parameters can be assigned for batch calls
    
    For more information, see Start Parameters - Utilities.
  - *.BAT: batch file for the utility.
  - As opposed to upgrade installations, new installations of AE DB Load do not display a mask in which you can select the agent authentication method. For more information, see Agent Authentication.
    
    Start the program in batch mode using the parameters -T (authentication method) and -K (company key) in order to specify the authentication method.
  Note: To run the utilities by using an *.EXE file, you must have installed a 32-bit Microsoft Visual C-Runtime Library.
2. Select the <DB directory>\DB\GENERAL\<vers>\UC_UPD.TXT file.
3. A database scheme is created in the database, and the INITIAL and DEFAULT data are loaded.
  
  If the database has been generated successfully you will see the following:
Optionally, activate partitioning with ILM (admin computer). For more information, see ILM - Information Lifecycle Management.

Note: You can activate ILM either during a new installation, and upgrade or at any given point in time.

Potential Problems

The code was not correctly converted when the ODBC access was set up. Solution: Ensure that the code is NOT converted.
DB Load may not be able to connect to the DB if too many sessions are running simultaneously.
The DBLOAD GUI may not start if the INI "cmd" parameter is not properly defined (javaw.exe location).

Related Files

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

DROP_ALL.SQL

Deletes all AE tables.

Use this SQL file when the installation could not complete successfully (for example, if there was not enough hard drive space). If not all tables could be created, this file deletes all tables that cause error messages. Check them or ignore them if no action is required.
UPD_STAT.SQL

Used for manual statistics updates.

Next step:

Installing the AE, ServiceManager, JWP and JCP