IBM Support

JR49546: CMVC 234691 - Slow performance when loading attribute values into workspaces with dataload.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When loading attribute values into a workspace with the dataload
    utility, slow performance from the following SQL may be
    noticed:
    
     SELECT CATENTRY_ID, ATTRVALUE_ID, LANGUAGE_ID,
     NAME, ATTRTYPE_ID, SEQUENCE, STRINGVALUE, INTEGERVALUE,
    FLOATVALUE,
     IMAGE1, IMAGE2, FIELD1, FIELD2, FIELD3, QTYUNIT_ID,
    ATTACHMENT_ID FROM
     ATTRVALUE WHERE ATTRVALUE_ID IN (SELECT ATTRVALUE_ID FROM
    ATTRVALUE
     WHERE ATTRIBUTE_ID=? AND CATENTRY_ID IN (0, ?) AND
    LANGUAGE_ID=? AND
     NAME=?) ORDER BY CATENTRY_ID DESC
    

Local fix

Problem summary

  • USERS AFFECTED:
     WebSphere Commerce V7 users loading attribute values into
    workspaces with dataload
    
     PROBLEM ABSTRACT:
     Slow performance when loading attribute values into workspaces
    with dataload.
    
     BUSINESS IMPACT:
     Dataload will take much longer than expected
    
     RECOMMENDATION:
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    JR49546

  • 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

    2014-03-06

  • Closed date

    2014-03-26

  • Last modified date

    2014-03-26

  • 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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]

Document Information

Modified date:
11 December 2021