Properties file: prereq.pzn_dbdomain.properties

Table of contents

1. Personalization Feedback Database Properties
2. LikeMinds Database Properties

Parent: Configuration properties reference

1. Personalization 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

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

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 the installation.

Default value

ReplaceWithYourDbHomeDir

Examples

Oracle: oracle/product/10.1.0/db_1

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

feedback.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

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 DB2 database. Required for a local IBM DB2 Database using a type 2 JDBC driver. The Feedback database alias that needs to be set 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 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

2. 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. 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

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 DB2 database using Type 2 JDBC drivers. The Likeminds database alias 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 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