IBM Support

PI39063: NEW ACCELERATOR REASON CODE FOR AN UNSUPPORTED COLUMN DATATYPE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • New accelerator reason code for an unsupported column datatype.
    (DN1862)
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 11 for z/OS who use query   *
    *                 acceleration.                                *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR adds a new reason code        *
    *                      for SQLCODE -4742 and a new             *
    *                      value for column REASON_CODE in         *
    *                      explain table DSN_QUERYINFO_TABLE for   *
    *                      an unsupported column data type.        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Currently an unsupported column data type referenced in a
    statement will issue SQLCODE -4742 reason code 11. EXPLAIN of
    the statement will have REASON_CODE = 11 in explain table
    DSN_QUERYINFO_TABLE.
    This APAR adds a new reason code value 25 for SQLCODE -4742 and
    25 for column REASON_CODE in explain table
    DSN_QUERYINFO_TABLE for an unsupported column data type.
    
    Keywords:
    IDAAV4R1/K SQLCODE4742
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI39063

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function

  • Submitted date

    2015-04-14

  • Closed date

    2015-07-02

  • Last modified date

    2015-08-03

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

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

    UI29044

Modules/Macros

  •    DSNXOD5  DSNXOEX1 DSNXOOS1
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI29044

       UP15/07/17 P F507

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: B10

Reference #: PI39063

Modified date: 03 August 2015


Translate this page: