ShowTable of Contents
This reference document is a based on the wkplc_dbtype.properties file included in WebSphere Portal 6.1.0.1. As needed, IBM support will make updates to this reference document to clarify usage and limitations.
The properties are organized by database type: Derby, DB2, Oracle, Microsoft SQL Server 2005, DB2 z/OS, DB2 iSeries
DbSafeMode
Description: This only applies to Database specific tasks. If it is set to true the databases will not be created, initialized, or removed.
Value: false | true
Examples: none available
Default: DbSafeMode=false
Derby Properties
derby.DbDriver
Description: The name of class SqlProcessor will use to import SQL files
Value: class name
Examples: none available
Default: derby.DbDriver=org.apache.derby.jdbc.EmbeddedDriver
derby.DbLibrary
Description: The directory and name of the zip/jar file containing JDBC driver class. Use the system specific file separator names, for Windows use a semicolon and for UNIX use a colon.
Value: alphanumeric characters
Examples: none available
Default: derby.DbLibrary=C:/IBM/WebSphere/PortalExpress/AppServer/derby/lib/derby.jar
derby.JdbcProviderName
Description: The name of jdbc provider to be used.
Value: alphanumeric characters
Examples: none available
Default: derby.JdbcProviderName=wpdbJDBC_derby
DB2 Properties
db2.DbDriver
Description: The name of class SqlProcessor will use to import SQL files.
Value: class name
Examples:
- For DB2 Type 2 driver use COM.ibm.db2.jdbc.app.DB2Driver
- For DB2 Type 4 driver use com.ibm.db2.jcc.DB2Driver
Default: db2.DbDriver=com.ibm.db2.jcc.DB2Driver
db2.DbLibrary
Description: The directory and name of the zip/jar file containing JDBC driver class. Use system specific file separator names,for Windows use a semicolon and for UNIX use a colon.
Value: alphanumeric characters
Examples:
- For DB2 Type 2 driver use /java/db2java.zip
- For DB2 Type 4 driver use /java/db2jcc.jar;/java/db2jcc_license_cu.jar
Default: db2.DbLibrary=C:/IBM/WebSphere/PortalExpress/db2/java/db2jcc.jar;C:/IBM/WebSphere/PortalExpress/db2/java/db2jcc_license_cu.jar
db2.JdbcProviderName
Description: The name of jdbc provider to be used
Value: alphanumeric characters
Examples: none available
Default: db2.JdbcProviderName=wpdbJDBC_db2
Oracle Properties
oracle.DbDriver
Description: The name of class SqlProcessor will use to import SQL files
Value: class name
Examples: none available
Default: oracle.DbDriver=oracle.jdbc.driver.OracleDriver
oracle.DbLibrary
Description: The directory and name of the zip/jar file containing JDBC driver class. Use the system specific file separator names, for Windows use a semicolon and for UNIX use a colon.
Value: alphanumeric characters
Examples: none available
Default: oracle.DbLibrary=
/jdbc/lib/ojdbc14.jar
oracle.JdbcProviderName
Description: The name of jdbc provider to be used
Value: alphanumeric characters
Examples: none available
Default: oracle.JdbcProviderName=wpdbJDBC_oracle
Microsoft SQL Server 2005 Properties
sqlserver2005.DbDriver
Description: The name of class SqlProcessor will use to import SQL files
Value: class name
Examples:
- JDBC driver provided by Microsoft: com.microsoft.sqlserver.jdbc.SQLServerDriver
- JDBC driver provided by DataDirect: com.ddtek.jdbc.sqlserver.SQLServerDriver
Default: sqlserver2005.DbDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
sqlserver2005.DbLibrary
Description: The directory and name of the zip/jar file containing JDBC driver class. Use the system specific file separator names, for Windows use a semicolon and for UNIX use a colon.
Value: alphanumeric characters
Examples: none available
- JDBC driver provided by Microsoft: /sqljdbc_1.2/enu/sqljdbc.jar
- JDBC driver provided by DataDirect: /lib/sqlserver.jar;/lib/base.jar;/lib/util.jar
Default: sqlserver2005.DbLibrary=/sqljdbc_1.2/enu/sqljdbc.jar
sqlserver2005.JdbcProviderName
Description: The name of jdbc provider to be used
Value: alphanumeric charactersExamples: none available
Default: sqlserver2005.JdbcProviderName=wpdbJDBC_sqlserver2005
sqlserver2005.DbConnectionPoolDataSource
Description: The name of the implementation class of the connection pool data source
Value: class name
Examples: none available
- JDBC driver provided by Microsoft: com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
- JDBC driver provided by DataDirect: com.ddtek.jdbcx.sqlserver.SQLServerDataSource
Default: sqlserver2005.DbConnectionPoolDataSource=com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
DB2_ZOS Properties
db2_zos.DbDriver
Description: The name of class SqlProcessor will use to import SQL files
Value: Valid values include the following:
- local: db2_zos.DbDriver=com.ibm.db2.jcc.DB2Driver
- remote (type 2): db2_zos.DbDriver=COM.ibm.db2.jdbc.app.DB2Driver
- remote (type 4): db2_zos.DbDriver=com.ibm.db2.jcc.DB2Driver
Examples: none available
Default: db2_zos.DbDriver=com.ibm.db2.jcc.DB2Driver
db2_zos.DbLibrary
Description: The directory and name of the zip/jar file containing JDBC driver class. Use the system specific file separator names, for Windows use a semicolon and for UNIX use a colon.
Value: Valid values include the following:
- local: db2_zos.DbLibrary=/jcc/classes/db2jcc.jar:/jcc/classes/db2jcc_license_cisuz.jar:/jcc/classes/db2jcc_javax.jar
- remote (type 2): db2_zos.DbLibrary=/java12/db2java.zip
- remote (type 4): db2_zos.DbLibrary=/jcc/classes/db2jcc.jar:/jcc/classes/db2jcc_license_cisuz.jar
Examples: none available
Default: db2_zos.DbLibrary=/jcc/classes/db2jcc.jar:/jcc/classes/db2jcc_license_cisuz.jar:/jcc/classes/db2jcc_javax.jar
db2_zos.JdbcProviderName
Description: The name of jdbc provider to be used
Value: alphanumeric characters
Examples: none available
Default: db2_zos.JdbcProviderName=wpdbJDBC_db2_zos
db2_zos.DbNativeLibrary
Description: Required for portal running on z/OS only. The directory of the native DB2 libraries
Value: alphanumeric characters
Examples: none available
Default: db2_zos.DbNativeLibrary=/usr/lpp/db2/db2810/jcc/lib
db2_zos.DbSqljProperties
Description: Required for portal running on z/OS only. The directory and name of the DB2 JDBC property file on z/OS
Value: alphanumeric characters
Examples: none available
Default: db2_zos.DbSqljProperties=/etc/DB2JccConfiguration.properties
db2_zos.DbDriverType
Description:
Value: Valid values include:
- Type 2 local using RRS as transaction coordinator
- Type 4 remote using J2EE XA
Examples: none available
Default: db2_zos.DbDriverType=2
db2_zos.DbLocationName
Description: The DB2 location name. This is set in the DB2 installation job DSNTIJUZ
Value: alphanumeric characters
Examples: none available
Default: db2_zos.DbLocationName=LOC1
DB2_iSeries Properties
db2_iseries.DbDriver
Description: The name of class SqlProcessor will use to import SQL files.
Value: class name
Examples:
- Type 2 driver: db2_iseries.DbDriver=com.ibm.db2.jdbc.app.DB2Driver
- Type 4 driver: db2_iseries.DbDriver=com.ibm.as400.access.AS400JDBCDriver
Default: db2_iseries.DbDriver=com.ibm.as400.access.AS400JDBCDriver
db2_iseries.DbLibrary
Description: The directory and name of the zip/jar file containing JDBC driver class
Value: alphanumeric characters
Examples:
- Type 2 driver: db2_iseries.DbLibrary=/QIBM/ProdData/Java400/ext/db2_classes.jar
- Type 4 driver: db2_iseries.DbLibrary=/QIBM/ProdData/HTTP/Public/jt400/lib/jt400.jar
Default: db2_iseries.DbLibrary=/QIBM/ProdData/HTTP/Public/jt400/lib/jt400.jar
db2_iseries.JdbcProviderName
Description: The name of jdbc provider to be used
Value: alphanumeric characters
Examples: none available
Default: db2_iseries.JdbcProviderName=wpdbJDBC_db2_iseries
db2_iseries.DbDriverType
Description:
Value: alphanumeric characters
Examples:
- Type 2 driver: db2_iseries.DbDriverType=2 (local, non CCSID 65535, and non-clustered only)
- Type 4 driver: db2_iseries.DbDriverType=4 (local or remote or clustered)
Default: db2_iseries.DbDriverType=4
End of Article