PM81551: Refactor the high time consuming Fact builds - Build_F_REL_REQUE ST_TURN_METRICS/Build_F_RELEASE_REQUEST_METRICS (WI 66458)

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • User may notice the following builds taking longer than normal
    to execute.
    
    Build_F_REL_REQUEST_TURN_METRICS
    Build_F_RELEASE_REQUEST_METRICS
    
    Development has optimized the queries in a future release.
    Refer to the following defect work item for details:
    
    https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.
    WorkItem/66458
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Refactor the high time consuming Fact builds -
    Build_F_REL_REQUEST_TURN_METRICS/Build_F_RELEASE_REQUEST_MET
    RICS
    

Problem conclusion

  • One of the SQL queries was using wrong condition that cause
    reported issue. Solution was to fix this condition.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM81551

  • Reported component name

    RATL INSIGHT

  • Reported component ID

    5724Y0500

  • Reported release

    111

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-28

  • Closed date

    2013-06-14

  • Last modified date

    2013-06-14

  • 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

    RATL INSIGHT

  • Fixed component ID

    5724Y0500

Applicable component levels

  • R111 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Insight

Software version:

1.1.1

Reference #:

PM81551

Modified date:

2013-06-14

Translate my page

Machine Translation

Content navigation