PK65375: IMPROVED PERFORMANCE FOR JCR SEARCH INDEXING

6.1.0.1 Download: WebSphere Portal and Web Content Management V6.1, fix pack 1
6.1.0.2 Download: WebSphere Portal and Web Content Management V6.1, fix pack 2
6.1.0.3 Download: WebSphere Portal and WCM V6.1 fix pack 3, 6.1.5 feature pack
6.1.0.4 Download: WebSphere Portal and WCM V6.1.0 fix pack 4 & 6.1.5 fix pack 1
6.1.0.5 Download: WebSphere Portal and WCM V6.1.0 fix pack 5
6.1.0.6 Download: WebSphere Portal and WCM V6.1.0 fix pack 6

APAR status

• Closed as program error.

Error description

• This fix is provided for performance improvement during
  rebuilding of the search index. This
  includes:
  
  1.creation of a new index in ICMSTJCRTSPATHINFO table
  2.remove indexid column from sql : SELECT ORIGPARENT FROM
  jcr.ICMSTJCRTSPATHINFO
  WHERE DATAID = ? Note: This sql got executed 72957 times in TAP
  with 400k nodes.
  3.remove the call to check if the original parent exists based
  on the count(*)
  of sql statement and base whether it exists on whether the
  query
  returned data.
  

Local fix

• None available
  

Problem summary

• Index data was updated
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WEBSPHERE PORTA

• Fixed component ID

  5724E7600

Applicable component levels

• R60E PSY

     UP

• R60G PSY

     UP