Skip to main content link. Accesskey S
  • Log In
  • Help
  • IBM Logo
  • WebSphere Portal Family wiki
  • All Wikis
  • All Forums
  • Home
  • Product Documentation
  • Community Articles
  • Learning Center
  • IBM Redbooks
Community Articles Product Documentation Learning Center IBM Redbooks This category IBM Redbooks: Building a Sample Website Using IBM Web Content Manager 7.0 IBM Redbooks: Building and Implementing a Social Portal IBM Redbooks: Developing Exceptional Multi-Channel Web Experiences V7: IBM Web Content Manager Product Documentation V7: IBM WebSphere Portal Enable for z/OS Product Documentation V7: IBM WebSphere Portal Express Product Documentation V7: WebSphere Portal Product Documentation V8: IBM Web Content Manager Product Documentation V8: IBM WebSphere Portal Express Product Documentation V8: IBM WebSphere Portal Product Documentation (includes z/OS) Custom Search Scope...
Search
Community Articles > WebSphere Portal > ConfigEngine: wkplc_dbtype.properties
  • New Article
  • Share Show Menu▼
  • Subscribe Show Menu▼

About the Original Author

DeAnna Steiner
Contribution Summary:
  • Articles authored: 126
  • Articles edited: 206
  • Comments Posted: 24

Recent articles by this author

Faceted Search - Leverage Search Experience based on IBM Search REST API
IBM WebSphere Portal V8 provides Search Center portlet as a main portlet for searching against various content. This Portlet is implemented over Portal Search REST Public API and utilizes only basic capabilities. In this article we would like to present a more advanced portlet – Explorative ...

IBM Web Content Manager Social Media Publisher v1.0 available on the Solutions Catalog
With social media publisher, you can publish your web content directly to popular social media sites.

There's something new for IBM WebSphere Portal and IBM Web Content Manager
We have a new online tutorial application for new WebSphere Portal and Web Content Manager administrators and site developers.

Integrating Lotus Connections V3 with WebSphere Portal Search V7
Learn how to configure WebSphere Portal search to include content from Lotus Connections.

Enabler API Quick Reference
This article provides a list of links to topics for the Enabler API.

Community articleConfigEngine: wkplc_dbtype.properties

Added by DeAnna Steiner | Edited by IBM contributor DeAnna Steiner on October 27, 2009 | Version 20
  • Edit
  • More Actions Show Menu▼
Rate this article 1 starsRate this article 2 starsRate this article 3 starsRate this article 4 starsRate this article 5 stars
expanded Abstract
collapsed Abstract
No abstract provided.
Tags: 6.1, 6.1.0.1, configuration, Config, database, Portal, Portal 6.1, DB2, Oracle, MS SQL, wkplc.properties
ShowTable of Contents
HideTable of Contents
  • 1 Derby Properties
  • 2 DB2 Properties
  • 3 Oracle Properties
  • 4 Microsoft SQL Server 2005 Properties
  • 5 DB2_ZOS Properties
  • 6 DB2_iSeries Properties
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

  • Edit
  • More Actions Show Menu▼


expanded Attachments (0)
collapsed Attachments (0)
Edit the article to add or modify attachments.
expanded Versions (6)
collapsed Versions (6)
Version Comparison     
VersionDateChanged by              Summary of changes
This version (20)Oct 27, 2009 3:06:04 PMDeAnna Steiner  IBM contributor
19Oct 27, 2009 2:31:29 PMDeAnna Steiner  IBM contributor
18Oct 22, 2009 12:28:51 PMDeAnna Steiner  IBM contributor
17Oct 22, 2009 12:24:30 PMDeAnna Steiner  IBM contributor
16Sep 18, 2009 4:31:27 PMDeAnna Steiner  IBM contributor
14Aug 12, 2009 5:18:30 PMDeAnna Steiner  IBM contributor
expanded Comments (0)
collapsed Comments (0)
Copy and paste this wiki markup to link to this article from another article in this wiki.
Go ElsewhereStay ConnectedHelpAbout
  • IBM Collaboration Solutions wikis
  • IBM developerWorks
  • IBM Software support
  • Twitter LinkIBMSocialBizUX on Twitter
  • FacebookIBMSocialBizUX on Facebook
  • ForumsLotus product forums
  • BlogsIBM Social Business UX blog
  • Community LinkIBM Collaboration Solutions
  • Wiki Help
  • Forgot user name/password
  • Wiki design feedback
  • Content feedback
  • About the wiki
  • About IBM
  • Privacy
  • Accessibility
  • IBM Terms of use
  • Wiki terms of use