IZ56428: ABEND ON HOST DATABASE SERVER WHEN USING CLI ON DB2 LUW CLIENT TO EXECUTE A PREPARED STATEMENT WITH VERY MANY PARAMETER MARKERS

DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• PROBLEM DESCRIPTION:
  When a CLI (Call Level Interface) application on a DB2 LUW (DB2
  on Linux, UNIX and Windows) client that is connected to a DB2
  database on a host calls
  SQLExecute() to execute a prepared statement that has very many
  parameter markers, it causes an abend (abnormal end of task) on
  the host.
  The abend occurs because of bad DRDA
  (Distributed Relational Database Architecture) data that DB2 LUW
  sends to the host.
  The abend is ABND=04E-00D35011
  
  PROBLEM SUMMARY:
  The bad DRDA data that DB2 LUW sends is an SQLDTA object.
  The SQLDTA object contains an FDODTA object for which the
  extended length value is 4 greater than what it should be.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of application programs that run DB2 Linux, UNIX and   *
  * Windows and connect to a host database using CLI (Call Level *
  * Interface)                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When a CLI (Call Level Interface) application on a DB2 LUW   *
  * (DB2 on Linux, UNIX and Windows) client that is connected to *
  * a DB2 database on a host calls SQLExecute() to execute a     *
  * prepared statement that has very many parameter markers, it  *
  * causes an abend (abnormal end of task) on the host.          *
  *                                                              *
  * The abend occurs because of bad DRDA (Distributed Relational *
  * Database Architecture) data that DB2 LUW sends to the host.  *
  *                                                              *
  * The abend is ABND=04E-00D35011                               *
  *                                                              *
  *                                                              *
  * PROBLEM SUMMARY:                                             *
  * The bad DRDA data that DB2 LUW sends is an SQLDTA object.    *
  *                                                              *
  * The SQLDTA object contains an FDODTA object for which the    *
  * extended length value is 4 greater than what it should be.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * .                                                            *
  ****************************************************************
  

Problem conclusion

• Problem was first fixed in Version 9.5 Fix Pack 6
  

Temporary fix

Comments

APAR Information

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

  IZ56424

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

Fix information

• Fixed component name

  DB2 UDB ESE AIX

• Fixed component ID

  5765F4100

Applicable component levels

• R910 PSN

     UP

• R950 PSN

     UP