Changing the Database

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

Important Notes:

Automic recommends that a database administrator execute the following steps.

Direct modifications that are made in database contents without using AE programs will result in an inconsistent database.

Always make a database backup before you process any work steps.

This process can take a while depending on the database size and upgrading complexity.

This process can take a while depending on the database size and upgrading complexity.

Ensure there is sufficient disk space for the \AUTOMIC\DB directory and that the database's LOG section can store all this data.

Schemes that provide access to the database should be removed after the updating process in order to avoid unintended database modifications.

DB2: After updating the AE database, check the size of the tablespaces and if required, run the following SQL statement:

alter tablespace <UC4 tablespace name> reduce max;

Modifications that should be made are available in the special_rt.sql file.

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 utility AE 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 ILM (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.