IBM Support

JR41180: SQL1469N MAY REPORT BECAUSE DRDA WRAPPER INCORRECTLY FORWARD THE CONNECT NODE NUMBER TO DATA SOURCE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • On a DPF system, DRDA would incorrectly forward the connect node
    number to data source, if the node number is not exist on the
    data source, you would receive SQL1469N error when accessing
    the nickname.
    
    The problem can be reproduced with below steps:
    
    1.  Setup Federation Server with below db2nodes.cfg
        1   FEDSERVER       0
        2   FEDSERVER       1
        3   FEDSERVER       2
    
    2.  Setup data source server with below db2nodes.cfg
        1   DSSERVER       0
        2   DSSERVER       1
    
    3. Connect to the Federation Server on Node number 3, access a
    nickname pointing to a table on the data source server.
    
    4. You would receive SQL1469N error because DRDA wrapper
    incorrectly forwards the connect node number 3 to data source,
    but node 3 is not exist on the data source server.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * The user is running Federation Server with DPF environment.  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Federation Server V97FP6 or later.                *
    ****************************************************************
    

Problem conclusion

  • Firstly fixed in Federation Server V9.7 FP6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR41180

  • Reported component name

    DRDA WRAPPER

  • Reported component ID

    5724N9706

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-11-09

  • Closed date

    2012-06-06

  • Last modified date

    2012-06-06

  • APAR is sysrouted FROM one or more of the following:

    JR41144

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DRDA WRAPPER

  • Fixed component ID

    5724N9706

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: InfoSphere Federation Server
Data Sources and Wrappers - DRDA

Software version: 9.7

Reference #: JR41180

Modified date: 06 June 2012