Installing the Accelerator Loader studio (required)

Use the Accelerator Loader studio to load relational and non-relational data to the accelerator.

Before you begin

Accelerator Loader studio is available with Db2 Analytics Accelerator Loader. You install Accelerator Loader studio as a plug-in to IBM® Data Studio or an equivalent Eclipse-based application.

Note: IBM Installation Manager is not supported.
Before installing the Accelerator Loader studio, verify that all installation prerequisites are met:
System component Requirement
Supported operating systems
  • Windows 7, 8, 10
  • Linux – Red Hat Enterprise Linux 6.7 or higher; Ubuntu 16 or higher
  • macOS (Sierra)
Software
  • The Accelerator Loader server must be installed and configured on IBM z/OS®.
  • Eclipse Kepler (4.3.x) or Luna (4.4.x) is required for Accelerator Loader studio. For Windows and Linux users, it is recommended to have IBM Data Studio 4.1.x installed on the client system.
    Note: Updating software from IBM Data Studio can require that you log in as an administrator.
  • Java 1.7 or 1.8 is required.
System memory 4 GB of system memory is recommended.
Hard disk space 40 MB of hard disk space is recommended (the installed software will consume 20 MB).
Client permissions You have appropriate user logon credentials and user privileges on your client system to install the Accelerator Loader studio. For example, to install the studio on Windows, you need administrator authority; ensure that your user profile has the appropriate privileges to write to the target system location.
Mainframe permissions and access You have appropriate mainframe user logon credentials and user privileges, you can connect to the Accelerator Loader server on the mainframe, and the Accelerator Loader server can access other DBMS subsystems.
Note:

Connecting to the mainframe system requires the following information (these values are viewable in Accelerator Loader server messages, or you can get them from your system programmer):

  • Host name on which the Accelerator Loader server is running.
  • JDBC port number. During customization with Tools Customizer, the port number is specified in the field TCP/IP OE port number. In the server configuration file, the parameter name is OEPORTNUMBER. On the mainframe, use SDSF to browse the server JOB output and search for OEPORTNUMBER.

About this task

The Accelerator Loader studio provides a graphical user interface (GUI) to help you generate the JCL you need to load data to the Accelerator Loader, enables a single, enterprise view across all mainframe integration components, and automatically discovers instances of the Accelerator Loader server running on the mainframe.

You can install the Accelerator Loader plug-in into IBM Data Studio using either of the following methods:
  • Eclipse GUI installation. Using this method, you can use the IBM Data Studio to install the Accelerator Loader plug-in. Member hlq.SHLVBIN(HLVBIN) provides the Accelerator Loader studio plug-in files. To perform the Eclipse GUI installation, you must transfer the HLVBIN file to a local workstation, rename the file, and then perform steps in the GUI to complete the installation.
  • Command-line installation. Using this method, you can use a script-based mechanism for installing the Accelerator Loader plug-in into IBM Data Studio or any supported Eclipse from the command line. Member hlq.SHLVBIN(HLVBINS) provides the Accelerator Loader studio plug-in files as well as the installation scripts for Windows and Linux/Mac in zipped format. To perform the command-line installation, you must transfer the HLVBINS file to a local workstation, extract the contents, and then run the script.
Use the following procedure to perform either of the installation methods.

Procedure

Perform one of the following methods to install the Accelerator Loader plug-in:
  • Eclipse GUI installation:
    1. Using File Transfer Protocol (FTP) in binary mode, perform a binary transfer of installation member hlq.SHLVBIN(HLVBIN) to a folder on your local workstation.
    2. Convert the HLVBIN file to a compressed file format by renaming with extension .zip so that the filename is HLVBIN.zip.
    3. Uncompresss (extract) the HLVBIN.zip file.
    4. In IBM Data Studio, go to Help > Install New Software, and on the Install dialog select Add.
    5. On the Add Repository dialog, select Archive.
    6. Navigate to directory HLVBIN > studio, select loader.zip, then select Open.
    7. Enter a name for the repository and click OK.
    8. Select the check box next to Accelerator Loader and click Next.
    9. Complete the remaining installation wizard steps, and then restart IBM Data Studio when prompted.
    10. Optional: Delete the loader.zip file.
  • Command-line installation:
    1. Using File Transfer Protocol (FTP) in binary mode, perform a binary transfer of installation member hlq.SHLVBIN(HLVBINS) to your local workstation, and unzip the contents.
    2. Ensure that your Eclipse application (for example, IBM Data Studio) is not running.
    3. Perform one of the following steps:
      • For Windows: From a DOS prompt, navigate to the folder where the contents were extracted, and execute the install.bat script, passing the location of your Eclipse as an argument as in the following example:
        % install.bat "C:\Program Files\IBM\DS4.1.2"
        Note: If no argument is specified, the script will prompt you for the location. When prompted by the script, the double quotation marks must not be specified. The double quotation marks should only be used if the path name contains space characters and is being specified as a command-line argument.
      • For Linux/Mac: From the shell, navigate to the directory where the contents were extracted, and execute the install.sh script, passing the location of your Eclipse as an argument as in the following example:
        # ./install.sh /opt/ibm/DS4.1.2
        Note: If no argument is specified, the script will prompt you for the location.
    4. Start your Eclipse application (for example, IBM Data Studio).
    5. Optional: To confirm that the new plug-in installed successfully, select Help > About IBM Data Studio, and click Installation Details.

      The Installation Details dialog shows the Installed Software and includes a line item for the Accelerator Loader with version details.

    6. Optional: Delete the .zip file and the extracted contents from step 1.

What to do next

You can now open the Accelerator Loader perspective from IBM Data Studio.