IBM Support

JR43373: CMVC 223441 - Provide the fixes needed for IBM i support on Feature Pack 5

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This APAR addresses two issues to complete support in Feature
    Pack 5 for IBM i:
      - failure to enable content versioning successfully
      - when using a multi-byte language, attributes may not display
    correctly when Show Facets is selected in Management Center or
    as store front facet values
    

Local fix

Problem summary

  • USERS AFFECTED:
     IBM i customers who want to install and use the WebSphere
    Commerce V7 Feature Pack 5 and use any of the following features
     - content versioning
     - search facets using multi-byte languages.
    
     PROBLEM ABSTRACT:
     Provide the fixes needed for IBM i support on Feature Pack 5
    
     BUSINESS IMPACT:
     - content versioning can't be enabled successfully
      - search facets do not display correctly when using a
    multi-byte language in the Management Center or on the store
    front.
    
     RECOMMENDATION:
    

Problem conclusion

  • Content versioning: Changes required on database schema on a
    DB2/iSeries platform for content-versioning to be enabled
    successfully were being prevented by a limitation on the
    DB2/iSeries database. The limitation entails not being able to
    create a databas
    e ALIAS that references another ALIAS. This was resolved by
    determining the base TABLE for each source ALIAS referenced, and
    using that as the source for to-be-created ALIAS instead.
    
     Search facets: Previous encoding of attribute dictionary
    attribute value for temporary table of pre-process in IBMi DB2
    is the default CLOB. But this is problematic when stored content
    is a multi-byte language such as Chinese, Japanese, Korean. The
    fix is
     to change the encoding of CLOB of those temp tables into DBCLOB
    CCSID 13488.
    
     -------------------------------------------------------------
     The latest available maintenance information can be obtained
    from the Recommended Fixes for WebSphere Commerce technote:
     http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR43373

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-09

  • Closed date

    2013-06-17

  • Last modified date

    2013-06-17

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 June 2013