IBM Support

PI15158: ETL initialisation inefficiency - all modules in DB are being queried

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When launching an ETL, part of the initialisation iterates over
    all modules in the DB in order to retrieve URIs. This is not
    necessary, only modules in the working set need to be
    considered.
    
    The result is an initialisation time of around 30 minutes on a
    large database.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all users/environments affected                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When launching an ETL, part of the initialisation iterates   *
    * over                                                         *
    * all modules in the DB in order to retrieve URIs. This is not *
    * necessary, only modules in the working set need to be        *
    * considered.                                                  *
    *                                                              *
    * The result is an initialisation time of around 30 minutes on *
    * a                                                            *
    * large database.                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DOORS 9.6.0 and DWA.                              *
    ****************************************************************
    Its DOORS client side fix and also DWA fix.
    

Problem conclusion

  • Fixed in DOORS 9.6 and DWA. DWA is modified such that it queries
    only the modules in the working set and not all modules in DB.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI15158

  • Reported component name

    TLOGIC DOORS

  • Reported component ID

    5724V61DR

  • Reported release

    952

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-04-03

  • Closed date

    2014-06-07

  • Last modified date

    2014-06-07

  • 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 DOORS

  • Fixed component ID

    5724V61DR

Applicable component levels

  • R960 PSY

       UP



Document information

More support for: Rational DOORS

Software version: 9.5.2

Reference #: PI15158

Modified date: 07 June 2014