Setting up a DB2 database

Set up a supported DB2® database to work with the Rational Requirements Composer 2.0 Server.

Before you begin

Check for the following prerequisites before you set up your DB2 database to work with Rational Requirements Composer Server. Talk to your DB2 database administrator for additional help.
  1. Your system meets the minimum hardware and software requirements for DB2.
  2. The user who is setting up the DB2 database has administrative privileges.
    Note: Linux® users: To obtain administrative privileges for the DB2 database, sudo to DB2 user db2fenc1 and run bash.
  3. DB2 is installed and running on the machine that will be used as the database server.
    Note: The machine that you wish to use as the database server can be different from the one on which the Rational® Requirements Composer 2.0 Server is running.

Procedure

To setup a DB2 database:

  1. In Windows, open the DB2 Command Window by clicking Start > All Programs > IBM DB2 > Command Line Tools > Command Window.
  2. Type the following command (only an example to create a new database called RRC) in the Command Window:
    • Windows users:
      db2 create database RRC on c: using codeset UTF-8 territory en PAGESIZE 8192
    • Linux® users:
      db2 create database RRC using codeset UTF-8 territory en PAGESIZE 8192
    Note: (a) UTF-8 encoding is essential to ensure proper handling of Unicode content. (b) The page size should be set to at least 8K, because the AUDITABLE_LINKS table does not fit in the default page size of 4K in Windows.

    Troubleshooting: When setting up a database, a user must be authorized to access the database that you are trying to connect to. To check whether a user has access to a database, right click on the database, and click Authorities. If you get error messages when connecting to the database, you might need to add a particular user to the database and also make that user a database administrator.

    Return to the installation road map


Feedback