FileNet P8 Content Engine, Version 5.0.+              

Determining the CBR-enabled properties in an object store

For each object store to be upgraded, you must determine the associated classes and properties that are currently enabled for content-based retrieval (CBR). You enable these properties after the upgrade is complete.

To determine the classes and properties that are CBR-enabled:
  1. Using an RDBMS tool, access the object store database as a user who has appropriate privileges to query the object store tables.
  2. Run the following SQL query command on each object store database to determine which properties are enabled for CBR:

    select p.dbg_class_name, p.dbg_display_name, c.is_cbr_enabled, p.is_cbr_enabled from ClassDefinition c inner join PropertyDefinition p on p.parent_id = c.object_id where p.is_cbr_enabled = 1 AND c.is_cbr_enabled = 0

  3. Record the results of the query commands. After you upgrade the object stores, you need to run FileNet® Enterprise Manager to enable CBR on these properties after you enable CBR on the classes that these properties are associated with.


Feedback

Last updated: November 2010


© Copyright IBM Corporation 2010.
This information center is powered by Eclipse technology. (http://www.eclipse.org)