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

Subscribe

You can track all active APARs for this component.

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 number

    IZ56428

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-07-31

  • Closed date

    2011-01-21

  • Last modified date

    2011-01-21

  • 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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

950

Reference #:

IZ56428

Modified date:

2011-01-21

Translate my page

Machine Translation

Content navigation