Properties file: wkplc_dbtype.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 you need to create, initialize, or remove a database. When the value is set to true, the database server is protected. You cannot create, initialize, or remove databases by using ConfigEngine tasks.
- Valid values
- true
- 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
- derby.DbLibrary
- Description
- The path and name of the .zip or JAR file that contains 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
- derby.JdbcProviderName
IBM DB2 database properties
The following property value pairs are specific to IBM DB2 database.
- db2.DbDriver
- db2.DbLibrary
- Description
- Copy the JDBC Driver JAR files from your database server to your portal server. Type the path to the location of these files on your portal server and the name of the .zip or JAR file that contains 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
- AIX: /opt/IBM/db2/V10.5/java/db2jcc4.jar:/opt/IBM/db2/V10.5/java/db2jcc_license_cu.jar
- db2.JdbcProviderName
Oracle Database Properties
The following property value pairs are specific to Oracle Database.
- oracle.DbDriver
- oracle.DbLibrary
- Description
- Type the path and name of the .zip or JAR file that contains the JDBC driver class. For Oracle 11g databases, you must 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
- AIX:: For Oracle 11: /ORACLE_JARS/ojdbc6.jar For Oracle 12: /ORACLE_JARS/ojdbc7.jar:/ORACLE_JARS/xdb6.jar
- oracle.JdbcProviderName
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
- sqlserver2005.DbLibrary
- Description
- Type the path and name of the .zip or JAR file that contains 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
- AIX:: /sqljdbc_4.0/enu/sqljdbc4.jar
- sqlserver2005.JdbcProviderName
- sqlserver2005.DbConnectionPoolDataSource
IBM DB2 for z/OS properties
The following value pairs are specific to IBM DB2 for z/OS.
- db2_zos.DbDriver
- db2_zos.DbLibrary
- Description
- Type the path and name of the .zip or JAR file that contains 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
- AIX:: /SQLlibrary/jcc/classes/db2jcc4.jar:/SQLlibrary/jcc/classes/db2jcc_license_cisuz.jar:/SQLlibrary/jcc/classes/db2jcc_javax.jar
- db2_zos.JdbcProviderName
- db2_zos.DbNativeLibrary
- db2_zos.DbSqljProperties
- db2_zos.DbDriverType
IBM DB2 for i properties
- db2_iseries.DbDriver
- db2_iseries.DbLibrary
- Description
- The directory and name of the library (.zip or JAR file) that contains the JDBC version 4 driver class. You 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
- db2_iseries.JdbcProviderName
- db2_iseries.DbDriverType