IBM Support

PI56852: DML STATEMENT FOR ACCELERATOR ONLY TABLE IS MISSING FOR REMOTE PROCEDURES

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When DML statements against Accelerator Only Table are executed
    from a remote procedure and they're offloaded to an accelerator,
    the original statement text is not sent. Therefore the statement
    text is missing in ACCEL_GET_QUERIES stored procedure or Query
    Monitoring sectioin in IDAA Studio.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 10 and DB2 11 for z/OS users of remote   *
    *                 stored procedures that contain INSERT,       *
    *                 UPDATE, or DELETE statements on an           *
    *                 accelerator only table.                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: INSERT, UPDATE, or DELETE statement on  *
    *                      an accelerator only table does not show *
    *                      the statement text on query monitoring  *
    *                      tools on accelerator.                   *
    ****************************************************************
    * RECOMMENDATION: DB2 should not update the length field of    *
    *                 original DB2 SQL text of an INSERT/UPDATE/   *
    *                 DELETE statement for accelerator only table. *
    ****************************************************************
    DB2 code mistakenly updates the length field of the original DB2
    SQL statement text of the INSERT, UPDATE, or DELETE statement.
    This does not affect the accelerated statements that are
    executing on the accelerator.
    

Problem conclusion

  • DB2 code is modified to not update the original DB2 SQL text of
    the INSERT, UPDATE, or DELETE statement.
    
    Additional Keywords:
    IDAAV4R1/K IDAAV5R1/K SQLPROCEDURE SQLSP SQLSTOREDPROC
    SQLUPDATE SQLINSERT SQLDELETE
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI56852

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-02-09

  • Closed date

    2016-03-30

  • Last modified date

    2016-05-04

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

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

    UI36628 UI36629

Modules/Macros

  • DSNXEPM
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI36628

       UP16/04/15 P F604

  • RB10 PSY UI36629

       UP16/04/15 P F604

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.



Document information

More support for: DB2 for z/OS

Software version: A10

Reference #: PI56852

Modified date: 04 May 2016


Translate this page: