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.

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.

The response file is named dbWizard_response.properties and is stored by default in the Wizards/DBWizard directory on the IBM Connections set-up directory installation media. There is a sample response file in the Wizards/samples directory called dbWizard_response.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_locatFion> 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 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, communities, dogear, files, forum, homepage, 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, 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, add an escape character '\'. For example, activities.filepath=C\:\\SQLSERVER.

If you are upgrading databases and a JDBC connection is needed, 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 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, add an escape character '\'. For example, jdbcLibPath=C\:\\sqljdbc4.jar


Parent topic

Use the database wizard in silent mode


Related tasks


Uninstall databases in silent mode
Use the database wizard in silent mode

Related reference
The tdisettings.properties file


   

 

});

+

Search Tips   |   Advanced Search