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 administrator permissions 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 has 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 Db2 user can not be the same as the user performing the installation.
Procedure
-
Log in to the Data Warehouse server using an account with administrator privileges.
-
Download the Data Warehouse with Reporting .zip file and extract the files to an installation folder.
-
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.
-
Enter the Db2 domain, or press Enter for local domain.
-
Enter the Db2 User name. See above for user name restrictions.
-
Enter the password for the Db2 user. Re-enter the password when prompted.
-
Enter the installation path for the Db2 component, or press Enter for default.
-
You are presented with the information you entered. Verify all settings carefully. Press Enter to start installation.
-
If prompted, allow Windows to proceed with the Db2 installation.
-
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.