====== TPC Tivoli Productivity Center ======

https://www-950.ibm.com/events/wwe/grp/grp011.nsf/vLookupPDFs/2-TPC52_Install/$file/2-TPC52_Install.pdf

TPC contain many products, but version 5.1 doesn't fully supports Redhat 6, then I've done the installation on Redhat 5.9 x64:

You can install Tivoli Storage Productivity Center 5.1 in a multiple-server environment.

    Install the following components on the Red Hat Enterprise Linux 6.0 server:
        DB2
        Tivoli Storage Productivity Center servers
        Database repository
        Stand-alone GUI
        Command-line interface
        Storage Resource agent

    Install the following components on a separate server with a supported operating system, other than 
    Red Hat Enterprise Linux 6.0:
        Tivoli Integrated Portal
        Tivoli Common Reporting
        Web-based GUI components

===== TPC licenses =====

The following licenses are available in Tivoli Storage Productivity Center 5.1:

=== IBM Tivoli Storage Productivity Center ===
This license contains the following functions:
v Data management. Data management includes enterprise-wide
reporting and monitoring, and automated capacity provisioning
for direct-attached storage (DAS), network-attached storage
(NAS), and storage area networks (SAN) environments.
v Disk management. Disk management helps you manage SANs
and heterogeneous storage from one console.
v Fabric management. Fabric management helps you manage the
SAN fabric that connects the host systems and applications to
the storage devices. This feature includes automatic resource and
topology discovery, monitoring, alerts, and zone control.
v Tape management. Tape management helps you manage your
tape libraries that must be SMI-S compliant.

=== Tivoli Storage Productivity Center for Replication ===
All of the Tivoli Storage Productivity Center for Replication
functions, including the functions that were previously in the Two
Site and Three Site Business Continuity licenses.
v Performance management. Disk and Fabric performance
management functions.
v Device support. For the devices that you can use with Tivoli
Storage Productivity Center, see http://www.ibm.com/support/
docview.wss?rs=40&uid=swg21386446.

=== IBM Tivoli Storage Productivity Center Select Edition ===
This license contains all the functions of the IBM Tivoli Storage
Productivity Center license.

=== IBM Tivoli Storage Productivity Center Advanced ===
This license contains all the functions in the Tivoli Storage
Productivity Center license plus these additional analytical
functions:
v Configuration Analysis
v Configuration History
v SAN Planner
v Storage Optimizer

=== Tivoli Storage Productivity Center for data-related functions ===
v Scans
v Policy management
v Server probes
v Profiles
v Data Manager for Databases
v Data Manager for Chargeback

=== IBM Scale Out Network Attached Storage ===
IBM Scale Out Network Attached Storage (IBM SONAS) manages
repositories of information in enterprise environments that require
large capacities, high levels of performance, and high availability.
IBM SONAS uses up 2 petabytes (PB) of storage in a large file
system.

=== Policy-based storage tier reports ===
Use the Tivoli Storage Productivity Center command-line interface
to issue commands that create user-defined storage tiering policies.
Storage tiering policies set the conditions that must be met to
determine whether a volume requires migration to another pool.

===== TPC Installation =====

http://www-01.ibm.com/support/docview.wss?uid=swg21462180

http://www-01.ibm.com/support/docview.wss?uid=swg27024859#Server

http://pic.dhe.ibm.com/infocenter/tivihelp/v59r1/index.jsp

http://www-01.ibm.com/support/docview.wss?uid=swg27027303

<box 80% round red|Prerequisite for DB2></box>
Redhat 5 x64 is fully supported, while Redhat 6 partially.\\
8 GB of RAM is recommended, while 4 GB is the minimum.\\
Minimum of 15 GB is required into /opt/IBM/TPC for all binaries, and from 40 to 80GB for the database size.

I have create 2 filesystems:
  /opt/IBM for all (TPC) binaries 15GB
  /opt/ibm for db2 binaries 1GB
  /tpcdb which will contain the DB2 database 15GB
  
=== First Step: DB2 installation using GUI ===


<box 80% round red|Fully Qualified Hostname></box>

Before starting set a FQHN (fully qualified hostname), which is required for TPC.

I add an entry into /etc/hosts:
  10.8.3.87  dev-tpc.link.com dev-tpc
  
Check also the hostname into /etc/sysconfig/network
  HOSTNAME=dev-tpc.link.com

<box 80% round red|Change redhat-release file></box>

As I use a CentOS, I just change /etc/redhat-realse from
  CentOS release 5.9 (Final)
to
  Red Hat Enterprise Linux Server release 5.9 (Tikanga)

<box 80% round red|Download DB2 for TPC></box>

Download the latest DB2 package for TPC:\\
//Ex:// DB2_9.7_FP4_LIN64_FOR_TSPC_5.1_ML.tar.gz

<box 80% round red|Install DB2 for TPC></box>

Use a graphical environment for example vncserver, to start the installation using the command:
  <source_dir>/server/db2setup

On the DB2 Setup Launchpad page, click **Install a Product**\\
On the content page, click **Install New for DB2 Enterprise Server Edition Version 9.7 Fix Pack 4**\\ 
On the Welcome to the DB2 Setup wizard page, click **Next**\\
On the Software License Agreement page, read, click **Accept**, and click Next.\\
On the Select the installation type page, select **Typical** and click Next.\\
On the Select installation, response file creation, or both page, select **Install DB2 Enterprise Server Edition** on this computer and save my settings in a response file.\\
Enter a response file name, or accept the default, and click **Next**.\\
On the Select the installation directory page, enter a directory or use the default and click Next.\\
On the Install the IBM Tivoli System Automation for Multiplatforms (SA MP) page, select **Do not install SA MP**, and click Next.\\
On the Set user information for the DB2 Administration Server page, DB2 will create the users if they don't exist, just set the **password**\\
On the Set up a DB2 instance page, select **Create a DB2 instance**, and click Next.
20. On the Set up partitioning options for the DB2 instance page, select Single partition instance, and click Next.
On the Set user information for the DB2 instance owner page, just set the **password**\\
On the Prepare the DB2 tools catalog page, select **Do not prepare the DB2 tools catalog** and click Next.\\
On the Set up notifications page, select **Do not set up your DB2 server to send notifications at this time**, and click Next.\\
On the Start copying files and create response file page, review the summary information, and click Finish.\\
Read the information about the panel and click Finish

<box 80% round red|Check the DB2 license></box>

Enter the db2licm command:
<cli prompt='#'>
[root@dev-tpc server]# su - db2inst1
[db2inst1@dev-tpc ~]$ db2licm -l
Product name:                     "DB2 Enterprise Server Edition"
License type:                     "Restricted"
Expiry date:                      "Permanent"
Product identifier:               "db2ese"
Version information:              "9.7"
</cli>

If no license is register, as db2inst1 user:
  db2licm -a <software_path>/server/db2/license/license_filename.lic
where x represents the DVD drive that contains the DB2 license key file and license_filename.lic is the license key file db2ese_o.lic.

Else from the License Center:
  a. Start the DB2 Control Center and click Tools>License Center.
  b. Select the system and installed product for DB2 and clickLicense> Add.
  c. In the Add License window, select the directory that contains the license file.
  d. Select the license file and click OK.

<box 80% round red|Update the group for the instance user></box>

After you install DB2, edit the/etc/group file, add root to the db2iadm1group.
The db2iadm1 line in /etc/group looks like the following line:
  db2iadm1:x:102:root
You must edit the/etc/group file and add db2inst1 to the group root. After adding db2inst1, the line should look like this line:
  root:x:0:root,db2inst1

<box 80% round red|Add a service name into DB2, and TCPcomm></box>

Then on user db2inst1 check if the service is properly defined:
<cli prompt='$'>
[db2inst1@dev-tpc ~]$ db2 get dbm cfg | grep -i svc
 TCP/IP Service name                          (SVCENAME) = 
 SSL service name                         (SSL_SVCENAME) = 

[db2inst1@dev-tpc ~]$ cat /etc/services | grep db2
DB2_db2inst1    60000/tcp
DB2_db2inst1_1  60001/tcp
DB2_db2inst1_2  60002/tcp
DB2_db2inst1_END        60003/tcp
db2c_db2inst1   50000/tcp

[db2inst1@dev-tpc ~]$ db2 update dbm cfg using svcename db2c_db2inst1
DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed 
successfully.
[db2inst1@dev-tpc ~]$ db2 get dbm cfg | grep -i svc
 TCP/IP Service name                          (SVCENAME) = db2c_db2inst1
 SSL service name                         (SSL_SVCENAME) = 
</cli>

To prevent DB2 connection error:
<cli prompt='$'>
[root@dev-tpc ~]# su - db2inst1
[db2inst1@dev-tpc ~]$ db2set
DB2AUTOSTART=YES
[db2inst1@dev-tpc ~]$ db2set DB2COMM=tcpip
[db2inst1@dev-tpc ~]$ db2stop
08/09/2013 16:52:53     0   0   SQL1064N  DB2STOP processing was successful.
SQL1064N  DB2STOP processing was successful.
[db2inst1@dev-tpc ~]$ db2start
08/09/2013 16:52:56     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.
[db2inst1@dev-tpc ~]$ db2set
DB2COMM=tcpip
DB2AUTOSTART=YES
</cli>

<box 80% round red|Change the DB2 database repository></box>

I have create a specific filesystem for the TCP database /tpcdb, then I also need to change the rights on that folder, and update the path into DB2:
<cli prompt='$'>
[root@dev-tpc /]# chown -R db2inst1.db2iadm1 /tpcdb
[root@dev-tpc /]# su - db2inst1
[db2inst1@dev-tpc ~]$ db2 update dbm cfg using DFTDBPATH /tpcdb IMMEDIATE
DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed 
successfully.
[db2inst1@dev-tpc ~]$ db2 get  dbm cfg | grep PATH
 Java Development Kit installation path       (JDK_PATH) = /home/db2inst1/sqllib/java/jdk64
 Diagnostic data directory path               (DIAGPATH) = /home/db2inst1/sqllib/db2dump/
 Alternate diagnostic data directory path (ALT_DIAGPATH) = 
 Default database path                       (DFTDBPATH) = /tpcdb
 SPM log path                             (SPM_LOG_PATH) = 
</cli>

//For information: DB2 uninstall if needed//
<cli prompt='#'>
[root@dev-tpc server]# ./db2ls

Install Path           Level   Fix Pack   Special Install Number   Install Date                  Installer UID
---------------------------------------------------------------------------------------------------------------
/opt/ibm/db2/V9.7      9.7.0.4        4                            Fri Aug  2 16:51:09 2013 CEST             0
[root@dev-tpc server]# ./db2_deinstall -a

Enter full path name for the install directory -

------------------------------------------------
/opt/ibm/db2/V9.7
DBI1016I  Program db2_deinstall is performing uninstallation. Please wait.


The execution completed successfully.

For more information see the DB2 uninstallation log at
"/tmp/db2_deinstall.log.16402".
</cli>


=== Second Step: TPC installation ===

<box 80% round red|Install prerequisites for TPC installation></box>

Space required:
  /usr 220MB
  /var 1MB
  /tmp 2G
  /tpcdb 2,000 MB
  /opt/IBM 9,308 MB
  /home/db2inst1 2G min.
  
Here are the specific package that I have added for TPC:
  yum install system-config-network.noarch  system-config-lvm.noarch 
  yum install libstdc++.i386
  yum install compat-libstdc++-33.i386 compat-libstdc++-33.x86_64
  yum install compat-libstdc++-296.i386
  yum install compat-db.i386 compat-db.x86_64 compat-libstdc++-296.i386
  yum install libXtst.i386 libXtst.x86_64 
  yum install libXp.i386 libXp.x86_64
  yum install libXmu.i386 libXmu.x86_64
  yum install libXft.i386 ibXft.x86_64
  yum install pam.i386 pam.x86_64 
  yum install gtk2.i386 gtk2.x86_64 
  yum install gtk2-engines.i386 gtk2-engines.x86_64
  yum install compat-glibc.i386 compat-glibc.x86_64
  yum install openmotif22.i386 openmotif22.x86_64

First check the prerequisites: **<software_dir>/scripts/backend/rhelprereqs.sh**\\
And install all rpm missing packages.

Download TPC, and unpack **all files** into the same directory, first the base package, and the latest packages:

**Server 	Linux 	5.1.1-TIV-TPC-Server-Linux**

Base package contains licenses:  
  TPC_CENTTPC_CENTER_ADVNCD_V5.1.0_LNX_1_OF_5.tar

Latest packages:  
  TPC_5.1.1.1_NL_linux_ix86_disk1_part1.tar
  TPC_5.1.1.1_linux_ix86_disk1_part2.tar
  TPC_5.1.1.1_linux_ix86_disk1_part3.tar
  TPC_5.1.1.1_linux_ix86_disk1_part4.tar
  TPC_5.1.1.1_linux_ix86_disk1_part5.tar
  TPC_5.1.1.1_linux_ix86_disk1_part6.tar 
  
<box 80% round red|Install TPC></box>

Install TPC using a graphical interface, for example vncserver:
<cli prompt='#'>
[root@dev-tpc ~]# . /home/db2inst1/sqllib/db2profile
[root@dev-tpc ~]# cd /software/tpc/
[root@dev-tpc tpc]# ./setup.bin -DLICENSE_ACCEPTED=true
</cli>

You have just to **keep default settings**, enter just the **password** for the user db2inst1

It will take about 2 hours.

<box 80% round red|How to connect to TPC></box>

http://dev-tpc.link.com:9568/srm  --> new interface for alerting and monitoring

http://dev-tpc.link.com:9568/ibm/console --> WebSphere management (Users, LDAP...)

Or using the GUI:(login with local user)\\ 
  /opt/IBM/TPC/gui/TPCD.sh

The web GUI is also available at:\\
  http://dev-tpc.link.com:9550/ITSRM/app/welcome.html --> Web GUI

TPC for replication
  https://dev-tpc.link.com:9559/CSM

===== TPC installation errors =====

Error on VM: Graphical installers are not supported by the vm
http://www-01.ibm.com/support/docview.wss?uid=swg21462180


This problem can occur for the following reasons:

    The file /usr/lib/libstdc++.so.5.0.7 or later is not installed on the system.
    The $DISPLAY environment variable is not properly set.
    The necessary X Windows libraries for running the GUI installer are not available.

Resolving the problem

The solutions below relate to the cause above:

        Install libstdc++.so.5.0.7 or later.
        See the AppScan Source Edition release notes, which are included in the docs directory of the installation files for information on installing this library.
        Set your $DISPLAY environment variable to a valid display.

If you are on a 64-bit RHEL machine, you will also need to do the following:

        Install the missing 32-bit dependencies via the following command:
        yum install libgtk-x11-2.0.so.0
        Run the installation process with the system's default 64-bit JRE:
        ./setup.bin LAX_VM /usr/bin/java
        
===========================

Note: For Linux operating systems

    If you are planning to install Tivoli Storage Productivity Center Version 5.1 on 64-bit Red Hat Enterprise Version 5 or 6, you must ensure that you have the complete X Window System package group installed on your 64-bit Red Hat Enterprise Linux system.
    For 64-bit Red Hat Enterprise Linux Version 5, Tivoli Storage Productivity Center requires the following packages (libraries) for Tivoli Common Reporting:
        compat-libstdc++-33-3.2.3-61.i386 or later
        compat-glibc-2.3.4-2.26.i386 or later
        openmotif22-2.2.3-18.i386 or later

    Because Tivoli Common Reporting installs 32-bit binary files, you must install the 32-bit versions of these prerequisite packages (libraries), even on a 64-bit Red Hat Linux Version 5 system. Otherwise, the installation fails.
    In addition to the listed packages (libraries), Tivoli Storage Productivity Center also requires the following packages (libraries) for Red Hat Enterprise Linux Version 6:
        libXtst-1.0.99.2-3.el6.i686.rpm or later
        32-bit version of pam_krb5 (required on 32-bit and 64-bit system)

    To determine whether the 32-bit (i386) package is installed and which version is installed, use the
    --queryformat option for the rpm command:

    # rpm -q --queryformat='%{N}-%{V}-%{R}.%{arch}\n' compat-libstdc++-33-3.2.3-61 
    compat-glibc-2.3.4-2.26 openmotif22-2.2.3-18 | grep -v x86_64

    compat-libstdc++-33-3.2.3-61.i386
    compat-glibc-2.3.4-2.26.i386
    openmotif22-2.2.3-18.i386
    #

    To install the required packages (libraries), search the Red Hat Enterprise Linux installation media for these .rpm files:

    # find <Red Hat Enterprise Linux install media location> 
    -name compat-libstdc++-*.i386.rpm
    # find <Red Hat Enterprise Linux install media location> -name compat-glibc-*.i386.rpm
    # find <Red Hat Enterprise Linux install media location> -name openmotif22-*.i386.rpm

    After you locate the directory that contains the .rpm files, install or update these files to the required version. Use the -U option for the rpm command, for example:

    # rpm -U compat-libstdc++-33-3.2.3-61.i386.rpm compat-glibc-2.3.4-2.26.i386.rpm 
    openmotif22-2.2.3-18.i386.rpm

    Tip: The .rpm file versions on your installation media might differ from the preceding example.
    To verify that you have the .rpm files installed, use the --queryformat option for the rpm command to see the architecture of the .rpm files that were installed:

    # rpm -q --queryformat='%{N}-%{V}-%{R}.%{arch}\n' compat-libstdc++-33-3.2.3-61 
    compat-glibc-2.3.4-2.26 openmotif22-2.2.3-18 | grep -v x86_64

    compat-libstdc++-33-3.2.3-61.i386
    compat-glibc-2.3.4-2.26.i386
    openmotif22-2.2.3-18.i386
    #

=================================


==== Updated command for changing the DB2 password on the Data Server ====

The command to change the DB2 password on the Data Server has changed. TSRMsrv.zip has been replaced by TPC_Common.jar.

These are the updated commands:

On the Windows operating system:
<cli prompt='>'>
> C:\Program Files\IBM\TPC\data\config>\"program files"\ibm \tpc\jre\bin\java -classpath "\program files\ibm\tpc\data\server\lib\TPC_Common.jar" com.tivoli.itsrm.repository.Transform -p <new_password> repository.config
</cli>

On AIX/Linux operating systems:
<cli prompt='#'>
# /opt/IBM/TPC/jre/bin/java -classpath "/opt/IBM/TPC/data/server/lib/TPC_Common.jar" com.tivoli.itsrm.repository.Transform -p <new_password> repository.config 
</cli>

==== Ports used to access to TPC Web interface (firewall) ====

The port range from 9549 to 9581 must be open on a firewall.

===== Upgrade Spectrum Control =====

If needed upgrade first DB2 (cf Database part in this wiki)

Then set variables and upgrade
<cli prompt='#'>
# /opt/ibm/db2/V11.5/cfg/db2ln
# . /db2sc/.bash_profile
# cd SC_5.4.5.2/
# ./setup.bin
...Next
...Success
</cli>

===== Problem determination =====

==== Changing passwords on AIX and Linux systems with no X Window System installed ====

If you installed DB2®, Tivoli® Storage Productivity Center, or Jazz™ for Service Management on an AIX® or Linux server that does not have the X Window System installed, you can change the passwords for these products within Tivoli Storage Productivity Center by using the **changepassword_noX.sh** script.
About this task

Complete the following steps to change the DB2, Tivoli Storage Productivity Center, or Jazz for Service Management passwords within Tivoli Storage Productivity Center.
Procedure

    Open a command shell and change the directory to TPC_installation_directory/service.
    Run the changepassword_noX.sh script.
    At the prompt, enter the corresponding option for the product password that you want to change: jazz, tpc, or db.
    At the prompt, enter the new product password.
    Repeat the steps for each product password that you want to change.