This section includes the following topics:
The default location for the FocalPoint installation, is on the same server as the Precise Framework. The General tab allows you to define a different server as the location for the FocalPoint installation.
To enter FocalPoint inputs
To enable sampling of Alerts custom metrics for this instance
Use the Schema tab to define schema specific configuration parameters. Select from the following list of schema options for DB2 Tier schema storage properties.
To enter Schema inputs
Click the drop-down menu and select a tablespace name or type the name of a new tablespace.
This is the name of the tablespace in which the Precise Framework Installer will create the DB2 schema. Specifying a tablespace name that does not appear in the list, will cause Precise Framework Installer to create a new tablespace for the schema. The tablespace name must comply with DB2's naming conventions. The new tablespace is created on the IBMCATGROUP node group only. To create the tablespace on a different node group, you need to create it manually. Reopen the Advanced dialog, click the Schema tab, and select the tablespace name from the drop-down menu. To enable Precise Framework Installer to create the tablespace, the DB2 user specified in the Tier installation instance properties, must have SYSCTRL and DBADM privileges or SYSADM privileges. |
Use the ERP Tab to define the SAP Interpoint.
The DB2 Tier Collectors can display correlated information on the activities and resource consumption of your SAP application components in your DB2 instance. Select this option to correlate SAP information with DB2 resource consumption. |
To install the SAP Interpoint for a DB2 instance
Enter the user name.
The SAP Interpoint uses this user to connect to the SAP system for retrieving system information. Verify that you are using an SAP user that you defined as part of the pre-installation tasks. For more information, see Pre-installation tasks for SAP. |
The DB2 installation process automatically installs schemas on the DB2 Instance. This process must be performed for each DB2 database installed. If you install DB2 database schemas only, FocalPoint schemas do not need to be previously installed.
To manually install DB2 database schemas only
infra\bin\psin_cli.bat
-i3-user user-name
{-i3-encrypted-password encrypted-password
| -i3-clear-password clear-password}
-action settings-update
-name manual-install-db2-schema
-value true
./infra/bin/psin_cli.sh
-i3-user user-name
{-i3-encrypted-password encrypted-password
| -i3-clear-password clear-password}
-action settings-update
-name manual-install-db2-schema
-value true
<precise_root>products\db2\install
on the machine that you wish to install upon. Open the relevant DB2 version folder, and perform the following:%%explain-tablespace%%
with the name of the tablespaces.%%tablespace-container%%
with the name of the container.%%sid%%
with the name of the database.%%instanceName%%
with the name of the instance.%%partition%%
with the partition number.To manually install DB2 database schemas
<precise_root>\products\db2\install\8.1\
install_I4UDB_Objects_8.1.sql
<precise_root>\products\db2\install\9.1\
install_I4UDB_Objects_9.1.sql
<precise_root>\products\db2\install\9.6\
install_I4UDB_Objects_9.6.sql
install_I4UDB_Objects_8.1.sql install_I4UDB_Objects_9.1.sql install_I4UDB_Objects_9.6.sql
| | | | | | | |