The database wizard response file

The IBM® Connections database wizard can record your input in a response file that you can use for silent installations.

Why use a response file?

When you want to run the database wizard in silent mode, use the response file to duplicate the settings that you selected when you ran the wizard in interactive mode. You can start the wizard from a command prompt and then pass the response file in as a parameter. The wizard uses the values in the response file rather than requiring you to interact with it.

There is a sample response file called dbWizard_response.properties in the Wizards/samples directory on the IBM® Connections setup directory or installation media.

Response file properties

The response.properties file collects a specific set of values. Those values are described in the following table:

Table 1. Typical properties of the response.properties file
Property Value Description
dbtype db2 | oracle | sqlserver The database system that you want to use. Choose from IBM® DB2®, Oracle, or Microsoft SQL Server.
dbInstance database_instance_name The instance name of the database that you want to use. For example:
  • DB2® (DB2® on Windows)
  • db2inst1 (DB2® on AIX® or Linux)
  • orcl (Oracle)
  • \\ (SQL Server)
    Note: The first '\' is an escape character.
dbHome database_location File path to the database.
Note: If you encounter an Invalid database instance error, the file path to the database might be incorrect.

If the dbHome value is, for example, /home/oracle/oracle/product/10.2.0/db_1/, then you must remove the final / character. This limitation applies only on Oracle databases.

On Windows, you need to add an escape character '\'. For example, activities.filepath=C\:\\SQLSERVER.

action create | delete | upgrade The action performed by the wizard. The options are create, delete, or upgrade.
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 IBM® Connections applications for which the wizard creates databases. Use a comma (,) character to separate multiple applications.
If you are creating Oracle or SQL Server databases, you must add the additional properties described in the following table:
Table 2. Additional properties for Oracle or SQL Server databases
Property Value Description
<application>.password Password for application databases Password for the applications.
Note: The passwords will be removed from the response file after the wizard has finished processing.
<application>.filepath File path to the directory where database files are stored (SQL Server only) File path to the database file location.
Note: On Windows, you must add an escape character '\'. For example, activities.filepath=C\:\\SQLSERVER.
If you are upgrading databases and a JDBC connection is needed, you must add the additional properties described in the following table:
Table 3. Additional properties for upgrading databases with JDBC
Property Recommended value Description
port
  • DB2® default is 50000
  • Oracle default is 1521
  • SQL Server default is 1433
Database server port for starting JDBC
administrator
  • DB2® default on Windows is db2admin
  • DB2® default on AIX® and Linux is db2inst1
  • Oracle default is system
  • SQL Server default is sa
Database administrator account for starting JDBC
adminPassword Database administrator password for starting JDBC
jdbcLibPath (SQL Server only) JDBC library path for starting JDBC.
Note: On Windows, you must add an escape character '\'. For example, jdbcLibPath=C\:\\sqljdbc4.jar