Use the database wizard in silent mode
Overview
To create a response file, run the wizard in standard mode and specify that you would like to create a response file....
Ensure the wizard has created...
user_settings/lcWizard/response/dbWizard/response.properties
DB2 only
- If we 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. See numdb webpage >.
If we migrated from IBM Connections 4.5, the numdb parameter was set to 14, the maximum number of Connections 4.5 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 set:
db2 UPDATE DBM CFG USING NUMDB nn
where nn is a number of databases.
- If we run dbWizard.bat but the database wizard does not launch, check whether you have 32-bit DB2 installed. We need to have 64-bit DB2 on a 64-bit system.
(Oracle only) Set the Statement cache size for the data sources on WAS to be no larger than 50. A higher value could lead to Out Of Memory errors on the application server instance.
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.
Create databases in silent mode
- (DB2 on Windows 2008 64-bit.) On Windows 2008, perform DB2 administration tasks with full administrator privileges.
Logged in as the instance owner, open a command prompt and run...
cd C:\IBM\SQLLIB\BIN.
db2cwadmin.batThis command opens the DB2 command line processor while also setting the DB2 privileges.
- Launch the wizard ...
./dbWizard.sh -silent /path/to/response_file
- After the wizard has finished, check the log file in...
dbUser_home/lcWizard/log/dbWizard
For example:
dbConfig_20110308_202501.log
Parent topic:
Create databases with the database wizardRelated reference: