Using the database wizard in silent mode for DB2

Run the database wizard in silent mode when you need an identical installation on multiple servers.

Before you begin

Ensure that the wizard has created the response.properties file in the user_settings/lcWizard/response/dbWizard directory.

To create a response file, run the wizard in standard mode and specify that you would like to create a response file. You can modify the existing response file or create your own, using a text editor. For more information, see the Database wizard response file topic.

(DB2® only) If you use only one database instance and if that instance includes other databases besides IBM® Connections, configure the numdb parameter to match the total number of databases on the instance. For more information, go to the numdb webpage in the DB2 information center.
Notes:
  • If you migrated from IBM Connections 4.5 or 5.0, the numdb parameter was set to 14, the maximum number of IBM Connections 4.5 or 5.0 databases. If the instance has additional databases, increase the value of the numdb parameter to match the total number of databases on the instance. To change the parameter, enter the following command:

    db2 UPDATE DBM CFG USING NUMDB nn

    where nn is a number of databases.

  • Before removing (or dropping) a database, stop Connections first to ensure that no database connection is in use; otherwise you will not drop the user and the database removal will not occur.
  • If you run dbWizard.bat but the database wizard does not launch, check whether you have 32-bit DB2 installed. You need to have 64-bit DB2 on a 64-bit system.

About this task

To create databases in silent mode, complete the following steps:

Procedure

  1. (DB2 on Windows™ OS.) You must perform DB2 administration tasks with full administrator privileges.
    1. Logged in as the instance owner, open a command prompt and change to the DB2 bin directory. For example: C:\Program Files\IBM\SQLLIB\BIN.
    2. Enter the following command: db2cwadmin.bat. This command opens the DB2 command line processor while also setting your DB2 privileges.
  2. From a command prompt, change to the directory where the wizard is located.
  3. Launch the wizard by running the following command:
    • AIX®: ./dbWizard.sh -silent response_file
    • Linux®: ./dbWizard.sh -silent response_file
    • Microsoft® Windows: dbWizard.bat -silent response_file
    where response_file is the file path to the response file.
    Note: If the path to the response_file contains a space, this parameter must be enclosed in double quotation marks (").

What to do next

After the wizard has finished, check the log file in the dbUser_home/lcWizard/log/dbWizard directory for messages. The log file name uses the time as a postfix. For example: dbConfig_20110308_202501.log.