Properties file: prereq.pzn_sourceDb.properties
Table of contents
- Source Personalization Feedback Database Properties
- LikeMinds Database Properties
Parent: Configuration properties reference
1. Source Personalization Feedback Database Properties
- source.feedback.DbType
-
- Description
- The type of database that WebSphere Portal will use for the source Feedback database.
- Default value
- derby
- Examples
- None available
- source.feedback.DbName
-
- Description
- The name of the source Feedback database. The value should be the same as the database element in feedback.DbUrl value
- Default value
- wpsdb
- Examples
- None available
- source.feedback.DbSchema
-
- Description
- Source Feedback domain database schema name. For IBM DB2 for i, the 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
- source.feedback.DbNameOnZos
-
- Description
- Required for IBM DB2 for z/OS only.
- Default value
- WPSTST02
- Examples
- None available
- source.feedback.DbUrl
-
- Description
- The source 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
- source.feedback.DbUser
-
- Description
- The database administrator user ID.
- Default value
- db2admin
- Examples
- None available
- source.feedback.DbPassword
-
- Description
- The source database password for the administrator user ID.
- Default value
- ReplaceWithYourDbAdminPwd
- Examples
- None available
- source.feedback.DBA.DbUser
-
- Description
- The DBA user ID for privileged access operations during creation of this sourcedatabase type.
- Default value
- db2admin
- Examples
- None available
- source.feedback.DBA.DbPassword
-
- Description
- The password for the privileged DBA user ID used to access operations during creation of the source Feedback database.
- Default value
- ReplaceWithYourDBAPwd
- Examples
- None available
- source.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 source Feedback database alias that needs to be set to call create-database
- Default value
- fdbk6TCP
- Examples
- None available
2. LikeMinds Database Properties
- source.likeminds.DbType
-
- Description
- The type of database to be used for the source Likeminds database.
- Default value
- derby
- Examples
- db2
- source.likeminds.DbName
-
- Description
- The name of the source Likeminds database.
Should also appear as the database element in likeminds.DbUrl
- Default value
- wpsdb
- Examples
- wplsdb
- source.likeminds.DbSchema
-
- Description
- The Likeminds domain source 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
- source.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
- source.likeminds.DbUrl
-
- Description
- The Likeminds domain source database URL. The following conditions effect the value for this property:
- 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: 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
- source.likeminds.DbUser
-
- Description
- The source database administrator user ID.
- Default value
- db2admin
- Examples
- None available
- source.likeminds.DbPassword
-
- Description
- The source database administrator password.
- Default value
- ReplaceWithYourDbAdminPwd
- Examples
- None available
- source.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 the create-database task.
- Default value
- lmdb6TCP
- Examples
- None available