Customers using DB2 Content Manager Enterprise Edition V8.4.0 on a platform other than z/OS for indexing of content that had been migrated to Tivoli Storage Manager under certain conditions might not have a complete and accurate index

Content

When an application running on DB2 Content Manager Enterprise Edition Version 8.4.0 on a platform other than z/OS is attempting to retrieve content that are stored on media devices managed by Tivoli Storage Manager (TSM) and the TSM media is not available during the retrieval attempt, the content is not retrievable and no error message is returned to the client application. Instead, a zero length file might be returned to the client and will be written to the disk cache. No error is returned to the client application. Until such content is purged from the cache, subsequent content retrievals will continue to use the disk cache copy (zero length file) and no error is returned to the client application.

When the content is retrieved for text indexing, the operation completes without any indication of content retrieving error, but only empty content will be indexed.

To avoid experiencing this problem in the future, we recommend that you upgrade to DB2 Content Manager Enterprise Edition Version 8.4.1 as soon as possible.

Implications:

• When attempting to view the content, a blank page will be displayed, symptomatic of an error.
• The text index operation will complete without any indication of content error, but only empty content will be indexed. As a result, subsequent queries of the index using text search functions will not find the content.

• You used DB2 Content Manager Enterprise Edition V8.4.0; AND
• Using DB2 Content Manager Enterprise Edition V8.4.0, you had migrated content to Tivoli Storage Manager and then attempted to retrieve/index the content; AND
• The TSM media was not available at the time the retrieval or indexing was attempted.

• You subsequently used DB2 Content Manager Enterprise Edition V8.4.0 to retrieve or index a cached copy of content that had previously been stored on media managed by the Tivoli Storage Manager product (TSM); AND
• The TSM media was not available when the content was retrieved from TSM.

• You use or have used both (i) DB2 Content Manager Enterprise Edition V8.4.0 on a platform other than z/OS and (ii) Tivoli Storage Manager; AND
• You have never retrieved, indexed or re-indexed any content after it has been migrated from disk to Tivoli Storage Manager.

1. You need to collect the following information:
• Your DB2 Content Manager V8.4.0 installation or upgrade date
• The DB2 Content Manager index log table names of your item types
• The DB2 Content Manager index backup table names of your item types
  
2. Mark documents of one item type archived after the date you upgraded or installed DB2 Content Manager Enterprise Edition V8.4.0 to be re-indexed using the following query:
   
   db2 "insert into <CM_index_log_table> (select * from <CM_index_backup_table> where time > timestamp ('<YYYY-MM-DD>-00.00.00.000000'))"
   
   in which:
• <CM_index_log_table> is your DB2 Content Manager index log table name of the chosen item type
• <CM_index_backup_table> is your DB2 Content Manager index backup table name of the chosen item type
• <YYYY-MM-DD> is the date you upgraded or installed DB2 Content Manager Version 8.4.0
  
  
3. Run indexing for the documents of the item type mentioned in step 2 by running the fast indexer’s indexdocuments command (indexdocuments.bat or indexdocuments.sh).
   
   
4. Repeat step 2 and 3 until all of the item types are processed.