Installing Utilities (Windows)

Service Pack and Hotfix Installation

Installing the Automation Engines

---

Changing the Database

The DB directory of the installation CD can include several versions of SQL scripts and databaseA database is an organized collection of data including relevant data structures. files. They are required if you update several versions. Be sure to use the correct version if <vers> is indicated in the document.

Automic strongly recommends reading the notes for updating the AE database.

Modifications that should be made are available in the special_rt.sql file. Also execute the new_mq.sql file. Search the UC_UPD.TXT file for the lines shown below and remove the comment "message" at the beginning.

Extract of the adjusted UC_UPD.TXT file:

process_sql_file  new_mq.sql
process_sql_file  special_rt.sql

The special_rt.sql file converts the stored reports in the database. Depending on the number of report data records that are affected by the conversion it is important to ensure that there is sufficient memory and a transaction log of the appropriate size. Because the table is copied, it exists twice for a while which also prolongs the conversion process. Automic recommends reorganizing the reports before you execute the UC_UPD.TXT file in order to minimize the number of report data records.

Procedure

	1.	Changing the database scheme and loading new initial data to the database

• Server computer
• All server processes must be stopped. Pay special attention if server processes run on several computers. The following steps must only be processed when all server processes have been stopped.

• Admin computer

• The directory containing the database files must be stored at the location that has been specified in the INI-file parameter INPUT of the utilityAE DB Load. The folder that includes the BIN directory of the utilities is the default folder. 

Windows example:

• Utility 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.
  
  
• Start the program AE DB Load to update the database.Select the file <DB directory>\GENERAL\<vers>\UC_UPD.TXT
• The current database version is identified and the database updated. As this happens, the database structure and data are changed. Objects of client 0000 are automatically replaced or amended.

	2.	Selecting the authentication method

• Admin computer
• The utility AE.DB Load displays a mask in which you must select an authentication method.
• This mask is only displayed if the database is updated to a new Automation Engine version.

	3.	Installing partitioning with ILMStands for Information Lifecycle Management, which refers to a wide-ranging set of strategies for administering storage systems on computing devices. (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.