IBM Support

JR61510: DB2 CONNECTOR SUPPORT FOR EXTERNAL TABLES IN READING AND WRITING MODES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • DB2 Connector support for external tables in reading and
    writing modes
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Users using DB2 connector
    ****************************************************************
    PROBLEM DESCRIPTION:
    An external table allows DB2 to treat a flat file as a database
    table. The use of external tables might improve read and write
    performance, compared to classic SELECT, INSERT or UPDATE
    statements.
    Current DB2 Connector functionality is limited to bulk load
    using external tables.
    ****************************************************************
    RECOMMENDATION
    Install patch JR61510
    ****************************************************************
    

Problem conclusion

  • DB2 Connector introduces support for external tables in most
    read and write modes. Note that not all DB2 database products
    support the external tables feature.
    
    For detailed information on environment setup and connector
    configuration please refer to technote "DB2 connector support
    for external tables in read and write modes" available at:
    
    https://www.ibm.com/support/pages/node/959375
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR61510

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    B70

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-09-19

  • Closed date

    2019-10-25

  • Last modified date

    2019-10-25

  • 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

  • RB70 PSY

       UP

  • RB71 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.7","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 October 2021