IBM Support

JR41890: WHERE USED QUERY IN IMPACT ANALYSIS NOT FUNCTION IN CASE TABLE DEFINITION IS USED VIA SQL BUILD OPTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Where used query in Impact Analysis not function in case table
    definition is used via SQL Build option
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Use of DataStage Designer with SQL Builder and Impact Analysis
    reports.
    ****************************************************************
    PROBLEM DESCRIPTION:
    When tables are dragged onto the SQL Builder canvas, and changes
    are saved.  Any subsequent Impact Analysis operations (for
    example, Find Where Used...) would not show the correct results,
    i.e. the dependent jobs of the table definition would not be
    shown.
    ****************************************************************
    RECOMMENDATION:
    Install patch JR41890
    ****************************************************************
    

Problem conclusion

  • Install patch JR41890
    

Temporary fix

  • N/A
    

Comments

APAR Information

  • APAR number

    JR41890

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-02-21

  • Closed date

    2012-05-15

  • Last modified date

    2012-05-15

  • 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

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R850 PSY

       UP

  • R870 PSY

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5"}]

Document Information

Modified date:
07 October 2021