WCM Parameters in wpconfig.properties

WCM Parameters in wpconfig.properties

+
Search Tips | Advanced Search

Overview

The Web Content Management section of...
/PortalServer/config/wpconfig.properties

...contains settings that are used by WCM configuration tasks.
Many of the settings listed below require knowledge of the databases used as WCM data repositories.
Also read the Data Repository Settings topics for further configuration requirements for each Data Repository type.
The settings in wpconfig.properties can only be used to configure WCM to use an IBM Content Manager data repository when running the config-wcm-repository task. It cannot be used to transfer data to an IBM Content Manager data repository.

Parameters

WcmEncoding= Default encoding for the Site. It is pre-configured as UTF-8. The following languages are supported:

UTF-8.

Czech, Danish, Dutch, Finnish, French, German, Greek, Hungarian, Italian, Norwegian Polish, Portuguese, Portuguese (Brazilian), Russian, Spanish, Swedish, and Turkish.

Shift_JIS.

Japanese.

EUC-KR.

Korean.

GB2312.

Simplified-Chinese.

Big5.

Traditional-Chinese.

WcmMgrPersistence= The persistencies supported:

CM IBM Content Manager
JDBC JDBC databases

These parameters are case-sensitive.
WcmResPersistence= The persistencies supported:

CM IBM Content Manager
JDBC JDBC databases

These parameters are case-sensitive.
WcmTable= Name of the database table that will be created to manage WCM items. If this parameter is not included, then the table name will default to AJPE. (Optional)
WcmResourceTable= Name of the database table that will be created to manage WCM resources. If this parameter is not included, then the table name will default to AJPE_RESOURCES. (Optional)
WcmReadAhead= The sets the number of items to read ahead when reading all items for index recreation. This parameter would not usually be changed.
WcmResourceMaxSize= Allocate space, in megabytes, within a database for WCM resources when resource persistence is set to JDBC. This does not apply to WCM item files. Once set, you cannot store resources larger than the maximum size set in this parameter.
Increasing this setting to accommodate very large files can slow performance. It may be better to reference large files in WCM content via a URL rather than storing them as WCM resources.
Once set, this setting cannot be reset in the current DB2 database. It can only be reset by deleting and creating a new DB2 database. If you need to change this setting, you should syndicate the current Site to another server, recreate the DB2 database, and then syndicate the Site back from the backup server.
WcmDbType= The type of database to be used as a WCM repository is set here:

DB2: WcmDbType=db2
Oracle: WcmDbType=oracle
MS SQL Server: WcmDbType=sqlserver
Cloudscape: WcmDbType=cloudscape
DB2 for i5/OS: WcmDbType=db2_iseries
DB2 for z/OS and OS/390: WcmDbType=db2_zos

WcmDbName= Name of the database to be used as a WCM repository is entered here. This value should also appear as the database element in WcmDbUrl
WcmDbSchema= Schema name of the database to be used as a WCM repository. Required for z/OS DB2 systems only. Should be that same as a valid DB2 username.
WcmDbSchema=

WcmDbUser= Name of the user to connect to the database with. The specified user must have enough access to create a table and execute select, update, insert, and remove SQL statements on that table.
When transferring data to Microsoft SQL Server, enter the WcmDbUser name in uppercase in wpconfig.properties The WcmDbUser name must also be entered in uppercase in Microsoft SQL Server.
WcmDbPassword= Passwd of the user to connect to the database with.
WcmAdminGroupIdShort= The WCM administrators group ID defined in WebSphere Portal. Defaults to wcmadmins
WcmDbUrl= URL to the database used to store WCM data. The database element of this value should match the database name entered in WcmDbName:

cloudscape jdbc:db2j:C:/path/to/WCMDB
db2 jdbc:db2:WCMDB
db2_iseries jdbc:db2:*LOCAL/QWCMDB
db2_iseries (remote) jdbc:as400:<hostName>/QWCMDB
db2_zos jdbc:db2:<location>
db2_zos (remote) jdbc:db2://<server address>:<port>/<location>
The <location> parameter is case-sensitive.
oracle jdbc:oracle:thin:@[HOST]:[PORT]:WCMDB
sqlserver jdbc:microsoft:sqlserver://[HOST]:[PORT];
User=user;
Password=passwd;
SelectMethod=cursor;
DatabaseName=WCMDB

WcmFileSystemDataLocation= Location of the file system data directory to transfer if using the transfer-wcm-filesystem-to-cloudscape configuration task.
WcmDbDriver= Name of class SqlProcessor will use to import SQL files, also known as "JDBC provider":

cloudscape com.ibm.db2j.jdbc.DB2jDriver
db2 COM.ibm.db2.jdbc.app.DB2Driver
db2_iseries com.ibm.db2.jdbc.app.DB2Driver
db2_iseries (remote db) { com.ibm.as400.access.AS400JDBCDriver
db2_zos com.ibm.db2.jcc.DB2Driver
db2_zos (remote db) com.ibm.db2.jcc.DB2Driver
oracle oracle.jdbc.driver.OracleDriver
sqlserver com.microsoft.jdbc.sqlserver.SQLServerDriver

WcmDbDriverDs= Name of class SqlProcessor will use to import SQL files via data source. Required for DB2 z/OS systems only.
db2_zos: com.ibm.db2.jcc.DB2ConnectionPoolDataSource

WcmDsName= Name of datasource to be used for WCM. (z/OS only)
WcmJdbcProvider= Name of WCM JDBC provider to be used. (z/OS only)
WcmDbLibrary= The directory and name of the zip file containing the db.driver class. Use the system specific file separator names. E.g - for Windows use a semicolon and for Unix a colon.

cloudscape: <PortalServer>shared/app/cloudscape/db2j.jar
db2: SQLLIB/java/db2java.zip
db2_iseries: /QIBM/ProdData/Java400/ext/db2_classes.jar
db2_iseries (remote): /QIBM/ProdData/PortalServer5/IBMTrans/lib/jt400.jar
db2_zos: SQLLIB/jcc/classes/db2jcc.jar
SQLLIB/jcc/classes/db2jcc_license_cisuz.jar
SQLLIB/jcc/classes/db2jcc_javax.jar
For connections to UDB on z/OS, type 4 drivers, as installed with DB2 8.1 Fix Pack 6 or 6a on the distributed platforms (Windows, Linux, Unix), should be used.
db2_zos (remote): SQLLIB/java/db2jcc.jar
SQLLIB/java/db2jcc_license_cisuz.jar
oracle: <Oracle>/jdbc/lib/ojdbc14.jar
sqlserver: SQLServer/lib/mssqlserver.jar;
SQLServer/lib/msbase.jar;
SQLServer/lib/msutil.jar

WcmDbNativeLibrary= The directory of the native DB2 libraries. (z/OS only)
WcmDbSqljProperties= The path to and name of the DB2 JDBC property file. (z/OS only)

Large Object Binaries on z/OS systems

The following settings are used to set parameters for storing "Large Object Binaries" and are required for z/OS systems only.
When setting maximum resource table sizes, it is necessary to allocate a table size slightly larger than the maximum required. E.g. - If the maximum file size to be stored is 10 MB, the maximum resource table size may need to be set at 12 MB or higher.

WcmMaxClobSize= Default CLOB size for maximum allowed CLOB.
WcmSmallClobSize= Default CLOB size for most common CLOB size.
WcmResourceMaxBlobSize= Default BLOB size for maximum allowed BLOB.
WcmResourceSmallBlobSize= Default BLOB size for most common BLOB size.
WcmSmallTable= Default CLOB table name for data.
WcmResourceSmallTable= Default CLOB table name for resources.
WcmLobTable= Default LOB table name for data.
WcmLobSmallTable= Default LOB small table name for data.
WcmLobResourceTable= Default LOB table name for resources.
WcmLobResourceSmallTable= Default LOB small table name for resources.
WcmTableSpaceNameSmallClobs= Tablespace name for WcmTable.
WcmTableSpaceNameLargeClobs= Tablespace name for WcmLargeTable.
WcmTableSpaceNameSmallBlobs= Tablespace name for WcmResourceTable.
WcmTableSpaceNameLargeBlobs= Tablespace name for WcmResourceLargeTable.
WcmLobTableSpaceNameSmallClobs= LOB tablespace name for WcmTable.
WcmLobTableSpaceNameLargeClobs= LOB tablespace name for WcmLargeTable.
WcmLobTableSpaceNameSmallBlobs= LOB tablespace name for WcmResourceTable.
WcmLobTableSpaceNameLargeBlobs= Lob tablespace name for WcmResourceLargeTable.

Configure WCM to use IBM Content Manager as a data repository

The following settings are used when configuring WCM to use IBM Content Manager as a data repository.

WcmCmServer= Name of the IBM Content Manager server here.
WcmCmUser= Name of a valid IBM Content Manager User here.
WcmCmPassword= Password of the IBM Content Manager User entered above.
WcmCmSchema= Optional. WCM used the "WcmCmUser" property as the default Schema for Content Manager. This parameter can be used to specify a different schema name should the "WcmCmUser" not be the same user that originally created the Content Manager database.

Note that in z/OS, the wpconfig.properties file is not edited directly. use the z/OS customization panel. Detailed information on using the Customization panel and defining variables can be found in the WebSphere Portal for z/OS Information Center under
Installing | Customization Dialog tasks - Worksheets and Definitions | Configure IBM Workplace WCM

Parent topic: Configuration Tasks.
Parent topic: Data Storage.
IBM Workplace WCM - V5.1.0.1 -

WebSphere is a trademark of the IBM Corporation in the United States, other countries, or both.

IBM is a trademark of the IBM Corporation in the United States, other countries, or both.

WcmMaxClobSize=	Default CLOB size for maximum allowed CLOB.
WcmSmallClobSize=	Default CLOB size for most common CLOB size.
WcmResourceMaxBlobSize=	Default BLOB size for maximum allowed BLOB.
WcmResourceSmallBlobSize=	Default BLOB size for most common BLOB size.
WcmSmallTable=	Default CLOB table name for data.
WcmResourceSmallTable=	Default CLOB table name for resources.
WcmLobTable=	Default LOB table name for data.
WcmLobSmallTable=	Default LOB small table name for data.
WcmLobResourceTable=	Default LOB table name for resources.
WcmLobResourceSmallTable=	Default LOB small table name for resources.
WcmTableSpaceNameSmallClobs=	Tablespace name for WcmTable.
WcmTableSpaceNameLargeClobs=	Tablespace name for WcmLargeTable.
WcmTableSpaceNameSmallBlobs=	Tablespace name for WcmResourceTable.
WcmTableSpaceNameLargeBlobs=	Tablespace name for WcmResourceLargeTable.
WcmLobTableSpaceNameSmallClobs=	LOB tablespace name for WcmTable.
WcmLobTableSpaceNameLargeClobs=	LOB tablespace name for WcmLargeTable.
WcmLobTableSpaceNameSmallBlobs=	LOB tablespace name for WcmResourceTable.
WcmLobTableSpaceNameLargeBlobs=	Lob tablespace name for WcmResourceLargeTable.

WcmCmServer=	Name of the IBM Content Manager server here.
WcmCmUser=	Name of a valid IBM Content Manager User here.
WcmCmPassword=	Password of the IBM Content Manager User entered above.
WcmCmSchema=	Optional. WCM used the "WcmCmUser" property as the default Schema for Content Manager. This parameter can be used to specify a different schema name should the "WcmCmUser" not be the same user that originally created the Content Manager database.