IBM Support

JR60794: DB2 CONNECTOR DOES NOT PROVIDE OPERATIONAL METADATA FOR USER-DEFINED SQL WRITE MODE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 connector does not provide operational metadata for
    User-defined SQL write mode
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    IIS users using DB2 connector with User-defined SQL write mode
    who rely on operational metadata gathering as part of job
    execution.
    ****************************************************************
    PROBLEM DESCRIPTION:
    DB2 connector does not provide operational metadata information
    about tables
    used in User-defined SQL statements. However, operational
    metadata is gathered
    correctly for other operation modes, no matter if the SQL is
    generated
    automatically or provided by user.
    
    The problem is caused by the fact that the logic responsible for
    gathering
    operational metadata is not processing the User-defined SQL at
    all.
    ****************************************************************
    RECOMMENDATION:
    Install patch for APAR JR60794.
    ****************************************************************
    

Problem conclusion

  • DB2 Connector operational metadata processing logic has been
    modified to get
    the User-defined SQL statement and gather table information
    based on it.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR60794

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-03-13

  • Closed date

    2019-03-28

  • Last modified date

    2019-03-28

  • 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

  • RB50 PSY

       UP

  • RB70 PSY

       UP

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

Document Information

Modified date:
17 October 2021