IBM Support

PI77849: VARCHAR_FORMAT AGAINST CHAR/VARCHAR COLUMN ON IDAA RETURN SQLCODE -901

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • VARCHAR_FORMAT AGAINST CHAR/VARCHAR COLUMN ON IDAA RETURN
    SQLCODE -901
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 for z/OS users of IBM DB2 Analytics  *
    *                 Accelerator V4 or V5 for DB2 QUERY           *
    *                 ACCELERATION and the DB2 built-in function   *
    *                 VARCHAR_FORMAT where the first argument of   *
    *                 the BIF is a character data type.            *
    ****************************************************************
    * PROBLEM DESCRIPTION: An accelerated query using the built-in *
    *                      function VARCHAR_FORMAT may incorrectly *
    *                      result in SQLCODE -901 from the         *
    *                      Accelerator when the first argument of  *
    *                      the BIF references a character column.  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An accelerated DB2 query containing the built-in function
    VARCHAR_FORMAT may incorrectly result in SQLCODE -901 or
    SQLCODE -904 from the Accelerator when the first argument
    of the BIF references a CHAR, VARCHAR, GRAPHIC, or
    VARGRAPHIC column.
                                   .
    The IBM DB2 Analytics Accelerator Version 4 or Version 5 does
    not support these data/column types for the first argument of
    BIF VARCHAR_FORMAT, and that is why the query failed on
    the Accelerator with SQLCODE -901 (or -904).
    Instead, DB2 should not send such a query to the Accelerator
    but either run it only in DB2, or if the query should only
    be accelerated and not run in DB2, DB2 must fail the query
    with SQLCODE -4742 and Reason = 19, which means that
    the Accelerator is 'down-level' and does not support
    this query. Reason=19 is used because this problem does not
    occur with the IBM DB2 Analytics Accelerator Version 6, which
    supports this VARCHAR_FORMAT argument type usage. So the query
    with this specific VARCHAR_FORMAT can be accelerated to
    Accelerator V6.
                                    .
    This problem does not occur for the built-in function
    VARCHAR_FORMAT if the first argument does not use a CHAR,
    VARCHAR, GRAPHIC,or VARGRAPHIC column, and those queries
    are successfully accelerated.
    

Problem conclusion

  • DB2 has been modified so that a query using the built-in
    function VARCHAR_FORMAT with the first argument as a CHAR,
    VARCHAR, GRAPHIC, or VARGRAPHIC column, is not accelerated
    to IBM DB2 Analytics Accelerator V4 or V5. DB2 will either
    run this query only in DB2, or if the query should only be
    accelerated and not run in DB2, DB2 will fail the query with
    SQLCODE -4742 and Reason = 19, which means that the
    Accelerator is 'down-level' and does not support this query.
    
    ADDITIONAL KEYWORDS:
    IDAAV4R1/K IDAAV5R1/K
    INCORROUT
    SQLCODE901
    SQLCODE904
    SQLCODE4742
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI77849

  • Reported component name

    IDAA FOR ZOS

  • Reported component ID

    5697AQT00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-03-08

  • Closed date

    2017-06-01

  • Last modified date

    2017-07-05

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

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

    UI47717

Modules/Macros

  • DSNXOD5  DSNXONZA DSNXORFN
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI47717

       UP17/06/17 P F706

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:
05 July 2017