The database wizard response fileAdded by IBM on February 11, 2013 | Version 1 (Original)
|The IBM® Connections database wizard can record your input in a response file that you can use for silent installations.
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 set-up directory or installation media.
file collects a specific set of values. Those values are described in the following table:
Table 1. Typical properties of the response.properties file
|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 | Oracle: 10 or 11| SQL Server 2005:9 SQL Server 2008: 10||The major version number of the database type. |
For example, if you use SQL Server 2005, enter 9. If you use SQL Server 2008, enter 10.
|applications||activities, blogs, cognos, communities, dogear, files, forum, homepage, 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
|<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
Parent topic: Using the database wizard in silent mode
Uninstalling databases in silent mode
Using the database wizard in silent mode
The tdisettings.properties file
- DB2 default is 50000
- Oracle default is 1521
- SQL Server default is 1433
|Database server port for starting JDBC|
- 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|
|Database administrator password for starting JDBC|
|The Home page upgrade requires this parameter. It should be the same as the value in the news-config.xml file.|
|profiles.db.name profiles.db.hostname profiles.db.port profiles.db.admin profiles.db.adminPassword|
|The Home page migration process copies data from the Profiles database. For this reason, you must update the Home page database before updating the Profiles database. The migration process supports the use of different instances to host the Home page and Profiles databases.|
|(SQL Server only) JDBC library path for starting JDBC.|
Note: On Windows, you must add an escape character '\'. For example, jdbcLibPath=C\:\\sqljdbc4.jar