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

Obtain the fix for this APAR.

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 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.