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
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 that is 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 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
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 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
Linux: /opt/ibm/db2/V10.5/java/db2jcc4.jar:/opt/ibm/db2/V10.5/java/db2jcc_license_cu.jar
Windows: c:/Program Files/IBM/SQLLIB/java/db2jcc4.jar;c:/Program Files/IBM/SQLLIB/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
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
Linux: For Oracle 11: /ORACLE_JARS/ojdbc6.jar For Oracle 12: /ORACLE_JARS/ojdbc7.jar:/ORACLE_JARS/xdb6.jar
Windows: For Oracle 11: c:/ORACLE_JARS/ojdbc6.jar For Oracle 12: c:/ORACLE_JARS/ojdbc7.jar;c:/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 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
Linux: /sqljdbc_4.0/enu/sqljdbc4.jar Windows: C:/Microsoft JDBC Driver 4.0 for SQL Server/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 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
Linux: /SQLlibrary/jcc/classes/db2jcc4.jar:/SQLlibrary/jcc/classes/db2jcc_license_cisuz.jar:/SQLlibrary/jcc/classes/db2jcc_javax.jar
Linux z Systems: /SQLlibrary/jcc/classes/db2jcc4.jar:/SQLlibrary/jcc/classes/db2jcc_license_cisuz.jar:/SQLlibrary/jcc/classes/db2jcc_javax.jar
Windows: C://jcc/classes/db2jcc4.jar;C://jcc/classes/db2jcc_license_cisuz.jar;C://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.
-
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.
-
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 you are using RRS as transaction coordinator. Set the value to 4 if you are using Java Platform, Enterprise Edition 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) 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
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
-