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:


  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.