Skip to main content
OnCommand Insight

Installing OnCommand Insight Data Warehouse and Reporting

Contributors netapp-alavoie
PDFs

The installation is self-contained and includes the elements required to run and operate OnCommand Insight Data Warehouse (DWH) and the Reporting utilities.

Before you begin

Please note the following before installing or upgrading.

  • If you are upgrading, back up DWH.

  • You must have local administratorpermissions to install OnCommand Insight Data Warehouse with Reporting.

  • Make sure Windows Modules Installer service is enabled (either automatically or manually).

  • If installing on non-C: drive, Short File Names must be enabled. If it is not enabled, the installer will enable it.

  • For the Db2 component, the Db2 User can be either domain user or local user.

    • If the Db2 User is a domain user, you must have the following:

      • Db2 User must have been already created, and you must know the user name and password

      • As the user who is installing DWH with Reporting, you must be able to query the Db2 User. You can validate this using the command:

        • net user <db2 user name> /domain

    • If Db2 User is a local user, you must have the following:

      • User name and password for the user which will be used to run as Db2 User. If this user does not exist, installation will create it.

    • [NOTE]

The Db2 user name as well as the Windows login name have the following restrictions: * Valid characters are: 'A' through 'Z'; 'a' through 'z'; '0' through '9'; '@'; ''; '!'; ' '('; ')'; '{'; '}'; '-'; and '.'. * If using the special characters '!'; ' '('; ')'; '{'; '}'; '-'; and '.' you must use all uppercase letters for the user name. * The first character in the string must be an alphabetic character, @, #, or $; it cannot be a number or the letter sequences _SYS, DBM, or IBM * It cannot exceed 128 bytes in length. * It cannot be USERS, ADMINS, GUESTS, PUBLIC, LOCAL or any SQL reserved word.

  • The Db2 user can not be the same as the user performing the installation.

Steps

  1. Log in to the Data Warehouse server using an account with administrator privileges.

  2. Download the Data Warehouse with Reporting .zip file and extract the files to an installation folder.

  3. Navigate to the <download location>\oci_dwh_installer\ folder and run the install_oci_dwh.bat script.

    Note

    With OnCommand Insight 7.3.10 and later, you must run the script for proper DWH/Reporting installation. Do not run the .MSI installation executable.

  4. Enter the Db2 domain, or press Enter for local domain.

  5. Enter the Db2 User name. See above for user name restrictions.

  6. Enter the password for the Db2 user. Re-enter the password when prompted.

  7. Enter the installation path for the Db2 component, or press Enter for default.

  8. You are presented with the information you entered. Verify all settings carefully. Press Enter to start installation.

  9. If prompted, allow Windows to proceed with the Db2 installation.

  10. Following Db2 Installation, the DWH installation wizard will run. Follow its directions to install DWH with Reporting.

    Data Warehouse with Reporting Installation may take up to an hour to complete.

Synchronize Server and DWH

Important After installing the Data Warehouse, you must synchronize the Data Warehouse with the OnCommand Insight Server. Follow these steps:

  1. On the OnCommand Insight Server system, start the SecurityAdmin tool in interactive mode

    securityadmin -i

  2. Change the password for the inventory and dwh_internal users to passwords of your choice. Make note of these passwords as you will require them below.

  3. Restart the DWH service.

  4. On each Connector start the SecurityAdmin tool in interactive mode. You will need the passwords you noted from step 2 above.

    securityadmin -i

  5. Change the passwords for the inventory and dwh_internal users to the passwords used in step 2.

  6. Restart services on the Connectors.

  7. Add the Connectors to DWH, using the passwords for inventory and dwh_internal users from step 2