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:
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:
|
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. |
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. |
Property | Recommended value | Description |
---|---|---|
port |
|
Database server port for starting JDBC |
administrator |
|
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 |