IBM Support

IZ55547: Websphere App Server datasource connects first to DB2 LUW then DB2 on zSeries, zSeries connection will return -104 (SQL0104N)

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Websphere App Server datasource connects first to DB2 LUW then
    DB2 on zSeries, zSeries connection will return -104 (SQL0104N)
    

Local fix

  • Ensure that all connections to DB2 on zSeries occur before
    connecting to DB2 on distributed platforms, such as Linux, Unix,
    or Windows.
    
    When issuing getJccSpecialRegisterProperties() against the DB2
    database on zSeries, The JDBC driver issued SQL internally that
    resulted in SQL0104N.
    
    This has been fixed on v9.5 fix pack 5 and higher.
    

Problem summary

  • This has been fixed in DB2 version 9.5 fix pack 5
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IZ55547

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    950

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-07-20

  • Closed date

    2010-04-12

  • Last modified date

    2010-06-03

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

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

    IC62134

Fix information

Applicable component levels

  • R950 PSY

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950"}]

Document Information

Modified date:
04 October 2021