PM23958: ABEND 04E-DSNLXLLM.DSNLXCQ7:03E7

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2DDF DB2DRDA
  Abend 04E-DSNLXLLM.DSNLXCQ7:03E7 occurred due to requester
  sending cntrqyr w/qid on a different thread thant the one it
  used to OPEN the cursor.
  *****************************************************
  Additional symptoms and keywords:
   ABEND04E AB04E S004E 04E
    04E-00D3440B 00D3440B RC00D3440B DSNLXCQ7 DSNLXCQ7:03E7
     VRADC03E7 ABNDID03E7 ABID03E7
    04E-00E20005 00E20005 RC00E20005 DSNLXSSR.DSNSVBK +0988
     DSNLXSSR DSNXVBK  0988
     because erroneous CLSQRY is not detected by DDF.
    04E-00C20305 00C20305 RC00C20305 DSNBBM  .DSNB1RWI+027A
     DSNBBM   DSNB1RWI 027A
     because erroneous CLSQRY is not detected by DDF.
   SQLCA mismatch
   DRDA QRYINSID
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Distributed Data Facility (DDF) users.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following abend may occur on a DB2  *
  *                      9 for z/OS server when a remote client  *
  *                      fetches from a cursor:                  *
  *                      . ABEND04E RC00D3440B                   *
  *                        LOC=DSNLXLLM.DSNLXCQ7:03E7            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A DB2 9 for z/OS server receives a DRDA fetch request against
  an open cursor from a remote client.  The DRDA fetch request
  contains an invalid DRDA identifier (DRDA QRYINSID) for the
  cursor.  Instead of detecting and rejecting the request, DB2
  continues to process the fetch and hits the reported ABEND04E
  RC00D3440B LOC=DSNLXLLM.DSNLXCQ7:03E7.
  This problem only applies to DB2 9 for z/OS.
  

Problem conclusion

• DB2 server code has been changed to detect an invalid DRDA
  identifier (DRDA QRYINSID) on DRDA fetch requests, terminate
  fetch processing, and reply to the client that the cursor is
  not open.
  

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:

  UK63209

Modules/Macros

• DSNDPRDS DSNLXCQS DSNLXGCS DSNLXGET DSNLXGSB
  DSNLXGVR DSNLXHSP DSNLXOQS DSNLXPAL DSNLXPRC DSNLXPRS DSNLXRSS
  DSNLXRTR DSNLXXSS DSNLZSDT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK63209

     UP10/12/31 P F012

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.