This guide does not provide installation instructions for DB2
Server. For a description of the DB2 installation process, read the DB2
online documentation on the DB2 product CD.
Notes:
- Building DB2 stored procedures requires a DB2 supported C or C++
compiler. This compiler is not supplied with the DB2 product and must
be obtained separately. For information about working with stored
procedures, read the DB2 documentation.
- DB2 Type 2 drivers must be installed on the same host as InterChange
Server before running the ICS installer. These drivers are not shipped
with ICS, but are included with the DB2 Server software.
- If DB2 is being used for the ICS repository and the DB2 Server is on
a different machine from the web server where System Monitor is installed,
then the DB2 Client must be installed on the same machine as the web server,
and it must be configured to point to the instance of the ICS
repository.
During the installation, an administrative instance and a database instance
are created. The administrative instance is transparent and allows you
to perform remote administration on your database instance.
Additionally, you are prompted to create a user ID and password that will be
used by the DB2 administration server to log on to the system and start itself
as a service. By default, the user ID is set to db2admin
. You can accept the default or create your own.
- Important:
- If the DB2 Server is not installed on the same machine as InterChange Server,
you must install a DB2 client on the ICS machine.
This section provides the following information for configuring the DB2
Server:
If you plan to use the Installer to install ICS and associated software,
you do not need to make the modifications in this section. Installer
generates the correct InterchangeSystem.cfg file. You
can skip this section and proceed to Opening the Control Center.
To modify the InterchangeSystem.cfg file:
- Click Start > Programs > IBM WebSphere InterChange Server > IBM
WebSphere InterChange Server > IBM WebSphere InterChange Server
Configuration Wizard.
- On the InterChange Server Configuration window, select the Database tab,
modify the parameters as needed, and then click Apply.
- Click OK when the Changes complete window appears.
- Click Exit.
The Control Center is the main DB2 graphical tool for administering your
database. It also provides an overview of all the systems and database
objects being managed. Use the Control Center to configure DB2 for your
specific InterChange Server environment.
Open the Control Center by selecting Start > Programs > IBM DB2 >
General Administration Tools > Control Center.
This section describes how to create the repository database for your
InterChange Server environment.
- Important:
- If you are using ICS in an internationalized environment, set the DB2
environment variable as follows: db2codepage = 1208
- Expand the MachineName under the System folder in
the left pane of the Control Center.
- On the Attach screen, type the database instance user ID and password that
you created during the DB2 installation process. Click OK.
- Expand the DB2 instance, right-click the Databases folder and select
Create > Database Using Wizard.
- On the Create Database Wizard screen, enter the new Database name and
Alias (for example, icsrepos for both), then click Finish.
- Note:
- There is no required name, but for consistency use icsrepos for
both. DB2 has an 8-character database name limit.
- A Progress screen will appear, showing that the new database is being
created.
This section describes how to configure the database instance for your
InterChange Server environment.
- Right-click the DB2 instance folder in the left pane of the Control Center
and click Configure.
- On the Configure Instance screen, click the Applications tab, scroll down
to the maxagents parameter, type a minimum of 50 in the Maximum
number of agents field, and click OK.
This section describes how to configure the repository database for your
InterChange Server environment.
- Expand the Instance, DB2 instance, and Databases folders in the left pane
of the Control Center, right-click the database_name
(for example, icsrepos), and select Configure Parameters.
- On the Configure Database screen, click the Performance tab, scroll down
to the applheapsz parameter, and type 4096 in the Application heap
size field.
- Click the Applications tab, scroll down to the maxappls
parameter, and type a minimum of 50 in the Maximum number of active
applications field. Click OK.
- Set the DB2_RR_TO_RS parameter to disable the next key locking
mechanism:
- Open a command line window.
- Type the following command:
db2set DB2_RR_TO_RS=yes
- Stop the database:
- Right-click the DB2 instance name and click Stop.
- Select the Disconnect all applications check box.
- Click OK.
- Click Close when the DB2STOP processing message appears.
- Restart the database for the modified configuration parameters to take
effect. To do this, right-click the database instance and click
Start.
- Click Close when the DB2START processing message appears.
- Close the Control Center.
You can create additional user accounts that have system administrator
privileges. This allows more than one person to administer the
database.
You can use the new user name and password to log into the Control
Center. To confirm that the user has been added, you can either create
a new database or go to the existing database, right-click its name, and click
Authorities. The new user name should appear. To create a new
user and add privileges:
- Click Start > Settings > Control Panel > Administrative Tools
> Computer Management.
- On the Computer Management screen, expand the Local Users and Groups
folder and double-click the Users folder.
- Click Action > New User from the menu bar.
- Type the User name and Password, clear the User Must Change Password at
Next Logon check box, and click Create.
- Right-click the new user in the right pane of the Computer Management
window and click Properties.
- Click the Member Of tab in the Properties screen, click Administrators,
and click Add.
- Click Administrators in the Select Groups window, click Add, and then
click OK.
- Use the new user name and password to log in to the Control Center to add
privileges. See Adding database authorities.
An authorization allows a user or group to perform a general task such as
connecting to a database, creating tables, or administering a system.
The database manager requires that a user be specifically authorized to use
each database function needed by that user to perform a specific task.
For example, to create a table, a user must be authorized to create
tables; to alter a table, a user must be authorized to alter the
table; and so on.
This section describes how to assign database authorization to a specified
user.
- Open the Control Center by selecting Start > Programs > IBM DB2 >
General Administration Tools > Control Center.
- Right-click the MachineName in the System folder in
the left pane of the Control Center and select Attach.
- On the Attach screen, enter the database instance User ID and Password
that you created during the DB2 installation process. Click OK.
- Expand the DB2 instance and Databases folders in the left pane of the
Control Center, right-click the database_name (for
example, icsrepos), and select Authorities.
- On the Database Authorities screen, click the Add User button, select the
name of the user, and click the Grant All button to give the selected user all
authorities.
- Click Apply, then OK.
