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 or 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 Load 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 ILM (optional) |
---|
- Admin computer
- A mask opens in which you can select the settings for partitioning with ILM. This step is optional.
Note: You can activate ILM either during a new installation, and upgrade or at any given point in time.
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.
Name |
Description |
---|---|
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 |
For manual statistics updates. |