PM73056: DDF SERVER THREAD ABEND04E 00E70005 FROM DSNXGRDS.DSNXVTXM M421 CALLER IS DSNLZOSR

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2DDF DB2DRDA defect pm73056 dpm73056
    A DDF server thread abends with 04E-00E70005
    from DSNXGRDS.DSNXVTXM M421 when flowing a blank
    set current routine version special register. The caller
    caller of DSNXVTXM is DSNLZOSR.
    **************************************************************
    Additional Symptoms and Keywords:
     ABEND04E AB04E S004E 04E
      04E-00E70005 00E70005 RC00E70005
       DSNXVTXM DSNXVTXM:M421 M421
     SQLCODE725 SQL725N SQL0725N SQL00725N -725 DSNLZOSR
    

Local fix

  • no local workaround or fix
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Distributed Data Facility (DDF) users.   *
    *                 Specifically users of the SET CURRENT        *
    *                 ROUTINE VERSION statement.                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following symptoms may occur for    *
    *                      two independent problems:               *
    *                      1-ABEND 04E-00E70005                    *
    *                        LOC=DSNXGRDS.DSNXVTXM:M421            *
    *                      2-SQLCODE -725 THE SPECIAL REGISTER     *
    *                        register AT LOCATION location WAS     *
    *                        SUPPLIED AN INVALID VALUE             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The summary of the two independent problems are:
    1-An application on a remote client system (Site 1), using
      transaction pooling, calls a stored procedure on a DB2 for
      z/OS server (Site 2) that executes a SET CURRENT ROUTINE
      VERSION that assigns a value of one or more blanks.  The
      stored procedure completes and returns to the application
      which subsequently drives commit or rollback to complete the
      transaction.  During subsequent transaction processing, the
      client (Site 1) sends the routine version with a value that
      had been set by the stored procedure in the previous
      transaction processing.  The DB2 for z/OS (Site 2) thread
      abends with ABEND 04E-00E70005 LOC=DSNXGRDS.DSNXVTXM:M421.
    2-An application on a DB2 for z/OS requester (Site 1) executes
      a SET CURRENT ROUTINE VERSION that assigns an empty string
      value.  The DB2 for z/OS Site 1 requester erroneously sends
      an invalid special register value when the application
      executes an SQL statement containing a 3-part-name reference
      to a DB2 for z/OS server (Site 2).  The DB2 for z/OS Site 2
      server detects the invalid special register value and issues
      SQLCODE -725.
    

Problem conclusion

  • The conclusion for the two independent problems are:
    1-DB2 for z/OS, acting as a server, has been changed to
      correctly process SET CURRENT ROUTINE VERSION with an
      assigned value of one or more blanks.
    2-DB2 for z/OS, acting as a requester, has been changed to
      correctly process SET CURRENT ROUTINE VERSION with an
      assigned empty string value.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM73056

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-09-17

  • Closed date

    2012-11-13

  • Last modified date

    2012-12-04

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

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

    UK83480 UK83481

Modules/Macros

  •    DSNLXSR  DSNLZOSR
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK83480

       UP12/11/28 P F211

  • R910 PSY UK83481

       UP12/11/28 P F211

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM73056

Modified date:

2012-12-04

Translate my page

Machine Translation

Content navigation