JR50043: Duplicate assigned attribute values can cause a performance impa ct

7.0.0.9 for Developer Express
7.0.0.9 for Developer Professional
7.0.0.9 for Developer Enterprise
7.0.0-WS-WCServer-FP009

APAR status

• Closed as program error.

Error description

• The attribute dictionary data model allows for sharing and reuse
  of attributes by using the "allowed value" attribute type. If
  the "assigned value" attribute type is used instead, the
  attribute value information is not shared.
  
  When multiple products have values that are logically the same,
   using  assigned values attributes creates duplication in the
  ATTRVAL and ATTRVALDESC tables leading to performance
  degradation.
  

Local fix

Problem summary

• Duplicate assigned attribute values can cause a performance
  impact
  

Problem conclusion

• This ifix introduces changes to the way Data Load, Catalog
  Upload and Management Center handle attribute dictionary -
  assigned attribute values to allow for sharing of attribute
  data.
  
  Two additional configuration flags are introduced:
  
  1) Attributes/KeepAssignedAttributeValueLocal (default true) in
  wc-business-object-mediator.xml  for Management Center
  2) shareAssignedAttributeValues (default true) for
  com.ibm.commerce.catalog.dataload.mediator.CatalogEntryAttribute
  DictionaryAttributeMediator for the dataload utility and catalog
  upload
  
  These flags are used to control the following behaviors:
  
  When an assigned value attribute is added to a product, the
  dictionary will now be consulted to see if the value already
  exists for the attribute.  If it does, the product's attribute
  value will stored as a reference to the existing value.
  
  When an attribute value is changed for a product, the dictionary
  is consulted to determine if the new value already exists for
  the attribute. If it does, the product's attribute value is
  simply changed to use the existing attribute value.
  
  If the new attribute value does not already exist in the
  dictionary, it will be added and the product's attribute value
  will use the newly created attribute value.
  
  Any products which reference the previous value will be
  unaffected.
  

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

  WC BUS EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP