IBM Support

PM44338: performance issue when importing entity definitions into encyclopedia

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Client is using SA 11.4.0.3 + Oracle 10g, they got performance
    issue when try to import entity definition into encyclopedia,
    when they try to import a csv with about 1400 rows, it take
    several days to import the csv file.
    
    Workaround:
    
    In the sa2001.ini file, under the [SystemArchitect] section
    enter DisableMirroring=Y
    
    Do the import
    
    Then in the sa2001.ini file set DisableMirroring=N
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Client is using SA 11.4.0.3 + Oracle 10g, they got
    performance issue when try to import entity definition into
    encyclopedia, when they try to import a csv with about 1400
    rows, it take several days to import the csv file.
    

Problem conclusion

  • Other improvements to performance have been made in the
    11.4.2.2 release which addressed this issue. In addition
    using SQL Server improves performance over using Oracle. The
    client has upgraded to version 11.4.2.2 and is now using SQL
    Server, and accept the performance. The client has agreed to
    close the case.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM44338

  • Reported component name

    TLOGIC SYS ARCH

  • Reported component ID

    5724V68SA

  • Reported release

    B40

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-07-24

  • Closed date

    2013-03-13

  • Last modified date

    2013-03-13

  • 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

    TLOGIC SYS ARCH

  • Fixed component ID

    5724V68SA

Applicable component levels

  • RB40 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS6RBX","label":"Rational System Architect"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.4","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
13 March 2013