Once you have installed Tivoli Storage Productivity Center (TPC) a few times you are used to holding your breath and crossing your fingers in order to help the install go through error free. However there are a few more scientific ways of helping the install complete successfully.
For those that are new to TPC there are several components that need to be installed in the right order. These components and the order of install are:
- DB2 database server
- Agent Manager
- TPC DB Schema
- TPC server and client components
The most painful step of the install in my experience is the second step, the installation of the Agent Manger.
Below are several tips to ease the installation process:
1. Agent manager fails to install with return code 2 and no other information
Often the installation of the Agent Manager will begin then bomb out with a very vague message such as a “Return Code 2″. I am not sure what causes this but it has always occurred when logged into the TPC server as a domain admin. The solution has always been to login as a local admin (db2admin will work as it gets created during DB2 install).
2. Agent manager install on a 64bit DB2 database server.
The Agent manager supports both 32-bit and 64-bit DB2 database server. However the install wizard for the Agent Manager needs some spoon feeding to install on the 64-bit version. If you just select the option in the wizard to install onto a 64-bit DB2 server you will get an error stating that the DB2 database on localhost is not responding. The solution is to manually create the IBMCDB database manually before running the wizard. The process is described in the IBM manuals:
3. Install of TPC 4.1.1 DB schema fails with UTIL_HEAP_SZ errors
I have experienced a problem when installing the TPC database schema (step 3 in the process) where the install fails and there are messages in the <TPC install location>\log\dbSchema\install\dbSchemaInstall.log mentioning that UTIL_HEAP_SZ has run out of space.
UTIL_HEAP_SZ is a DB2 parameter. This parameter indicates the maximum amount of memory that can be used simultaneously by the BACKUP, RESTORE, and LOAD utilities.
The solution that I found was to increase this parameter while the install process was underway (you can’t do it before hand as the TPCDB database doesn’t exist). Below are the steps I used:
1. Start the TPC setup wizard and select a custom install and only install the DB Schema
2. While the install is running perform the following steps
3. Open the DB2 “Command Line Processor” This sets the environment for your command session.
4. Quit out of the “Command Line Processor” but keep the window open.
5. Enter the following commands:
db2 connect to tpcdb user <db2 username eg db2admin> using <password>
db2 update db cfg for tpcdb using util_heap_sz 524288
6. You can check that the setting has taken by using:
db2 get db cfg for tpcdb
7. Keep checking the parameter during the install because sometimes the setting seems to get changed automatically.
Hope someone finds these tips useful. Happy installing!