Installing Utilities (Windows)

This document describes the hotfix installation procedure for the utilities (Windows).

To Install the Utilities (Windows)

Utilities must be run as administror.

1. Install the Java Runtime Environment (JRE) (Admin computer).

   This installation step can be ignored if the required version of JRE is already installed.

   1. You can check the system's current Java Virtual Machine (VM) version by using the following command:

   java -version

   In case several JRE or Java SDK Versions have been installed on the computer, make sure that the order of the indicated directories is correct in the settings of %PATH% or $PATH (system environment variables). The Java Runtime Environment that is found first in the listing of directories is applied.

   2. Download the required Java Runtime Environment from http://java.sun.com and install it.
   3. Do not forget to set the JAVA_HOME and JAVA_PATH according to Java System Instructions. See: https://docs.oracle.com/goldengate/1212/gg-winux/GDRAD/java.htm#BGBFJHAB.

2. Install the Microsoft Visual C++ 2010 Re-distributable Package (Admin computer).

   This installation step can be ignored if the package is already available in the required version. Refer to the Control Panel > Programs and Features to see if the package is installed, and if so, which version.

   • Install the package from the CRts folder of the image.

3. Install the utilities (Admin computer).

   • Start the program SETUP.EXE in the corresponding subdirectory of IMAGE:UTILITY\WINDOWS\x64.

   Automic strongly recommends to install the utilities in a separate directory (such as C:\AUTOMIC\UTILITIES\BIN\).

   Please create a temp subfolder for log files in the utilities folder (such as C:\AUTOMIC\UTILITIES\TEMP\) to comply with the predefined destination standards.

4. Adjust the INI files (located in the Utilities > Install folder) and set up the system environment (Admin computer).

   You can use any text editor to modify the values in the INI files.

   1. The INI files and the corresponding utilities share the same name. Adjust the INI file entries as needed:

      • AE.DB Archive: UCYBDBAR.ini
      • AE.DB Change: UCYBCHNG.ini
      • AE.DB Client Copy: UCYBDBCC.ini

        Only when client copy is used. 2 databases needed (source and target).

      • AE.DB Load: UCYBDBLD.ini
      • AE.DB Reorg: UCYBDBRE.ini
      • AE.DB Reporting Tool: UCYBDBRT.ini
      • AE.DB Revision Report: UCYBDBRR.ini
      • AE.DB Unload: UCYBDBUN.ini

   2. Almost all utilities require information about the AE database connection which is specified in the INI files. Automic recommends to create a new database user for AE.

      Never create a user that is called "sa".

      The appropriate password can be encoded by using the program UCYBCRYP.EXE.

   3. Use the following parameters in order to specify the program via the command line:
      UCYBCRYP[.EXE] -p -nPassword

      The Password.ucc file is created in the directory of the program that contains the encoded password.

Further Options

1. If you want to call the DLL from a freely selected path follow one of the options below (Admin computer):

   • Utility DLL paths can be changed by making an appropriate entry in the system environment variables (system control -> system). Enter the variable JAVA_LIBRARY_PATH and the required path. Libraries are loaded from this directory.
   • Alternatively, you can also use the parameter "-Djava.library.path=Path" in the INI files. Enter it in the line "cmd=" of the section [GLOBAL].

   cmd="javaw" -Djava.library.path=..\libraries -jar -cp .;.\UC4LAF.jar UCYBDBAr.jar