Installing the Utilities - Windows

The AE Utilities support the handling of administrative tasks.

Notes:

• It is best to install the utilities in a separate directory (such asC:\AUTOMIC\UTILITIES\BIN\).

• Utilities must be run as administrator.

To Install the Utilities (Windows)

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) from the CRts folder of the image.

   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.

3. Install the utilities (Admin computer).

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

   A temp subfolder for log files is automatically created in the utilities folder.

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 (Utility DB Archive)

      • AE.DB Change: UCYBCHNG.ini (Utility DB Change)

      • AE.DB Client Copy: UCYBDBCC.ini (Utility DB Client Copy)

        Important! When you use DB Client Copy, you need two databases (source and target).

      • AE.DB Load: UCYBDBLD.ini (Utility DB Load)

      • AE.DB Reorg: UCYBDBRE.ini (Utility DB Reorg)

      • AE.DB Reporting Tool: UCYBDBRT.ini (Utility DB Reporting Tool)

      • AE.DB Revision Report: UCYBDBRR.ini (Utility DB Revision Report)

      • AE.DB Unload: UCYBDBUN.ini (Utility DB Unload)

   2. Almost all utilities require information about the AE database connection which is specified in the INI files.

      Create a new database user for AE. The appropriate password can be encoded by using the program (UCYBCRYP.EXE). For more information, see Encoding Passwords.

      Important! Never create a user called "sa".

   3. To specify the program via the command line use the parameter UCYBCRYP[.EXE] -p -nPassword.

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

Further Options

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

Next step:

Loading the AE Database