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

  • 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:
Attention: HCL Connections 6.5 install wizard does not create the database for the Community Highlights / Connections Engagement Center (ICEC) application. You will need to manually run the SQL scripts that are provided with HCL Connections. See Creating IBM DB2 databases manually to create the ICEC database.


  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®: ./ -silent response_file
    • Linux®: ./ -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.