IBM Support

JR57987: PARSING VIEWS ON NETEZZA FAILS FOR LINEAGE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When Views on Netezza are defined across multiple databases
    product fails to correctly parse them. The logic of parsing the
    views assumes that views and tables are defined on the same
    database. In case of Netezza user can create views by taking
    columns from multiple databases. A new code addresses such
    situation by adding to lookup queries information about
    databases.
    

Local fix

Problem summary

  • *********************************************
    APAR Users Affected:
    *********************************************
    Users running lineage on views defined on Netezza databases
    
    *********************************************
    APAR Problem Description:
    *********************************************
    When Views on Netezza are defined across multiple databases
    product fails to correctly parse them. The logic of parsing the
    views assumes that views and tables are defined on the same
    database. In case of Netezza user can create views by taking
    columns from multiple databases. A new code addresses such
    situation by adding to lookup queries information about
    databases.
    
    *********************************************
    APAR Recommendation:
    *********************************************
    Apply the fix for JR57987
    
    *********************************************
    

Problem conclusion

  • Apply the fix for JR57987
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR57987

  • Reported component name

    IS GOVCATLOG

  • Reported component ID

    5724Q36GC

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-06-05

  • Closed date

    2017-07-11

  • Last modified date

    2017-07-11

  • 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

    IS GOVCATLOG

  • Fixed component ID

    5724Q36GC

Applicable component levels

  • RB50 PSY

       UP

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

Document Information

Modified date:
02 June 2020