Properties file: wkplc_dbdomain.properties

Each database domain has unique properties. As a result, you can separate the database domains on different database servers if needed. If all the domains are on a single server, then many of the properties are the same, such as the database type (DbType).

Release database properties

release.DbType

Description: The type of database to be used for the Release domain.
Default value: derby
Examples: None available

release.DbName

Description

The name of the release database. This value should also appear as the database element in DbUrl.

For remote IBM DB2 for i, the value must include the host name, such as: hostname/wpsreldb
For Linux and UNIX-based platforms using IBM DB2, this value is the TCPIP alias.
For IBM DB2 for i, the value must be unique for this domain.

Default value

wpsdb

Examples

None available

release.DbSchema

Description: The Release domain database schema name. For IBM DB2 for i, the scheme name must be less than ten characters. Some database management systems have restrictions for schema names. To define a valid schema name, see the documentation of the target database management system for guidance.
Default value: release
Examples: None available

release.DbNameOnZos

Description: Required for DB2 for z/OS only. The database for the Release domain. If WebSphere Portal is configured to use a remote DB2 for z/OS database, the value should be the name of the remote Release domain database.
Default value: WPSTST02
Examples: None available

release.DataSourceName

Description: The name of the datasource to use for the Release domain. You cannot use the following reserved names: releaseDS, communityDS, customizationDS, jcrDS, lmdbDS, feedback
Default value: wpdbDS
Examples: None available

release.DbUrl

Description: The wps Release domain database URL. This value should match the value of DbName property.
Default value: jdbc:derby:wpsdb;create=true
Examples: Apache Derby: jdbc:derby:wpsdb;create=true; IBM DB2 with type 2 drivers: jdbc:db2:wpsdb; IBM DB2 with type 4 drivers: jdbc:db2://YourDatabaseServer:50000/wpsdb:returnAlias=0; Where the port is usually 50000 (Windows) or 50001 (Linux); IBM DB2 for i with type 2 drivers: jdbc:db2:*LOCAL/wpsdb;metadata source=1; IBM DB2 for i with type 4 drivers: jdbc:as400:hostnamewpsdb;metadata source=1; Remote IBM DB2 for i with type 4 drivers: jdbc:as400:hostnamewpsdb;metadata source=1;prompt=false; DB2 for z/OS: jdbc:db2:location; Remote DB2 for z/OS with type 2 drivers: jdbc:db2:wpsdb; Remote DB2 for z/OS with type 4 drivers: jdbc:db2://YourDatabaseServer:port/location; Thin Oracle Database with type 4 drivers and thin client: jdbc:oracle:thin:@YourDatabaseServer:1521:wpsdb; Microsoft SQL Server 2005 and 2008: jdbc:sqlserver://YourDatabaseServer:1433;SelectMethod=cursor;DatabaseName=wpsdb; DataDirect SQL Server 2005 and 2008: jdbc:datadirect:sqlserver:/YourDatabaseServer:1433;DatabaseName=wpsdb

release.DbUser

Description: The database administrator user ID. If you are using a diifferent ID for configuration than you are using for runtime, specify the configuration ID.
Default value: db2admin
Examples: None available

release.DbPassword

Description: The database administrator password
Default value: ReplaceWithYourDbAdminPwd
Examples: None available

release.DbRuntimeUser

Description: Optional parameter. WebSphere Portal will use this ID to connect to the release database during day-to-day operations. This is also referred to as the runtime user. If you are not using two seperate IDs, one for configuration and one for runtime, leave this value blank.
Default value: No default value
Examples: None available

release.DbRuntimePassword

Description: The database runtime user password.
Default value: ReplaceWithYourDbRuntimePwd
Examples: None available

release.DBA.DbUser

Description: The DBA user for privledged access operations during creation of this database type.
Default value: db2admin
Examples: None available

release.DBA.DbPassword

Description: The DBA password for privledged access operations during creation of this database type
Default value: ReplaceWithYourDBAPwd
Examples: None available

release.DbHome

Description

The root location for the database.

For Oracle Database, enter the location on the remote or local machine for create the tablespaces.
For Microsoft SQL Server, enter the location locally to store the database files.
Microsoft SQL Server on Windows Only: This path must use \\ instead of /.
SQLServer Only:instance in the path below may or may not be there in your installation.

Default value

ReplaceWithYourDbHomeDir

Examples

Oracle Database: { oracle/product/10.1.0/db_1 }

Microsoft SQ LServer: { C:\\Microsoft SQL Server\\instance\\MSSQL }

release.AdminUrl

Description: Required for SQL Server only. The SQL server URL without a database attached. This value is used to connect to SQL Server for DBA operations.
Default value: ReplaceWithYourAdminUrl
Examples: DataDirect SQL Server 2005 and 2008: jdbc:datadirect:sqlserver://:1433; Microsoft SQL Server 2005 and 2008: jdbc:sqlserver://:1433

release.DbConfigRoleName

Description: The name of the role assigned to the configuration user ID (release.DbUser). If this role does not exist, create the role and assign it to the configuration ID.
Default value: WP_BASE_CONFIG_USERS
Examples: None available

release.DbRuntimeRoleName

Description: The name of the role assigned to the runtime user (release.DbRuntimeUser). If this role does not exist, create the role and assign it to the runtime user ID
Default value: WP_BASE_RUNTIME_USERS
Examples: None available

release.XDbName

Description: Required for Linux and UNIX platforms (non-Windows) when using DB2. Required only for a local DB2 database using Type 2 JDBC driver. The release database alias that needs to be set if you want to call create-database task.
Default value: wps6TCP
Examples: None available

release.DbNode

Description: Required for Linux and UNIX platforms (non-Windows) when using DB2. The node for the Release domain database and needs to be set if you want to call the create-database task.
Default value: wpsNode
Examples: None available

release.DbStorageGroup

Description: Required for DB2 for z/OS only. The storage group for the Release database.
Default value: WPSSG
Examples: None available

release.DbVolumes

Description: Required for DB2 for z/OS only. The volumes for the Release database.
Default value: *
Examples: None available

release.DbVcat

Description: Required for DB2 for z/OS only. The VCAT for the Release database.
Default value: DSN910
Examples: None available

release.DbIndex4KBufferPoolName

Description: Required for DB2 for z/OS only. The 4K bufferpool name for the Release database. This bufferpool is dedicated for the indices.
Default value: BP3
Examples: None available

release.Db4KBufferPoolName

Description: Required for DB2 for z/OS only. The 4K bufferpool name for the Release database.
Default value: BP2
Examples: None available

release.Db32KBufferPoolName

Description: Required for DB2 for z/OS only. The 32K bufferpool name for the Release database.
Default value: BP32K1
Examples: None available

release.TablespaceTrackMod

Description: Required for DB2 for z/OS only. Sets the TRACKMOD attribute of all tablespaces to the specified value. Before changing this value, see the DB2 for z/OS documentation about the attribute TRACKMOD.
Default value: YES
Examples: None available

release.TablespaceDefine

Description: Required for DB2 for z/OS only. Sets the DEFINE attribute of all tablespaces to the specified value. Before changing this value, see the DB2 for z/OS documentation about the attribute DEFINE.
Default value: NO
Examples: None available

Community database properties

community.DbType

Description: The type of database to be used for the Community domain.
Default value: derby
Examples: None available

community.DbName

Description

The name of the Community domain database. This value should also appear as the database element in DbUrl.

For Linux and UNIX platforms (non-Windows) using DB2, enter the TCPIP alias for the database.
For remote IBM DB2 for i, the value should include the host name, such as: hostName/wpscomdb

Default value

wpsdb

Examples

None available

community.DbSchema

Description: The Community domain database schema name. For IBM DB2 fori, the scheme name must be less than ten characters. Some database management systems have restrictions for schema names. To define a valid schema name, see the documentation of the target database management system for guidance.
Default value: community
Examples: None available

community.DbNameOnZos

Description: Required for DB2 for z/OS only. The name of the database for the Community domain. If WebSphere Portal is configured to use a remote DB2 for z/OS database, the value should be the name of the remote Community domain database.
Default value: WPSTST02
Examples: None available

community.DataSourceName

Description: The name of the datasource to use for the Community domain. You cannot use the following reserved names: releaseDS, communityDS, customizationDS, jcrDS, lmdbDS, feedback
Default value: wpdbDS
Examples: None available

community.DbUrl

Description

The wps Community domain database URL. The database element of this value should match the value of DbName property.

For IBM DB2 for i when WebSphere Portal is installed on a UNIX platform, add ;prompt=false to the URL unless X11 DISPLAY is set and active.
For IBM DB2 for z/OS, the database element of this value should match the location name of the database to be used when establishing connections with the IBM DB2 datasource used by the portal.

Default value

jdbc:derby:wpsdb;create=true

Examples

IBM DB2 using type 2 JDBC drivers: jdbc:db2:wpsdb

Apache Derby database: jdbc:derby:wpsdb;create=true

IBM DB2 with type 2 drivers: jdbc:db2:wpsdb

IBM DB2 with type 4 drivers: jdbc:db2://YourDatabaseServer:50000/wpsdb:returnAlias=0; Where the port is usually 50000 (Windows) or 50001 (Linux)

IBM DB2 for i with type 2 drivers: jdbc:db2:*LOCAL/wpsdb;metadata source=1

IBM DB2 for i with type 4 drivers: jdbc:as400:hostnamewpsdb;metadata source=1

Remote IBM DB2 for i with type 4 drivers: jdbc:as400:hostName/wpsdb;metadata source=1;prompt=false

DB2 for z/OS: jdbc:db2:location

Remote DB2 for z/OS with type 2 drivers: jdbc:db2:wpsdb

Remote DB2 for z/OS with type 4 drivers: jdbc:db2://YourDatabaseServer:port/location

Thin Oracle Database with type 4 drivers and thin client: jdbc:oracle:thin:@YourDatabaseServer:1521:wpsdb

Microsoft SQL Server 2005 and 2008: jdbc:sqlserver:/YourDatabaseServer:1433;SelectMethod=cursor;DatabaseName=wpsdb

DataDirect SQL Server 2005 and 2008: jdbc:datadirect:sqlserver:/YourDatabaseServer:1433;DatabaseName=wpsdb

community.DbUser

Description: The database user ID. If you are using a diifferent ID for configuration than you are using for runtime, specify the configuration ID.
Default value: db2admin
Examples: None available

community.DbPassword

Description: The database administrator password.
Default value: ReplaceWithYourDbAdminPwd
Examples: None available

community.DbRuntimeUser

Description: Optional parameter. WebSphere Portal will use this ID to connect to the Community database during day-to-day operations. If WebSphere Portal can connect using the same ID used during configuration, the community.DbUser value, then leave this value blank.
Default value: No default value
Examples: None available

community.DbRuntimePassword

Description: The database runtime user password.
Default value: ReplaceWithYourDbRuntimePwd
Examples: None available

community.DBA.DbUser

Description: The database administrator user for privileged access operations during creation of this database type.
Default value: db2admin
Examples: None available

community.DBA.DbPassword

Description: The database administrator user password for privileged access operations during creation of this database type.
Default value: ReplaceWithYourDBAPwd
Examples: None available

community.DbHome

Description

The root location for the database.

For Oracle Database, enter the location on the remote or local machine for create the tablespaces.
For SQL Server, enter the location locally to store the database files.
For SQL Server Windows Only: This path must use \\ instead of /.
For SQL Server Only: instance in the path below may or may not be there in your installation.

Default value

ReplaceWithYourDbHomeDir

Examples

Oracle Database: {oracle /product/10.1.0/db_1 }

SQL Server: { C:\\Microsoft SQL Server\\instance\\MSSQL }

community.AdminUrl

Description: Required for SQL Server only. The sqlserver URL without a database attached. This value is used to connect to SQL Server for DBA operations.
Default value: ReplaceWithYourAdminUrl
Examples: DataDirect SQL Server 2005 and 2008: jdbc:datadirect:sqlserver://:1433; Microsoft SQL Server 2005 and 2008: jdbc:sqlserver://:1433

community.DbConfigRoleName

Description: The name of the role assigned to the configuration user ID (community.DbUser). If this role does not exist, create the role and assign it to the configuration user ID.
Default value: WP_BASE_CONFIG_USERS
Examples: None available

community.DbRuntimeRoleName

Description: The name of the role assigned to the runtime user ID (community.DbRuntimeUser). If this role does not exist, create the role and assign it to the runtime user ID.
Default value: WP_BASE_RUNTIME_USERS
Examples: None available

community.XDbName

Description: Required for Linux and UNIX platforms (non-Windows) when using DB2. Required only for local DB2 database using Type 2 JDBC driver The Community database alias that needs to be set if you want to call create-database
Default value: wps6TCP
Examples: None available

community.DbNode

Description: Required for Linux and UNIX platforms (non-Windows) when using DB2. The node for the WebSphere Portal Community domain database and needs to be set if you want to call the create-database task.
Default value: wpsNode
Examples: None available

community.DbStorageGroup

Description: Required for DB2 for z/OS only. The storage group for the Community database.
Default value: WPSSG
Examples: None available

community.DbVolumes

Description: This parameter is required for DB2 for z/OS only. The volumes for the Community database.
Default value: *
Examples: None available

community.DbVcat

Description: Required for DB2 for z/OS only. The VCAT for the Community database.
Default value: DSN910
Examples: None available

community.DbIndex4KBufferPoolName

Description: Required for DB2 for z/OS only. The 4K bufferpool name for the Community database. This bufferpool is dedicated for the indices.
Default value: BP3
Examples: None available

community.Db4KBufferPoolName

Description: Required for DB2 for z/OS only. The 4K bufferpool name for the Community database.
Default value: BP2
Examples: None available

community.Db32KBufferPoolName

Description: Required for DB2 for z/OS only. The 32K bufferpool name for the Community database.
Default value: BP32K1
Examples: None available

community.TablespaceTrackMod

Description: Required for DB2 for z/OS only. Sets the TRACKMOD attribute of all tablespaces to the specified value. Before changing this value, see the DB2 for z/OS documentation about the attribute TRACKMOD.
Default value: YES
Examples: None available

community.TablespaceDefine

Description: Required for DB2 for z/OS only. Sets the DEFINE attribute of all tablespaces to the specified value. Before changing this value, see the DB2 for z/OS documentation about the attribute DEFINE.
Default value: NO
Examples: None available

Customization database properties

customization.DbType

Description: The type of database to be used for the Customization domain.
Default value: derby
Examples: None available

customization.DbName

Description

The name of the Customization database. This value should also appear as the database element in customization.DbUrl The following conditions effect the value for this property:

Linux and UNIX platforms (non-Windows) when using DB2 only enter the TCPIP alias for the database.
For IBM DB2 for i, this value must be unique for this domain.
For remote DB2 database for IBM i the value must include the host name, such as: hostname/wpscstdb

Default value

wpsdb

Examples

None available

customization.DbSchema

Description: The Customization domain database schema name. For IBM DB2 for i, the scheme name must be less than ten characters. Some database management systems have restrictions for schema names. To define a valid schema name, see the documentation of the target database management system for guidance.
Default value: customization
Examples: None available

customization.DbNameOnZos

Description: Required for DB2 for z/OS only. Enter the name of the database for the Customization domain. If WebSphere Portal is configured to use a remote DB2 for z/OS database, the value should be the name of the remote Customization domain database.
Default value: WPSTST02
Examples: None available

customization.DataSourceName

Description: The name of datasource to be used for Customization domain. You cannot use the following reserved names: releaseDS, communityDS, customizationDS, jcrDS, lmdbDS, feedback
Default value: wpdbDS
Examples: None available

customization.DbUrl

Description

The wps Customization domain database URL. The database element of this value should match the value of DbName property.

For IBM DB2 for i, when WebSphere Portal is installed on a UNIX platform, add ;prompt=false to the URL - unless X11 DISPLAY is set and active.
For IBM DB2 for z/OS, the database element of this value should match the location name of the database used when establishing connections with the IBM DB2 datasource used by the portal.

Default value

jdbc:derby:wpsdb;create=true

Examples

Apache Derby database: jdbc:derby:wpsdb;create=true

IBM DB2 with type 2 drivers: jdbc:db2:wpsdb

IBM DB2 with type 4 drivers: jdbc:db2://YourDatabaseServer:50000/wpsdb:returnAlias=0; Where the port is usually 50000 (Windows) or 50001 (Linux)

IBM DB2 for i with type 2 drivers: jdbc:db2:*LOCAL/wpsdb;metadata source=1

IBM DB2 for i with type 4 drivers: jdbc:as400:hostnamewpsdb;metadata source=1

Remote IBM DB2 for i with type 4 drivers: jdbc:as400:hostnamewpsdb;metadata source=1;prompt=false

DB2 for z/OS: jdbc:db2:location

Remote DB2 for z/OS with type 2 drivers: jdbc:db2:wpsdb

Remote DB2 for z/OS with type 4 drivers: jdbc:db2://YourDatabaseServer:port/location

Thin Oracle Database with type 4 drivers and thin client: jdbc:oracle:thin:@YourDatabaseServer:1521:wpsdb

Microsoft SQL Server 2005 and 2008: jdbc:sqlserver:/YourDatabaseServer:1433;SelectMethod=cursor;DatabaseName=wpsdb

DataDirect SQL Server 2005 and 2008: jdbc:datadirect:sqlserver:/YourDatabaseServer:1433;DatabaseName=wpsdb

customization.DbUser

Description: The database user ID. If you are using a diifferent ID for configuration than you are using for runtime, specify the configuration ID.
Default value: db2admin
Examples: None available

customization.DbPassword

Description: The database administrator password.
Default value: ReplaceWithYourDbAdminPwd
Examples: None available

customization.DbRuntimeUser

Description: Optional parameter. WebSphere Portal will use this ID to connect to the customization database during day-to-day operations. If WebSphere Portal can connect using the same ID used during configuration, the customization.DbUser value, then leave this value blank.
Default value: No default value
Examples: None available

customization.DbRuntimePassword

Description: The database runtime user password.
Default value: ReplaceWithYourDbRuntimePwd
Examples: None available

customization.DBA.DbUser

Description: The value is the DBA user for privledged access operations during creation of this database type.
Default value: db2admin
Examples: None available

customization.DBA.DbPassword

Description: The password for privledged access operations during creation of this database type.
Default value: ReplaceWithYourDBAPwd
Examples: None available

customization.DbHome

Description: The root location for the database. For Oracle Database, this is the location on the remote or local machine for create the tablespaces. For SQLServer this is the location locally to store the database files. SQLServer Windows Only: This path must use \\ instead of /. SQLServer Only: instance in the path below may or may not be there in your installation.
Default value: ReplaceWithYourDbHomeDir
Examples: Oracle Database: { oracle/product/10.1.0/db_1 }; SQLServer: { C:\\Microsoft SQL Server\\instance\\MSSQL }

customization.AdminUrl

Description: Required for SQL Server only. The sqlserver URL without a database attached. This value is used to connect to SQL Server for DBA operations.
Default value: ReplaceWithYourAdminUrl
Examples: DataDirect SQL Server 2005 and 2008: jdbc:datadirect:sqlserver://:1433; Microsoft SQL Server 2005 and 2008: jdbc:sqlserver://:1433

customization.DbConfigRoleName

Description: The name of the role assigned to the configuration user ID (customization.DbUser). If this role does not exist, create the role and assign it to the configuration ID.
Default value: WP_BASE_CONFIG_USERS
Examples: None available

customization.DbRuntimeRoleName

Description: The name of the role assigned to the runtime user ID (customization.DbRuntimeUser). If this role does not exist, create the role and assign it to the runtime user ID.
Default value: WP_BASE_RUNTIME_USERS
Examples: None available

customization.XDbName

Description: Required for Linux and UNIX platforms (non-Windows) when using DB2. Required only for local DB2 database using Type 2 JDBC driver. The customization database alias that needs to be set if you want to call create-database
Default value: wps6TCP
Examples: None available

customization.DbNode

Description: Required for Linux and UNIX platforms (non-Windows) when using DB2. The node for the Customization domain database and needs to be set if you want to call create-database.
Default value: wpsNode
Examples: None available

customization.DbStorageGroup

Description: Required for DB2 for z/OS only. The storage group for the WebSphere Portal customization database.
Default value: WPSSG
Examples: None available

customization.DbVolumes

Description: Required for DB2 for z/OS only. The volumes for the Customization database.
Default value: *
Examples: None available

customization.DbVcat

Description: Required for DB2 for z/OS only. The VCAT for the Customization database.
Default value: DSN910
Examples: None available

customization.DbIndex4KBufferPoolName

Description: Required for DB2 for z/OS only. The 4K bufferpool name for the Customization database. This bufferpool is dedicated for the indices.
Default value: BP3
Examples: None available

customization.Db4KBufferPoolName

Description: Required for DB2 for z/OS only. The 4K bufferpool name for the Customization database.
Default value: BP2
Examples: None available

customization.Db32KBufferPoolName

Description: Required for DB2 for z/OS only. The 32K bufferpool name for the Customization database.
Default value: BP32K1
Examples: None available

customization.TablespaceTrackMod

Description: Required for DB2 for z/OS only. This value sets the TRACKMOD attribute of all tablespaces to the specified value. Refer to the DB2 for z/OS documentation about attribute TRACKMOD before changing this value.
Default value: YES
Examples: None available

customization.TablespaceDefine

Description: Required for DB2 for z/OS only. Sets the DEFINE attribute of all tablespaces to the specified value. Before changing this value, see the DB2 for z/OS documentation about the attribute DEFINE.
Default value: NO
Examples: None available

JCR database properties

jcr.DbType

Description: The type of database to be used for the JCR domain.
Default value: derby
Examples: None available

jcr.DbName

Description

The name of the JCR database. This value should also appear as the database element in jcr.DbUrl

For non-Windows platforms when using DB2 only, enter the TCPIP alias for the database.
For IBM DB2 for i, this value must be unique for this domain
For remote IBM DB2 for i the value must include the host name, such as: hostname/wpscstdb

Default value

wpsdb

Examples

None available

jcr.DbSchema

Description: The JCR domain database schema name. For IBM DB2 for i, the scheme name must be less than ten characters. Some database management systems have restrictions for schema names. To define a valid schema name, see the documentation of the target database management system for guidance.
Default value: jcr
Examples: None available

jcr.DbNameOnZos

Description: Required for DB2 for z/OS only. The name of the database for the JCR domain. If WebSphere Portal is configured to use a remote DB2 for z/OS database, the value should be the name of the remote JCR domain database
Default value: WPSTST02
Examples: None available

jcr.DataSourceName

Description: The name of datasource to be used for JCR domain.You cannot use the following reserved names: releaseDS, communityDS, customizationDS, jcrDS, lmdbDS, feedback
Default value: wpdbDS
Examples: None available

jcr.DbUrl

Description

The wps JCR domain database URL.The database element of this value should match the value of DbName property.

For IBM DB2 for i when WebSphere Portal is installed on a UNIX platform, add ;prompt=false to the URL unless X11 DISPLAY is set and active.
For IBM DB2 for z/OS, the database element of this value should match the location name of the database to be used when establishing connections with the IBM DB2 datasource used by the portal.

Default value

jdbc:derby:wpsdb;create=true

Examples

Apache Derby database: jdbc:derby:wpsdb;create=true

IBM DB2 with type 2 drivers: jdbc:db2:wpsdb

IBM DB2 with type 4 drivers: jdbc:db2://YourDatabaseServer:50000/wpsdb:returnAlias=0; Where the port is usually 50000 (Windows) or 50001 (Linux)

IBM DB2 for i with type 2 drivers: jdbc:db2:*LOCAL/wpsdb;metadata source=1

IBM DB2 for i with type 4 drivers: jdbc:as400:hostName/wpsdb;metadata source=1

Remote IBM DB2 for i with type 4 drivers: jdbc:as400:hostName/wpsdb;metadata source=1;prompt=false

DB2 for z/OS: jdbc:db2:location

Remote DB2 for z/OS with type 2 drivers: jdbc:db2:wpsdb

Remote DB2 for z/OS with type 4 drivers: jdbc:db2://YourDatabaseServer:port/location

Thin Oracle Database with type 4 drivers and thin client: jdbc:oracle:thin:@YourDatabaseServer:1521:wpsdb

Microsoft SQL Server 2005 and 2008: jdbc:sqlserver:/YourDatabaseServer:1433;SelectMethod=cursor;DatabaseName=wpsdb

DataDirect SQL Server 2005 and 2008: jdbc:datadirect:sqlserver:/YourDatabaseServer:1433;DatabaseName=wpsdb

jcr.DbUser

Description: The database user ID. If you are using a diifferent ID for configuration than you are using for runtime, specify the configuration ID.
Default value: db2admin
Examples: None available

jcr.DbPassword

Description: The database administrator password.
Default value: ReplaceWithYourDbAdminPwd
Examples: None available

jcr.DbRuntimeUser

Description: Optional parameter. WebSphere Portal will use this ID to connect to the JCR database during day-to-day operations. If WebSphere Portal can connect using the same ID used during configuration, the jcr.DbUser value, then leave this value blank.
Default value: No default value
Examples: None available

jcr.DbRuntimePassword

Description: The database runtime user password.
Default value: ReplaceWithYourDbRuntimePwd
Examples: None available

jcr.DBA.DbUser

Description: The value is the DBA user for privledged access operations during creation of this database type.
Default value: db2admin
Examples: None available

jcr.DBA.DbPassword

Description: The password for privledged access operations during creation of this database type.
Default value: ReplaceWithYourDBAPwd
Examples: None available

jcr.DbHome

Description: The root location for the database. For Oracle Database, enter the location on the remote or local machine for create the tablespaces. For SQLServer enter the location locally to store the database files. SQLServer Windows Only: This path must use \\ instead of /. SQLServer Only: instance in the path below may or may not be there in your installation.
Default value: ReplaceWithYourDbHomeDir
Examples: None available

jcr.AdminUrl

Description: Required for SQL Server only. The sqlserver URL without a database attached. This value is used to connect to SQL Server for DBA operations.
Default value: ReplaceWithYourAdminUrl
Examples: DataDirect SQL Server 2005 and 2008: jdbc:datadirect:sqlserver://:1433; Microsoft SQL Server 2005 and 2008: jdbc:sqlserver://:1433

jcr.DbConfigRoleName

Description: The name of the role assigned to the configuration user ID (jcr.DbUser). If this role does not exist, create the role and assign it to the configuration ID.
Default value: WP_JCR_CONFIG_USERS
Examples: None available

jcr.DbRuntimeRoleName

Description: The name of the role assigned to the runtime user ID (jcr.DbRuntimeUser). If this role does not exist, create the role and assign it to the runtime user ID.
Default value: WP_JCR_RUNTIME_USERS
Examples: None available

jcr.XDbName

Description: Required for Linux and UNIX platforms (non-Windows) when using DB2. Required only for local DB2 database using Type 2 JDBC driver. The JCR database alias that needs to be set if you want to call create-database
Default value: wps6TCP
Examples: None available

jcr.DbNode

Description: Required for Linux and UNIX platforms (non-Windows) when using DB2. The node for the JCR domain database and needs to be set if you want to call the create-database task.
Default value: wpsNode
Examples: None available

jcr.DbSaPassword

Description: This parameter is optional for Microsoft SQL Server 2005. The SQL Server System Administrator password.
Default value: ReplaceWithYourDbAdminPwd
Examples: None available

jcr.DbHost

Description: Required for DB2 for z/OS. The host name (only) of remote system hosting the DB2 Content Manager Runtime Edition database.
Default value: ReplaceWithYourDbHost
Examples: None available

jcr.DbDomain

Description: Required for DB2 for z/OS. The domain (not including host name) of the remote system hosting the DB2 Content Manager Runtime Edition database.
Default value: yourco.com
Examples: None available

jcr.DbPort

Description: Required for DB2 for z/OS. The port number of DB2 Content Manager Runtime Edition database on the remote system.
Default value: 446
Examples: None available

jcr.ZosDbPrefix

Description: Required for DB2 for z/OS. The common prefix of Node Type database names for DB2 Content Manager Runtime Edition.
Default value: ICM
Examples: None available

jcr.ZosDbMaxTables

Description: Requiredfor DB2 for z/OS. The maximum number of User Defined Tables to be stored in a particular Node Type DB in the DB2 Content Manager Runtime Edition database.
Default value: 100
Examples: None available

jcr.DbStorageGroup

Description: Requiredfor DB2 for z/OS only. The storage group for the JCR database.
Default value: WPSSG
Examples: None available

jcr.DbVolumes

Description: Requiredfor DB2 for z/OS only. The volumes for the JCR database.
Default value: *
Examples: None available

jcr.DbVcat

Description: Requiredfor DB2 for z/OS only. The VCAT for the JCR database.
Default value: DSN910
Examples: None available

jcr.DbIndex4KBufferPoolName

Description: Requiredfor DB2 for z/OS only. The 4K bufferpool name for the JCR database. This bufferpool is dedicated for the indices.
Default value: BP3
Examples: None available

jcr.Db4KBufferPoolName

Description: Required for DB2 for z/OS only. The 4K bufferpool name for the JCR database.
Default value: BP2
Examples: None available

jcr.Db32KBufferPoolName

Description: Requiredfor DB2 for z/OS only. The 32K bufferpool name for the JCR database.
Default value: BP32K1
Examples: None available

jcr.TablespaceTrackMod

Description: Required for DB2 for z/OS only. Sets the TRACKMOD attribute of all tablespaces to the specified value. Refer to the DB2 for z/OS documentation about attribute TRACKMOD before changing this value.
Default value: YES
Examples: None available

jcr.TablespaceDefine

Description: Required for DB2 for z/OS only. Sets the DEFINE attribute of all tablespaces to the specified value. Before changing this value, see the DB2 for z/OS documentation about the attribute DEFINE.
Default value: NO
Examples: None available

The following properties are required to configure the JCR.

jcr.blobBufferpool

Description: Required only for IBM DB2 for z/OS and OS/390. The name of the bufferpool in which the BLOB tablespaces is created. If it is not specified, then the default value specified in the database is used.
Default value: BP32K1
Examples: None available

Feedback database properties

feedback.DbType

Description: The type of database that WebSphere Portal will use for the Feedback database.
Default value: derby
Examples: None available

InitializeFeedbackDB

Description: Determines how to handle the Personalization Feedback database during database transfer from Derby to another DB type.
Default value: true
Examples: None available

feedback.DbName

Description: The name of the Feedback database. The value should be the same as the database element in feedback.DbUrl value.
Default value: wpsdb
Examples: None available

feedback.DbSchema

Description: This value is the Feedback domain database schema name. For IBM DB2 for i, this value must be less than ten characters. Some database management systems have restrictions for schema names. To define a valid schema name, see the documentation of the target database management system for guidance.
Default value: FEEDBACK
Examples: None available

feedback.DbNameOnZos

Description: This parameter is required for IBM DB2 for z/OS only.
Default value: WPSTST02
Examples: None available

feedback.DataSourceName

Description: The name of the datasource to use for the Feedback database.
Default value: wpdbDS
Examples: None available

feedback.DbUrl

Description: The Feedback database URL.
Default value: jdbc:derby:wpsdb;create=true
Examples: Apache Derby: jdbc:derby:wpsdb;create=true; IBM DB2 with type 2 drivers: jdbc:db2:wpsdb; IBM DB2 with type 4 drivers: jdbc:db2://YourDatabaseServer:50000/wpsdb:returnAlias=0; Where the port is usually 50000 (Windows) or 50001 (Linux); IBM DB2 for i with type 2 drivers: jdbc:db2:*LOCAL/wpsdb;metadata source=1; IBM DB2 for i with type 4 drivers: jdbc:as400:hostName/wpsdb;metadata source=1; Remote IBM DB2 for i with type 4 drivers: jdbc:as400:hostName/wpsdb;metadata source=1;prompt=false; IBM DB2 for z/OS: jdbc:db2:location; Remote IBM DB2 for z/OS with type 2 drivers: jdbc:db2:wpsdb; Remote IBM DB2 for z/OS with type 4 drivers: jdbc:db2://YourDatabaseServer:;port/location; Thin Oracle Database with type 4 drivers and thin client: jdbc:oracle:thin:@YourDatabaseServer:1521:wpsdb; Microsoft SQL Server 2005 and 2008: jdbc:sqlserver://YourDatabaseServer:1433;SelectMethod=cursor;DatabaseName=wpsdb; DataDirect SQL Server 2005 and 2008: jdbc:datadirect:sqlserver://YourDatabaseServer:1433;DatabaseName=wpsdb

feedback.DbUser

Description: The database administrator user ID.
Default value: db2admin
Examples: None available

feedback.DbPassword

Description: The database password for the administrator user ID.
Default value: ReplaceWithYourDbAdminPwd
Examples: None available

feedback.DbRuntimeUser

Description: Optional parameter. WebSphere Portal will use this ID to connect to the Feedback database during day-to-day operations. If WebSphere Portal can connect using the same ID used during configuration, the feedback.DbUser value, then leave this value blank.
Default value: No default value
Examples: None available

feedback.DbRuntimePassword

Description: The password for the runtime user ID.
Default value: ReplaceWithYourDbRuntimePwd
Examples: None available

feedback.DBA.DbUser

Description: The DBA user ID for privileged access operations during creation of this database type.
Default value: db2admin
Examples: None available

feedback.DBA.DbPassword

Description: The password for the privileged DBA user ID used to access operations during creation of the Feedback database.
Default value: ReplaceWithYourDBAPwd
Examples: None available

feedback.DbHome

Description

The root location for the Feedback database.

For Oracle Database, this is the location on the remote or local database server where the tablespaces are created.
For SQL Server, this is the local location where the database files are stored.
For SQL Server on Windows the path must use two back slashes (\\) instead of a forward slash (/).
For SQL Server theinstance in the example path below may or may not exist for your installation.

Default value

ReplaceWithYourDbHomeDir

Examples

Oracle: oracle/product/10.1.0/db_1

SQL Server: C:\\Microsoft SQL Server\\instance\\MSSQL

feedback.AdminUrl

Description: This parameter is required for SQL Server only. This value is the SQL Server URL without a database attached. This value is used to connect to SQL Server for DBA operations.
Default value: ReplaceWithYourAdminUrl
Examples: Microsoft SQL Server 2005: jdbc:sqlserver://YourDatabaseServer:1433; DataDirect SQL Server 2005: jdbc:datadirect:sqlserver://YourDatabaseServer:1433; Microsoft SQL Server 2008: jdbc:sqlserver://YourDatabaseServer:1433; DataDirect SQL Server 2008: jdbc:datadirect:sqlserver://YourDatabaseServer:1433

feedback.DbConfigRoleName

Description: The role assigned to the configuration user ID (feedback.DbUser). If the role does not exist, create it and associate it with the configuration user ID.
Default value: WP_PZN_CONFIG_USERS
Examples: None available

feedback.DbRuntimeRoleName

Description: The role assigned to the runtime user ID (feedback.DbRuntimeUser). If the role does not exist, create it and associate it with the configuration user ID.
Default value: WP_PZN_RUNTIME_USERS
Examples: None available

feedback.XDbName

Description: Required for Linux and UNIX-based platforms when using a IBM DB2 database. Required for a local IBM DB2 Database using a type 2 JDBC driver. The Feedback database alias that needs to be set if you want to call create-database
Default value: fdbk6TCP
Examples: None available

feedback.DbNode

Description: Required for Linux and UNIX-based platforms when using IBM DB2. The node for the Feedback database The value is required if you want to run thecreate-database task.
Default value: pznNode
Examples: None available

feedback.DbHostName

Description: Required for Microsoft SQL Server 2005 and 2008 only. The host name of the Feedback database.
Default value: myserver
Examples: None available

feedback.DbTablespace

Description: Required for IBM DB2 for z/OS only. The name of the Feedback database tablespace.
Default value: fdbkdbts
Examples: None available

feedback.DbStorageGroup

Description: Required for IBM DB2 for z/OS only. The storage group for the Feedback database.
Default value: WPSSG
Examples: None available

feedback.DbVolumes

Description: Required for IBM DB2 for z/OS only. The volumes for the Feedback database.
Default value: *
Examples: None available

feedback.DbVcat

Description: Required for IBM DB2 for z/OS only. The VCAT for the WebSphere Portal Feedback database.
Default value: DSN910
Examples: None available

feedback.Db4KBufferPoolName

Description: Required for IBM DB2 for z/OS only. The 4K bufferpool name for the Feedback database.
Default value: BP2
Examples: None available

feedback.Db32KBufferPoolName

Description: Required for IBM DB2 for z/OS only. The 32K bufferpool name for the Feedback database.
Default value: BP32K1
Examples: None available

LikeMinds database properties

likeminds.DbType

Description: The type of database to be used for the Likeminds database.
Default value: derby
Examples: None available

likeminds.DbName

Description: The name of the Likeminds database. This value should also appear as the database element in likeminds.DbUrl.
Default value: wpsdb
Examples: wplsdb

likeminds.DbSchema

Description: The Likeminds domain database schema name. For IBM DB2 for i, this value must be less than ten characters. Some database management systems have restrictions for schema names. To define a valid schema name, see the documentation of the target database management system for guidance.
Default value: likeminds
Examples: likeminds

likeminds.DbNameOnZos

Description

This parameter is required for IBM DB2 for z/OS only. The following conditions effect the value for this property:

If the database type is IBM DB2 for z/OS (db2_zos) and the database is remote, this value is the name of the remote Likeminds domain database.
If WebSphere Portal is installed on z/OS with a local database (database type is db2_zos), this value must be the same value as the database name (DbName).

Default value

WPSTST02

Examples

None available

likeminds.DataSourceName

Description: The name of the datasource that will be used for the Likeminds domain.
Default value: wpdbDS
Examples: None available

likeminds.DbUrl

Description: The Likeminds domain database URL.
Default value: jdbc:derby:wpsdb;create=true
Examples: Derby database: jdbc:derby:wpsdb;create=true; IBM DB2 with type 2 drivers: jdbc:db2:wpsdb; IBM DB2 with type 4 drivers: jdbc:db2://YourDatabaseServer:50000/wpsdb:returnAlias=0; Where the port is usually 50000 (Windows) or 50001 (Linux); IBM DB2 for i with type 2 drivers: jdbc:db2:*LOCAL/wpsdb;metadata source=1; IBM DB2 for i with type 4 drivers: jdbc:as400:hostName/wpsdb;metadata source=1; Remote IBM DB2 for i with type 4 drivers: jdbc:as400:hostName/wpsdb;metadata source=1;prompt=false; IBM DB2 for z/OS: jdbc:db2:location; Remote IBM DB2 for z/OS with type 2 drivers: jdbc:db2:wpsdb; Remote IBM DB2 for z/OS with type 4 drivers: jdbc:db2://YourDatabaseServer:port/location; Thin Oracle Database with type 4 drivers and thin client: jdbc:oracle:thin:@YourDatabaseServer:1521:wpsdb; Microsoft SQL Server 2005 and 2008: jdbc:sqlserver://YourDatabaseServer:1433;SelectMethod=cursor;DatabaseName=wpsdb; DataDirect SQL Server 2005 and 2008: jdbc:datadirect:sqlserver://YourDatabaseServer:1433;DatabaseName=wpsdb

likeminds.DbUser

Description: The database administrator user ID.
Default value: db2admin
Examples: None available

likeminds.DbPassword

Description: The database administrator password.
Default value: ReplaceWithYourDbAdminPwd
Examples: None available

likeminds.DbRuntimeUser

Description: Optional parameter. WebSphere Portal will use this ID to connect to the Likeminds database during day-to-day operations. WebSphere Portal can connect using the same ID used during configuration, the likeminds.DbUser value, then leave this value blank.
Default value: No default value
Examples: None available

likeminds.DbRuntimePassword

Description: The password for the database runtime user.
Default value: ReplaceWithYourDbRuntimePwd
Examples: None available

likeminds.DBA.DbUser

Description: The DBA user ID for privileged access operations during creation of this database type.
Default value: db2admin
Examples: None available

likeminds.DBA.DbPassword

Description: The password for priviledged access operations during creation of this database type.
Default value: ReplaceWithYourDBAPwd
Examples: None available

likeminds.DbHome

Description: The root location for the database. For Oracle Database this is the location on the remote or local server where the tablespaces are created. For SQL Server this is the location locally to store the database files.
Default value: ReplaceWithYourDbHomeDir
Examples: Oracle Database: oracle/product/10.1.0/db_1; SQL Server: C:\\Microsoft SQL Server\\instance\\MSSQL

likeminds.AdminUrl

Description: Required for SQL Server only. This value is the SQL Server URL without a database attached. This value is used to connect to SQL Server for DBA operations.
Default value: ReplaceWithYourAdminUrl
Examples: Microsoft SQL Server 2005: jdbc:sqlserver://YourDatabaseServer:1433; DataDirect SQL Server 2005: jdbc:datadirect:sqlserver://YourDatabaseServer:1433; Microsoft SQL Server 2008: jdbc:sqlserver://YourDatabaseServer:1433; DataDirect SQL Server 2008: jdbc:datadirect:sqlserver://YourDatabaseServer:1433

likeminds.DbConfigRoleName

Description: The role assigned to the configuration user ID (likeminds.DbUser). If the role does not exist, create the role and assign it to the configuration user ID.
Default value: WP_PZN_CONFIG_USERS
Examples: None available

likeminds.DbRuntimeRoleName

Description: The role assigned to the runtime user ID (likeminds.DbRuntimeUser). If the role does not exist, create the role and assign it to the runtime user ID
Default value: WP_PZN_RUNTIME_USERS
Examples: None available

likeminds.XDbName

Description: Required for Linux and UNIX-based platforms when using an IBM DB2 Database. Required Windows platforms using a local IBM DB2 database using Type 2 JDBC drivers. The Likeminds database alias that is used when running thecreate-database task.
Default value: lmdb6TCP
Examples: None available

likeminds.DbNode

Description: Required for Linux and UNIX-based platforms when using an IBM DB2 Database. The node for the Likeminds domain database that is used when running thecreate-database task.
Default value: pznNode
Examples: None available

likeminds.DbHostName

Description: Required only for Microsoft SQL Server 2005 and 2008. The host name of the Likeminds database.
Default value: myserver
Examples: None available

likeminds.DbTablespace

Description: Required only for IBM DB2 for z/OS. The name of the Likeminds database table space.
Default value: lmdbts
Examples: None available

likeminds.DbStorageGroup

Description: Required only for IBM DB2 for z/OS. The storage group for the Likeminds database.
Default value: WPSSG
Examples: None available

likeminds.DbVolumes

Description: Required only for BM DB2 for z/OS. The volumes for the Likeminds database.
Default value: *
Examples: None available

likeminds.DbVcat

Description: Required only for IBM DB2 for z/OS. The VCAT for the Likeminds database.
Default value: DSN910
Examples: None available

likeminds.Db4KBufferPoolName

Description: Required only for IBM DB2 for z/OS. The 4K bufferpool name for the Likeminds database.
Default value: BP2
Examples: None available

likeminds.Db32KBufferPoolName

Description: Required only for IBM DB2 for z/OS. The 32K bufferpool name for the Likeminds database.
Default value: BP32K1
Examples: None available