Factibilidad de la propuesta

The client tier is responsible for installing Infosphere Warehouse Design Studio, which provides a design environment for creating physical data models, OLAP modeling, SQL data flows, and control flows. Infosphere Warehouse Design Studio is a customizable design environment that is built upon the Eclipse platform. It integrates all the tasks of users of a data warehouse and business intelligence project within a unified environment.

Figure 3-4 depicts the InfoSphere Warehouse client components.

Figure 3-4 InfoSphere Warehouse client components

To install the client component of InfoSphere Warehouse on a Linux guest: 1. Edit the response file to meet your installation requirements. The sample

CLIENT_ISW.rsp response file is located in the ResponseFiles directory of the installation image.

Example 3-14 illustrates a sample response file generated by the installation wizard to install the client.

Example 3-14 Sample response file to install InfoSphere Warehouse client

#Profile using variables #---

PRODUCT_NAME=IBM InfoSphere Warehouse EXCLUDED_FEATURES=

#Disable OS Pre-requisite checking #--- DS_IGNORE_OSPREREQ=FALSE

#Has the license been accepted #--- LICENSE_ACCEPTED=TRUE

#Installation Directory #---

USER_INSTALL_DIR=/opt/IBM/ISWarehouse

#Selected Features in the Choosen Install Sets panel #--- CUSTOM_CHOSEN_INSTALL_FEATURE_LIST=WHDEV,CLIENTD,DSW_Main,OLAP_LUW,S QW_LUW,MINING,TA,MININGB,IMVis,ADMINCLI,Doc,Samples #DB2 Selection Panel #--- DB2_COPY_LOCATION=/opt/IBM/ISWarehouse/db2/V10.1 #DB2 Instance User Panel

#--- DB2INSTANCE_PASSWORD.encrypted=true DB2INSTANCE_NAME=db2inst2 DB2INSTANCE_GROUPNAME=db2iadm1 DB2INSTANCE_HOMEDIR=/home/db2inst2 DB2INSTANCE_PASSWORD=axfe02ki3kdi383 DB2INSTANCE_PANEL_TYPE=INST DB2INSTANCE_CONPASSWORD=axfe02ki3kdi383 #Select Install Package

#--- New.install.package=true PROFILE_ID=IBM Design Studio

SS_INSTALL_LOC=/opt/IBM/ISWarehouse SHELLSHARE=false

#Extend Existing Eclipse #--- Eclipse.JVM=

EXTEND_ECLIPSE_LOCATION= EXTEND_ECLIPSE_OPTION=

You can edit the following information: – Product License

The product license must be accepted to continue with the installation. The default value for the LICENSE_ACCEPTED is TRUE.

– Installation path

You can change the installation path in the USER_INSTALL_DIR variable. By default, the installation path for InfoSphere Warehouse on Linux is the USER_INSTALL_DIR=/opt/IBM/ISWarehouse directory.

– Individual components

You can customize the components that are to be installed by adding or removing values from the CUSTOM_CHOSEN_INSTALL_FEATURE _LIST variable.

The Example 3-15 shows the list of features that can be added for a Database Server installation.

Example 3-15 Edit the features list variable to add or remove features

#To add or remove Features, edit the following values from the variable Custom #Choosen Install Feature List:

# -WHDEV: installs the Warehouse Client # -CLIENTD: installs the db2 client # -DSW_Main: installs Design Studio

# -OLAP_LUW: installs Cubing Services tools # -SQW_LUW: installs SQL Warehouse tools # -MINING: Intelligent Mining tools # -TA: installs the text analysis tools

# -IMVis: installs Intelligent Miner visualization # -ADMINCLI: installs Administration Console CLI Client # -Doc: installs documentation

# -Samples: install samples

#---

CUSTOM_CHOSEN_INSTALL_FEATURE_LIST=WHDEV,CLIENTD,DSW_Main,OLAP_LU W,SQW_LUW,MINING,TA,MININGB,IMVis,ADMINCLI,Doc,Samples

– IBM Installation Manager

For the client, the IBM Installation Manager is required to perform this installation. If it is not already on your system, the installation program downloads it from IBM and installs it.

– Shared resources directory

The shared resources directory is used only by the Eclipse-based

components of the Design Studio as part of the client component group. If the computer on which you install the client components does not already have a shared resources directory from a previous installation of a product that is compatible with InfoSphere Warehouse, the installation program creates the shared resources directory in the default location, which is the /opt/IBM/ISWhared directory on Linux and UNIX.

– Eclipse environment

For the client, unless you already have an Eclipse environment, simply leave Extend Existing Eclipse unspecified. Otherwise, you need to specify information about the Eclipse IDE that already is present.

– Passwords

When you create a response file using the installation wizard, the passwords are encrypted by default. However, if you need to modify the passwords before the silent installation, you can set the encryption property value to false and set the value to the actual passwords that you want to use.

Example 3-16 shows how to change the password in the response file.

Example 3-16 How to change the password in the response file

DB2INSTANCE_PASSWORD.encrypted=true DB2INSTANCE_PASSWORD=axfe02ki3kdi383 DB2INSTANCE_CONPASSWORD=axfe02ki3kdi383

The password length can be up to the maximum number of characters that are supported by your operating system.

2. After you customize or generate the response file according to your requirements, create a shell script. Embed the command to install the InfoSphere Warehouse client silently on a new VM, when it is required. Example 3-17 shows the command to pass the response file that you create to install the application server on Linux.

Example 3-17 Command to install the client with a response file

iswclient:/temp/wh_client # isw/install.bin -i silent -f /temp/CLIENT_ISW.rsp -Dprofile=/temp/wh_client/isw/profile/

3. When the installation is completed, a message indicates the outcome of the installation. If the installation fails, investigate the log files to troubleshoot the problem. The logs are located in the default directory for installation, the /opt/IBM/ISWarehouse/logs directory for Linux and UNIX.

3.2 Implementing InfoSphere Warehouse Departmental