Preparing a DB2 database

Before you install TADDM with a remote DB2® database, you must prepare the database.

You must install the DB2 database software on the database server.

Make sure that your database server meets all of the hardware and software requirements for a TADDM database server. For more information, see Planning for installation.

To prepare a DB2 database, complete the following steps:

  1. Optional: If you want to use a new DB2 instance for the TADDM database, use the db2icrt command to create the DB2 instance.

    Typically, the primary DB2 database user ID is the instance owner (db2inst1 on Linux® and UNIX systems, or db2admin on Windows systems). This database user ID is created during the DB2 installation. If you want to use the existing DB2 instance for the TADDM database, skip this step.

    For more information about the db2icrt command, see the DB2 documentation.

  2. Use the user-account management facilities of your operating system to create the secondary database user ID (the archiver user, typically archuser). Add it to the DB2 group of the DB2 instance owner.
    To have permission to access the database, the secondary database user ID must be in the same DB2 group as the DB2 instance owner. Add the secondary database user ID to one of the following groups:
    • Windows systems: DB2ADMNS
    • Linux and UNIX systems: db2grp1, db2iadm1
  3. Configure the DB2 by setting the following parameters:
    All versions of DB2
    db2 update dbm cfg using UTIL_IMPACT_LIM 95
    DB2 10.1, and later
    db2 update dbm cfg using SHEAPTHRES 0

    For more information about the parameters, see the DB2 documentation.

  4. From the product DVD, copy the following file to the system where the DB2 database is installed:
    • For Linux, and UNIX systems: support/bin/make_db2_db.sh
    • For Windows systems: support\bin\make_db2_db.bat
  5. Use one of the following procedures to run the make_db2_db script on the system where the DB2 database is installed:
    • For Linux and UNIX operating systems:
      1. Log in as the DB2 database instance owner. Use the db2inst1 ID.
      2. Run the following command: make_db2_db.sh taddm
    • For Windows operating systems:
      1. Open the DB2CMD command line.
      2. Run the following command: make_db2_db.bat taddm