Properties file: wkplc_dbtype.properties
Parent Reference: Configuration properties
Database safe mode properties
- DbSafeMode
- Description
- Prevents unintentional database creation, initialization, and removal. It applies to database-specific ConfigEngine tasks only. Set the value to false if create, initialize, or remove a database. When the value is set to true, the database server is protected. We cannot create, initialize, or remove databases using ConfigEngine tasks.
- Valid values
- true
- false
- Default value
- false
- Examples
- None available
Apache Derby database properties
The following property value pairs are specific to the Apache Derby database. Derby is not a production environment database, but it is ideal for development environments.
- derby.DbDriver
- Description
- The name of the database driver used to connect to the Apache Derby database.
- Default value
- org.apache.derby.jdbc.EmbeddedDriver
- Examples
- Apache Derby: : org.apache.derby.jdbc.EmbeddedDriver
- derby.DbLibrary
- Description
- The path and name of the .zip or JAR file containing the JDBC driver class. Use the system-specific file separators. For Microsoft Windows operating system, use a semicolon (;). For Linux and UNIX operating systems, use a colon (:).
- Default value
- No default value
- Examples
- Linux:: /opt/IBM/WebSphere/AppServer/derby/lib/derby.jar
- Microsoft Windows:: C:/IBM/WebSphere/PortalExpress/AppServer/derby/lib/derby.jar
- derby.JdbcProviderName
- Description
- Type the name of JDBC provider to use for Apache Derby.
- Default value
- wpdbJDBC_derby
- Examples
- None available
IBM DB2 database properties
The following property value pairs are specific to IBM DB2 database.
- db2.DbDriver
- Description
- Name of the database driver class for IBM DB2.
- Default value
- com.ibm.db2.jcc.DB2Driver
- Examples
- IBM DB2: : com.ibm.db2.jcc.DB2Driver
- db2.DbLibrary
- Description
- Copy the JDBC Driver JAR files from the database server to the portal server. Type the path to the location of these files on the portal server and the name of the .zip or JAR file containing the JDBC driver class. Use the system-specific file separators. For Microsoft Windows operating system, use a semicolon (;). For Linux and UNIX operating systems, use a colon (:).
- Default value
- No default value
- Examples
- /opt/IBM/db2/V10.5/java/db2jcc4.jar:/opt/IBM/db2/V10.5/java/db2jcc_license_cu.jar
- db2.JdbcProviderName
- Description
- Type the name of JDBC provider to use for IBM DB2.
- Default value
- wpdbJDBC_db2
- Examples
- None available
Oracle Database Properties
The following property value pairs are specific to Oracle Database.
- oracle.DbDriver
- Description
- Type the database driver class name for the Oracle Database.
- Default value
- oracle.jdbc.OracleDriver
- Examples
- None available
- oracle.DbLibrary
- Description
- Path and name of the .zip or JAR file containing the JDBC driver class.
For Oracle 11g databases, configure database transfer and runtime with only the ojdbc6.jar. Provide the path for the ojdbc6.jar driver.
For Oracle 12c, there are two database libraries and they must be in the same directory. Copy the ojdbc7.jar and xdb6.jar to the same directory, such as ORACLE_JARS. Provide the path to the ojdbc7.jar and xdb6.jar drivers.
Use the system-specific file separators. For Microsoft Windows operating system, use a semicolon (;). For Linux and UNIX operating systems, use a colon (:).
- Default value
- No default value
- Examples
- /ORACLE_JARS/ojdbc6.jar
For Oracle 12:
/ORACLE_JARS/ojdbc7.jar:/ORACLE_JARS/xdb6.jar
- oracle.JdbcProviderName
- Description
- The name of JDBC provider to use with the Oracle Database.
- Default value
- wpdbJDBC_oracle
- Examples
- None available
Microsoft SQL Server properties
The following value pairs are specific to Microsoft SQL Server and can be used with either version 2005 and 2008.
- sqlserver2005.DbDriver
- Description
- The driver class name to use for Microsoft SQL Server.
- Default value
- com.microsoft.sqlserver.jdbc.SQLServerDriver
- Examples
- Microsoft JDBC driver:
com.microsoft.sqlserver.jdbc.SQLServerDriver
- sqlserver2005.DbLibrary
- Description
- Type the path and name of the .zip or JAR file containing the JDBC driver class. Use the system-specific file separators. For Microsoft Windows operating system, use a semicolon (;). For Linux and UNIX operating systems, use a colon (:).
- Default value
- No default value
- Examples
- /sqljdbc_4.0/enu/sqljdbc4.jar
- sqlserver2005.JdbcProviderName
- Description
- The name of JDBC provider to use with Microsoft SQL Server.
- Default value
- wpdbJDBC_sqlserver2005
- Examples
- None available
- sqlserver2005.DbConnectionPoolDataSource
- Description
- The name of the implementation class of the connection pool data source.
- Default value
- com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
- Examples
- Microsoft JDBC driver:: com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
IBM DB2 for z/OS properties
The following value pairs are specific to IBM DB2 for z/OS.
- db2_zos.DbDriver
- Description
- Type the database driver class name for DB2 for z/OS.
- Default value
- com.ibm.db2.jcc.DB2Driver
- Examples
- IBM DB2 for z/OS: : com.ibm.db2.jcc.DB2Driver
- db2_zos.DbLibrary
- Description
- Type the path and name of the .zip or JAR file containing the JDBC driver class. Use the system-specific file separators. For Microsoft Windows operating system, use a semicolon (;). For Linux and UNIX operating systems, use a colon (:).
- Default value
- No default value
- Examples
- /SQLlibrary/jcc/classes/db2jcc4.jar:/SQLlibrary/jcc/classes/db2jcc_license_cisuz.jar:/SQLlibrary/jcc/classes/db2jcc_javax.jar
- db2_zos.JdbcProviderName
- Description
- The name of JDBC provider to use for IBM DB2 for z/OS.
- Default value
- wpdbJDBC_db2_zos
- Examples
- None available
- db2_zos.DbNativeLibrary
- Description
- Type the path to the native IBM DB2 libraries. Required when WebSphere Portal is running on z/OS only.
- Default value
- /usr/lpp/db2910_jdbc/lib
- Examples
- Native libraries: : /usr/lpp/db2910_jdbc/lib
- db2_zos.DbSqljProperties
- Description
- Type the directory and name of the DB2 JDBC property file on z/OS. Required when WebSphere Portal is running on z/OS only.
- Default value
- /etc/DB2JccConfiguration.properties
- Examples
- None available
- db2_zos.DbDriverType
- Description
- Select the connection type for the driver. Set the value to 2 if we are using RRS as transaction coordinator. Set the value to 4 if we are using Java EE XA.
- Valid values
- 2
- 4
- Default value
- 2
- Examples
- None available
IBM DB2 for i properties
- db2_iseries.DbDriver
- Description
- The database driver class name for IBM DB2 for i.
- Default value
- com.ibm.as400.access.AS400JDBCDriver
- Examples
- Type 4 driver:: com.ibm.as400.access.AS400JDBCDriver
- Type 2 driver:: com.ibm.db2.jdbc.app.DB2Driver
- db2_iseries.DbLibrary
- Description
- The directory and name of the library (.zip or JAR file) containing the JDBC version 4 driver class. We can get the latest jt400.jar from Toolbox for Java/JTOpen. Select the driver file that includes "jtopen_x_y_jdbc40_jdk6.zip". Where x and y are the major minor version numbers.
- Default value
- No default value
- Examples
- Type 4 driver:: //jt400.jar
- Type 2 driver:: /QIBM/ProdData/OS400/Java400/ext/db2_classes16.jar
- db2_iseries.JdbcProviderName
- Description
- The name of JDBC provider to be used.
- Default value
- wpdbJDBC_db2_iseries
- Examples
- None available
- db2_iseries.DbDriverType
- Description
- Select the type of connection to use for IBM DB2 for i. Set the value to 2 for local, non-CCSID 65535, and non-clustered configurations. Set the value to 4 for local, remote, or clustered configurations.
- Valid values
- 2
- 4
- Default value
- 4
- Examples
- None available