Properties file: wp.db.impl_sourceDb.properties
Table of contents
- Source Release Database Properties
- Source Community Database Properties
- Source Customization Database Properties
- Source JCR Database Properties
Parent: Configuration properties reference
1. Source Release Database Properties
- source.release.DbType
- Description
- The type of database to use for the source for the Release domain.
- Default value
- derby
- Examples
- None available
- source.release.DbName
- Description
- The name of the source release database Should also appear as the database element in source DbUrl. The following conditions effect the value for this property:
- For Linux and UNIX-based platforms using IBM DB2, this value is the TCPIP Alias.
- 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/wpsreldb
- Default value
- wpsdb
- Examples
- None available
- source.release.DbSchema
- Description
- The database schema name for the source Release domain. 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
- release
- Examples
- None available
- source.release.DbNameOnZos
- Description
- Required for DB2 for z/OS only. The name of the source 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 source Release domain database.
- Default value
- WPSTST02
- Examples
- None available
- source.release.DbUrl
- Description
- The source release 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: 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
- source.release.DbUser
- Description
- The source database administrator user ID.
- Default value
- db2admin
- Examples
- None available
- source.release.DbPassword
- Description
- The source database administrator password
- Default value
- ReplaceWithYourDbAdminPwd
- Examples
- None available
2. Source Community Database Properties
- source.community.DbType
- Description
- The type of source database to be used for the Community domain.
- Default value
- derby
- Examples
- None available
- source.community.DbName
- Description
- The source Community domain database. Should also appear as the database element in DbUrl.
- For Linux and UNIX platforms (non-Windows) when using DB2 only, this value is 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
- source.community.DbSchema
- Description
- The source Community 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
- community
- Examples
- None available
- source.community.DbNameOnZos
- Description
- Required for DB2 for z/OS only. The name of the source 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
- source.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: 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
- source.community.DbUser
- Description
- The source database user ID.
- Default value
- db2admin
- Examples
- None available
- source.community.DbPassword
- Description
- The source database administrator password.
- Default value
- ReplaceWithYourDbAdminPwd
- Examples
- None available
- source.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 source Community database alias that needs to be set to call create-database
- Default value
- wps6TCP
- Examples
- None available
3. Source Customization Database Properties
- source.customization.DbType
- Description
- The type of source database to be used for the Customization domain.
- Default value
- derby
- Examples
- None available
- source.customization.DbName
- Description
- The name of the Customization database. Should also appear as the database element in customization.DbUrl. The following conditions effect the value for this property:
- For Linux and UNIX platforms (non-Windows) when using DB2 only, this is 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
- source.customization.DbSchema
- Description
- The source Customization 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
- customization
- Examples
- None available
- source.customization.DbNameOnZos
- Description
- Required for DB2 for z/OS only. The name of the source 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
- source.customization.DbUrl
- Description
- The source Customization domain database URL. The database element of this value should match the value of source 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
- 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
- source.customization.DbUser
- Description
- The source database administrator user ID.
- Default value
- db2admin
- Examples
- None available
- source.customization.DbPassword
- Description
- The source database administrator password.
- Default value
- ReplaceWithYourDbAdminPwd
- Examples
- None available
- source.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 source Customization database alias that needs to be set to call create-database
- Default value
- wps6TCP
- Examples
- None available
4. Source JCR Database Properties
- source.jcr.DbType
- Description
- The type of source database to be used for the JCR domain.
- Default value
- derby
- Examples
- None available
- source.jcr.DbName
- Description
- The name of the source JCR database. 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
- source.jcr.DbSchema
- Description
- The source JCR 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
- jcr
- Examples
- None available
- source.jcr.DbNameOnZos
- Description
- Required for DB2 for z/OS only. The name of the source 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
- source.jcr.DbUrl
- Description
- The source JCR domain database URL. The database element of this value should match the value of source 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
- 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
- source.jcr.DbUser
- Description
- The source database administrator user ID.
- Default value
- db2admin
- Examples
- None available
- source.jcr.DbPassword
- Description
- The source database administrator password.
- Default value
- ReplaceWithYourDbAdminPwd
- Examples
- None available
- source.jcr.XDbName
- Description
- Required for non-Windows platforms when using DB2. Required only for local DB2 database using Type 2 JDBC driver. The source JCR database alias that needs to be set to call create-database
- Default value
- wps6TCP
- Examples
- None available