Pre-installing the IBM InfoSphere Information Analyzer analysis database in a Db2 database system by using scripts (Windows)

You can use an existing installation of a Db2® database to create an IBM® InfoSphere® Information Analyzer analysis database for InfoSphere Information Server on Microsoft Windows.

About this task

Use the scripts in the following situations:
  • When you cannot run the installation program locally on the target computer.
  • When you do not want to use the InfoSphere Information Server installation program to configure the database.
Attention: The scripts run the following commands when configuring the Db2 database system. These changes affect all databases in the Db2 instance:
db2set Db2.INLIST_TO_NLJN=YES
db2set Db2.USE_ALTERNATE_PAGE_CLEANING=ON
db2set Db2.REDUCED_OPTIMIZATION=YES

Procedure

  1. Navigate to the install_dir\DatabaseSupport directory of the InfoSphere Information Server installation media, where install_dir is the directory where you extracted the InfoSphere Information Server media.
    Database version Directory
    Db2 10.5 install_dir\DatabaseSupport\Windows\InformationAnalyzer\DB2_LUW
  2. Open the create_ia_db.sql script file in a text editor and make the following changes:
    Important: IBM certifies and validates InfoSphere Information Server using the provided database creation scripts. If you modify the scripts beyond the changes that are specified here, IBM will not support software failures that might result from the modifications. Modifications to these scripts that do not have a functional impact might require that you make similar changes in the future to scripts that are generated by other administrative tools that depend on the information in the scripts here. You are responsible for making those changes.
    1. Replace all occurrences of @DATABASE_NAME@ (including the @ symbols) with the name of the database that you want to create.
      For example, replace @DATABASE_NAME@ with your database name:
      iadb
    2. Replace all occurrences of @INSTALL_ROOT@ (including the @ symbols) with the path to the root directory where your Db2 database is installed. The default root directory is C:\.
      For example, replace @INSTALL_ROOT@ with the path to the root directory for your Db2 database:
      C:\
      When you run the script, Db2 creates a directory under the root directory where your database is installed. This directory contains the data files for your database. The default directory is C:\db2\NODE0000.
    3. Replace all occurrences of @DATABASE_ALIAS@ (including the @ symbols) with the name of the database that you want to create.
      For example, replace @DATABASE_ALIAS@ with your database name:
      iadb
    4. Replace all occurrences of @DATABASE_USERNAME@ (including the @ symbols) with the name of the operating system user that you want to have access to the database.
      For example, replace @DATABASE_USERNAME@ with the operating system user name:
      iauser
  3. Run the operating system script to invoke the SQL script:
    1. Login as instance user.
    1. Open a Db2 Command Window.
    2. From the Db2 Command Window, change directory to the same location as the edited script and run the following command:
      create_ia_db.cmd [logfile]
      logfile is the name of the file where you want to save the results of running the command. This argument is optional.
  4. Restart Db2.