IBM Support

PI57995: TARGETLESS FETCH FAILS WITH SQLCODE -804 RC 16 IN DB2 V11. THIS OCCURS FOR LOCAL OFFLOAD QUERY AND NON-OFFLOAD QUERY WITH CBF.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Targetless FETCH fails with SQLCODE -804 Rc 16 in DB2 V11
    requester path. This occurs for local  offload query and
    non-offload query where Continous Block Fetch feature is
    enabled.
    

Local fix

  • The workaround is properly fill in SQLDA area for the FETCH INTO
    request. Or temporarily disable IDAA acceleration for that table
    only to prevent query acceleration for that query.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 11 for z/OS ODBC/CLI users of the    *
    *                 IBM DB2 Analytics Accelerator (IDAA) for     *
    *                 query acceleration.                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: An SQLCODE -804 (or SQLCODE804)         *
    *                      reason code 16 can occur for ODBC/CLI   *
    *                      applications that offload queries to    *
    *                      IDAA (IBM DB2 Analytics Accelerator).   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    A DB2 for z/OS ODBC/CLI application offloads a query to IDAA.
    The application uses the SQLFetchScroll() API or
    SQLExtendedFetch() API to fetch a block of data containing
    multiple rows with LIMITEDBLOCKFETCH=1.
    
    The SQLFetchScroll() API or SQLExtendedFetch() API may skip rows
    by internally generating a "targetless" fetch (with or without
    the SQLBindCol() API), a DB2 FETCH statement without an INTO
    clause.  During this process, an internal logic error occurs
    during the "targetless" fetch resulting in an SQLCODE -804 or
    SQLCODE +804.
    
    Please note.  This error can also occur for application packages
    bound with option DBPROTOCOL(CBF) which offloads queries and
    issues "targetless" fetches.
    

Problem conclusion

  • DB2 has been modified to correctly skip rows during targetless
    fetches for offloaded queries.
    
    Additional Keywords: IDAAV2R1/K IDAAV3R1/K IDAAV4R1/K IDAAV5R1/K
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI57995

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-02-24

  • Closed date

    2016-07-14

  • Last modified date

    2016-08-02

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

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

    006PC15 UI39387

Modules/Macros

  • DSNLZDTA
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI39387

       UP16/07/30 P F607

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 August 2016