IBM Support

IT23578: SQL STATEMENT CONTAINING UNION ALL WITH JOINS ON MISMATCH DATA TYPES MIGHT FAIL IN DPF WITH A SQL0901 ERROR

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Your SQL statement might fail in DPF with a SQL0901 if it
    contains the following:
    - a UNION ALL
    - each branch of the UNION contains one or more joins on columns
    with mismatch data types
    - one or more of the columns referenced in the join are in the
    SELECT list
    
    If you hit this failure, you will  see the following in the
    db2diag.log file:
    
    2017-11-21-09.18.36.719390-300 I67997E1072           LEVEL:
    Severe
    PID     : 24158                TID : 140734556530432 PROC :
    db2sysc 1
    INSTANCE: xxxxxx             NODE : 001            DB   : xxxxx
    APPHDL  : 0-53                 APPID: xxxxxx
    AUTHID  : xxxxxx             HOSTNAME: xxxxx
    EDUID   : 202                  EDUNAME: db2agntp (xxxxx) 1
    FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
    probe:250
    MESSAGE : ZRC=0x820B0001=-2113208319=SQLKB_NONSEVERE_PGM_ERROR
              "Non-severe programming error."
              DIA8532C An internal processing error has occurred.
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 39
     sqlerrmc: probe 040 in sqlktins(), msg=sqlkbndn()
     sqlerrp : SQLRI088
     sqlerrd : (1) 0x820B0001      (2) 0x00000001      (3)
    0x00000000
               (4) 0x00000000      (5) 0xFFFFFE0C      (6)
    0x00000001
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
    
    2017-11-21-09.37.17.455219-300 I210047E524           LEVEL:
    Error
    PID     : 29742                TID : 140734065796864 KTID : 1926
    PROC    : db2sysc 1
    INSTANCE: xxxxxx             NODE : 001            DB   : xxxxxx
    APPHDL  : 0-55                 APPID: xxxxxx
    AUTHID  : xxxxxx             HOSTNAME: xxxxxx
    EDUID   : 149                  EDUNAME: db2agntp (xxxxxx) 1
    FUNCTION: DB2 UDB, bucket map services, sqlkbptn, probe:447
    DATA #1 : <preformatted>
    [0] unexpected src len > can_len (25 > 14)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 6 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT23578

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-12-26

  • Closed date

    2021-02-22

  • Last modified date

    2021-02-22

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

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

    IT35997

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
27 February 2021