PM69968: 00E2000F ABEND BECAUSE THE SQDA IN ZDSC STRUCTURE IS TOO BIG AND OVERLAY THE BLOCK TRAILER 12/10/04 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2DDF DB2DRDA DB2SP defects pm69968 dpm69968
  00E2000F abend because the SQDA in ZDSC structure is too big and
  overlay the block trailer.  This problem likely occurs because
  of a specific flow from the DB2 for i server.
  *************************************************************
  Additional Symptoms and Keywords:
   ABEND04E AB04E S04E 04E
    04E-00E2000F 00E2000F RC00E2000F
     DSNLZS00 DSNSVSFB DSNLZS00.DSNSVSFB+0858 0858 OFFSET0858
   OVERLAY OVERLAID OVRLAY
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Distributed Data Facility (DDF) users.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: An application on a requester system    *
  *                      (Site 1) calls a remote stored          *
  *                      procedure on a DB2 10 for z/OS server   *
  *                      (Site 2), where the stored procedure    *
  *                      returns a static cursor retrieving      *
  *                      data from a DB2 i server (Site 3).      *
  *                      DB2 10 (Site 2) abends as follows:      *
  *                        04E-00E2000F DSNLZS00.DSNSVSFB+0858   *
  *                      This causes DB2 to terminate as a       *
  *                      result.  The problem occurs after APAR  *
  *                      PM51918 (PTF UK76107) is applied.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An application on a remote requester system (Site 1) calls a
  stored procedure on a DB2 10 for z/OS server (Site 2).  The
  stored procedure OPENs a static cursor WITH RETURN on a remote
  DB2 i server (Site 3).  As part of the DRDA OPEN request
  (OPNQRY), the DB2 10 for z/OS (Site 2) server specifies the
  return of column information for the result set (SQLDARD) but
  the DB2 i (Site 3) server does not return this requested
  information.  Because of this missing information, the DB2 10
  for z/OS (Site 2) server incorrectly computes the amount of
  storage needed for its processing.  The allocated storage is
  too small and a storage overlay occurs as a result.  This
  overlay is subsequently detected, in the form of an abend
  04E-00E2000F during DB2 must-complete thread termination
  processing, causing the DB2 10 for z/OS subsystem to
  terminate abnormally.
  The problem occurs after APAR PM51918 (PTF UK76107) is applied.
  
  Additional Keywords:
  IDAAV2R1/K IDAAV3R1/K
  

Problem conclusion

• DB2 10 for z/OS, when processing a stored procedure invoked by
  an application on a remote requester, has been changed to
  compute the correct amount of storage needed for the processing
  of static result sets returning data from remote DB2 i servers.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK81900

Modules/Macros

• DSNLXGVR
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK81900

     UP12/10/04 P F210 ®

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.