IBM DB2 Server

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:

  1. 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.

  2. 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.

  3. 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:

Modifying the InterchangeSystem.cfg file

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:

  1. Click Start > Programs > IBM WebSphere InterChange Server > IBM WebSphere InterChange Server > IBM WebSphere InterChange Server Configuration Wizard.
  2. On the InterChange Server Configuration window, select the Database tab, modify the parameters as needed, and then click Apply.
  3. Click OK when the Changes complete window appears.
  4. Click Exit.

Opening the Control Center

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.

Creating the repository database

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
  1. Expand the MachineName under the System folder in the left pane of the Control Center.
  2. On the Attach screen, type the database instance user ID and password that you created during the DB2 installation process. Click OK.
  3. Expand the DB2 instance, right-click the Databases folder and select Create > Database Using Wizard.
  4. 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.
  5. A Progress screen will appear, showing that the new database is being created.

Configuring the database instance

This section describes how to configure the database instance for your InterChange Server environment.

  1. Right-click the DB2 instance folder in the left pane of the Control Center and click Configure.
  2. 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.

Configuring the repository database

This section describes how to configure the repository database for your InterChange Server environment.

  1. 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.
  2. On the Configure Database screen, click the Performance tab, scroll down to the applheapsz parameter, and type 4096 in the Application heap size field.
  3. 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.
  4. Set the DB2_RR_TO_RS parameter to disable the next key locking mechanism:
    1. Open a command line window.
    2. Type the following command:

      db2set DB2_RR_TO_RS=yes

  5. Stop the database:
    1. Right-click the DB2 instance name and click Stop.
    2. Select the Disconnect all applications check box.
    3. Click OK.
    4. Click Close when the DB2STOP processing message appears.
  6. Restart the database for the modified configuration parameters to take effect. To do this, right-click the database instance and click Start.
  7. Click Close when the DB2START processing message appears.
  8. Close the Control Center.

Adding a new user

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:

  1. Click Start > Settings > Control Panel > Administrative Tools > Computer Management.
  2. On the Computer Management screen, expand the Local Users and Groups folder and double-click the Users folder.
  3. Click Action > New User from the menu bar.
  4. Type the User name and Password, clear the User Must Change Password at Next Logon check box, and click Create.
  5. Right-click the new user in the right pane of the Computer Management window and click Properties.
  6. Click the Member Of tab in the Properties screen, click Administrators, and click Add.
  7. Click Administrators in the Select Groups window, click Add, and then click OK.
  8. Use the new user name and password to log in to the Control Center to add privileges. See Adding database authorities.

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.

  1. Open the Control Center by selecting Start > Programs > IBM DB2 > General Administration Tools > Control Center.
  2. Right-click the MachineName in the System folder in the left pane of the Control Center and select Attach.
  3. On the Attach screen, enter the database instance User ID and Password that you created during the DB2 installation process. Click OK.
  4. 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.
  5. 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.
  6. Click Apply, then OK.

Copyright IBM Corp. 1997, 2004