JR44920: CMVC 224387 - ENABLE WC SCHEMA CREATION IN PURESCALE DB2

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Schema upgrade or new instance creation may fail under the
    following conditions:
    - Back-end database being used is DB2 pureScale  AND
    - WebSphere Commerce fix pack 7.0.0.2 to 7.0.0.6 is installed
    AND
    - Either one of the following conditions is met
       - New instance is being created,  OR
       - Existing database schema is being upgraded from 7.0.0.0 or
    7.0.0.1
    
    Refer to the "Workaround" section for details on locally
    applicable fix.
    

Local fix

  • Locate the file "wcs.fixpack2.schema.sql" under the
    ${WCInstallDir}/schema/db2 directory
    - Make a backup of the file
    - Adjust the line in the file that looks like this:
    CALL SYSPROC.ADMIN_CMD ( 'REORG TABLE atchast INPLACE' );
    to
    CALL SYSPROC.ADMIN_CMD ( 'REORG TABLE atchast' );
    

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce v7.0 users (Fix Packs 7.0.0.2 to 7.0.0.6)
    with DB2 pureScale
    
    PROBLEM ABSTRACT:
    Schema upgrade failure may occur on DB2 pureScale databases
    
    BUSINESS IMPACT:
    WebSphere Commerce database schema enablement may fail when the
    back-end database is DB2 pureScale
    
    RECOMMENDATION:
    

Problem conclusion

  • Adjusted the schema upgrade process on DB2 databases to invoke
    the DB2 "REORG" command without the "INPLACE" option.
    -------------------------------------------------------------
    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

    JR44920

  • 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-11-28

  • Closed date

    2013-03-04

  • Last modified date

    2013-03-04

  • 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



Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Commerce Enterprise

Software version:

7.0

Reference #:

JR44920

Modified date:

2013-03-04

Translate my page

Machine Translation

Content navigation