The database wizard response file

Home

The database wizard response file

The Lotus 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 on the Lotus Connections installation media. There is a sample response file in the Wizards/samples called dbWizard_response.properties.
The response.properties file collects a specific set of values. Those values are described in the following table:

Typical properties of the response.properties file

Property Value Description
dbtype db2 | oracle | sqlserver The database system to use. Choose from IBM DB2®, Oracle, or Microsoft SQL Server.
dbInstance <database_instance_name> The instance name of the database to use. For example:

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

dbHome <database_locatFion> File path to the database.
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.
features activities, blogs, communities, dogear, files, homepage, profiles, wikis Lotus Connections features for which the wizard will create databases. Use a comma (,) character to separate multiple features.

If you are creating Oracle or SQL Server databases, you need to add the additional properties described in the following table:

Additional properties for Oracle or SQL Server databases

Property Value Description
feature.password Password for feature databases Password for the features.
The passwords will be removed from the response file after the wizard has finished.
feature.filepath File path to the where database files are stored (SQL Server only) File path to the database file location.
On Windows, you need to add an escape character '\'. For example, activities.filepath=C\:\\SQLSERVER.

If you are upgrading databases and a JDBC connection is needed, you need to add the additional properties described in the following table:

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 invoking 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 invoking JDBC
adminPassword Database administrator password for invoking JDBC
jdbcLibPath (SQL Server only) JDBC library path for invoking JDBC.
On Windows, you need to add an escape character '\'. For example, jdbcLibPath=C\:\\sqljdbc.jar
forum.contentStore (Communities only)
Path to the Communities forum content store
The content store can be located in a local directory or a shared network Ensure that the is accessible within your deployment.

Using the database wizard in silent mode

Related reference

The tdisettings.properties file

+
Search Tips | Advanced Search

Property	Value	Description
dbtype	db2 \| oracle \| sqlserver	The database system to use. Choose from IBM DB2®, Oracle, or Microsoft SQL Server.
dbInstance	<database_instance_name>	The instance name of the database to use. For example: DB2 (DB2 on Windows®) db2inst1 (DB2 on AIX or Linux®) orcl (Oracle) \\ (SQL Server) The first '\' is an escape character.
dbHome	<database_locatFion>	File path to the database. 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.
features	activities, blogs, communities, dogear, files, homepage, profiles, wikis	Lotus Connections features for which the wizard will create databases. Use a comma (,) character to separate multiple features.

Property	Value	Description
feature.password	Password for feature databases	Password for the features. The passwords will be removed from the response file after the wizard has finished.
feature.filepath	File path to the where database files are stored	(SQL Server only) File path to the database file location. On Windows, you need to add an escape character '\'. For example, activities.filepath=C\:\\SQLSERVER.

Property	Recommended value	Description
port	DB2 default is 50000 Oracle default is 1521 SQL Server default is 1433	Database server port for invoking 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 invoking JDBC
adminPassword		Database administrator password for invoking JDBC
jdbcLibPath		(SQL Server only) JDBC library path for invoking JDBC. On Windows, you need to add an escape character '\'. For example, jdbcLibPath=C\:\\sqljdbc.jar
forum.contentStore (Communities only)		Path to the Communities forum content store The content store can be located in a local directory or a shared network Ensure that the is accessible within your deployment.