The database wizard response file

The database wizard response file

Overview

The IBM Connections database wizard can record the input in a response file. After recording, we can start the wizard from a command prompt, and then pass the response file as a parameter.
Sample response file...
Wizards/samples/dbWizard_response.properties

Values in response.properties file

Property Value Description
dbtype db2 | oracle | sqlserver The database system to use.
dbInstance database_instance_name

DB2 DB2 on Windows
db2inst1 DB2 on AIX or Linux
orcl Oracle
\\ SQL Server
The first '\' is an escape character.

dbHome /path/to/database/home For Oracle databases, if dbHome value is, for example...
/home/oracle/oracle/product/10.2.0/db_1/

...remove the final / character.
If we encounter error...
Invalid database instance

...the file path to the database might be incorrect.
On Windows, add an escape character '\'. For example...

activities.filepath=C\:\\SQLSERVER

action create | delete | upgrade The action performed by the wizard.
dbVersion DB2: 9 or 10 | Oracle: 11| SQL Server: 10 The major version number of the database type.
features activities, blogs, cognos, communities, dogear, files, forum, homepage, libraries, metrics, mobile, profiles, wikis Apps for which the wizard creates databases. Use a comma (,) character to separate multiple applications.

If we are creating Oracle or SQL Server ...

Property Value Description
<application>.password Password for application databases Password for the applications.
The passwords will be removed from the response file after the wizard has finished processing.
<application>.filepath Path to the directory where database files are stored (SQL Server only) Path to the database file location.
On Windows, add an escape character '\'. For example, activities.filepath=C\:\\SQLSERVER.

If we are upgrading databases and a JDBC connection is needed, add additional properties...

Property Recommended value Description
port

DB2 50000
Oracle 1521
SQL Server 1433

Database server port for starting JDBC
administrator

DB2 on Windows db2admin
DB2 on AIX and Linux db2inst1
Oracle system
SQL Server sa

Database administrator account for starting JDBC
adminPassword Database administrator password for starting JDBC
jdbcLibPath (SQL Server only) JDBC library path for starting JDBC.
On Windows, add an escape character '\'. For example, jdbcLibPath=C\:\\sqljdbc4.jar

Parent topic:
Use the database wizard in silent mode

Related:
Uninstall databases in silent mode
Use the database wizard in silent mode
The tdisettings.properties file

Property	Value	Description
<application>.password	Password for application databases	Password for the applications. The passwords will be removed from the response file after the wizard has finished processing.
<application>.filepath	Path to the directory where database files are stored	(SQL Server only) Path to the database file location. On Windows, add an escape character '\'. For example, activities.filepath=C\:\\SQLSERVER.