IBM Support

PH21925: ECLIPSELINK DB2ZPLATFORM USES INVALID QUERY TO PING DATABASE

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • EclipseLink uses the query "VALUES(1)" to test database
    connections for DB2 z/os. This query is invalid for this
    platform.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server - Java Persistence API - JPA 2.1,    *
    *                  EclipseLink, DB2 z/OS                       *
    ****************************************************************
    * PROBLEM DESCRIPTION: EclipseLink runs a query "VALUES(1)"    *
    *                      to test database connectivity. This     *
    *                      query is invalid for DB2 z/OS           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    EclipseLink runs the query "VALUES(1)" to test connectivity to
    the database when a query exception occurs. This query is
    invalid for DB2 z/OS and will fail. This can cause errors to be
    logged on the database, but EclipseLink will swallow the
    failure and not change behavior.
    The correct query for DB2 is to query the SYSIBM.SYSDUMMY1
    table.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH21925

  • Reported component name

    WEBSPHERE FOR Z

  • Reported component ID

    5655I3500

  • Reported release

    900

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-02-07

  • Closed date

    2020-05-29

  • Last modified date

    2020-05-29

  • 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

    WEBSPHERE FOR Z

  • Fixed component ID

    5655I3500

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS7K4U","label":"WebSphere Application Server for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
30 May 2020