Installing the DB2 schema configuration tool
If you choose to use DB2® as the data store for the application repository, you must install DB2 schema configuration tool before you install SmartCloud Application Performance Management UI. The DB2 schema configuration tool creates the files that are needed to configure the DB2 server database for the application repository. Optionally, the installer of the DB2 schema configuration tool can create the schema in DB2 for the application repository database. The application repository is the service component repository (SCR) in IBM SmartCloud® Application Performance Management UI.
Prerequisites
You need to run the DB2 schema configuration tool on the DB2 host where you want to install the application repository database. The application repository schema contains several user-defined functions (UDF's), and the JAR file that contains these functions must be on the DB2 host. You need to know the port for the DB2 instance.
The application repository requires DB2 9.7 Fix Pack 4 or higher. For more information about installing and using DB2, see the information center that is listed here for the version you are using:
If you want to create the application repository database schema during the installation, you must be logged on to the DB2 host as a user who has permissions to create database tables (SYSADM or SYSCTRL). Optionally, the installer can create the configuration files, and the tbsm_db script can be run to create the tables after the installation.
On Windows, the installer must be run from a command window that is opened by the DB2 db2cwadmin script. This script opens a command window with the DB2 environment and Windows administrative authorization. There are cases where the database configuration installer does not recognize the DB2 command environment when db2cmd is run. In these cases, run db2cwadmin to resolve the problem.
The installer creates the log file .../tbsmdb/logs/db2_stdout.log. This log file contains the output from all of the SQL that was executed. If there are any issues, this log file is very helpful.
Application repository database user
The user that application repository uses to connect to the DB2 database needs access to the application repository database. Although it can be the same user ID used to create the database setup, the primary requirement is to allow the runtime application repository administrator access to the application repository database. Application repository requires the ability to insert, update, and alter all application repository database objects and run administrative commands through its SQL connection.
As a best practice, the application repository administrator needs access to the DB2 database through a database query tool such as the DB2 Control Center or some other DB query tool that supports DB2. The Control Center or other tools are valuable for ongoing application repository database maintenance.