IBM Support

IT27904: QUERY FAILS WITH SQLCODE -901

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

  • 2019-01-22-17.51.59.884727-300 I3400A888 LEVEL: Severe
    PID : 11075818 TID : 2058 PROC : db2sysc
    INSTANCE: agkoile NODE : 000 DB : PANNA
    APPHDL : 0-84 APPID: *LOCAL.agkoile.190122224749
    AUTHID : AGKOILE HOSTNAME: bugdbug
    EDUID : 2058 EDUNAME: db2agent (PANNA)
    FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
    probe:250
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 33
    sqlerrmc: Missing mapping for function 1931
    sqlerrp : SQLNT011
    sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0xFFFFDA69 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:
    
    
    2019-01-22-17.52.00.124685-300 E101537A3336 LEVEL: Info (Origin)
    PID : 11075818 TID : 2058 PROC : db2sysc
    INSTANCE: agkoile NODE : 000 DB : PANNA
    APPHDL : 0-84 APPID: *LOCAL.agkoile.190122224749
    AUTHID : AGKOILE HOSTNAME: bugdbug
    EDUID : 2058 EDUNAME: db2agent (PANNA)
    FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
    MESSAGE : ZRC=0x803100AF=-2144272209=SQLNN_E_BADNEWS
    "unexpected error but state is OK"
    DATA #1 : String, 62 bytes
    An unexpected error was detected during statement compilation.
    DATA #2 : Boolean, 1 bytes
    true
    DATA #3 : Boolean, 1 bytes
    false
    DATA #4 : Boolean, 1 bytes
    true
    DATA #5 : Boolean, 1 bytes
    false
    DATA #6 : Hex integer, 4 bytes
    0x00000000
    DATA #7 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 33
    sqlerrmc: Missing mapping for function 1931
    sqlerrp : SQLNT011
    sqlerrd : (1) 0x801A006D (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0xFFFFDA69 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:
    DATA #8 : Hex integer, 4 bytes
    0x00000040
    DATA #9 : String with size, 1000 bytes
    select case when UB2_66_VTE_41_45_LEB_HH.UB2_RIEHZ_LEB_ST_MIN >
    10101 THEN round(months_between( date(
    replace(substr(cast(cast(UB2_66_VTE_41_45_LEB_HH.UB2_RIEHZ_LEB_S
    T_MIN as INTEG
    ER) as varchar(10)),1,4),'.','')||'-'||
    replace(substr(cast(cast(UB2_66_VTE_41_45_LEB_HH.UB2_RIEHZ_LEB_S
    T_MIN as INTEGER) as varchar(10)),5,2),'.','')||'-'||
    replace(substr(cast(cast(
    UB2_66_VTE_41_45_LEB_HH.UB2_RIEHZ_LEB_ST_MIN as INTEGER) as
    varchar(10)),7,2),'.','')),
    last_day(replace(substr(cast(cast(MDS_MEDIZDUO_PROPH_ZV_0_1_HH_S
    4a.MONATSID as INTEGER) as varc
    har(10)),1,4),'.','')||'-'||
    replace(substr(cast(cast(MDS_MEDIZDUO_PROPH_ZV_0_1_HH_S4a.MONATS
    ID as INTEGER) as varchar(10)),5,2),'.','')||'-01')),0) ELSE 0
    END as UB2_RIEHZ_LEB_ST_MIN
    from ANA_ADS.MDS_MEDIZDUO_PROPH_ZV_0_1_HH_S4A as
    MDS_MEDIZDUO_PROPH_ZV_0_1_HH_S4a inner join
    ANA_ADS.HH_UBX_PARTNER_02 as HH_UBX_Partner_02 on (
    (MDS_MEDIZDUO_PROPH_ZV_0_1_HH_S4a.MON
    ATSID = HH_UBX_Partner_02.MONATSID and
    MDS_MEDIZDUO_PROPH_ZV_0_1_HH_S4a.TMP_GRP1_ID =
    DATA #10: String, 974 bytes
    Compiler error stack for rc = -2144272209:
    sqlnn_cmpl[380]
    sqlno_exe[2020]
    sqlno_final_phase[150]
    sqlnt_main[140]
    sqlnt_walk_[355]
    sqlnt_walk_[326]
    sqlnt_walk_remote[568]
    sqlnt_translate_ship[1339]
    sqlnt_add_select_list[5023]
    sqlnt_add_select_list[4763]
    sqlnt_add_column_reference[9090]
    sqlnt_add_column_reference[8791]
    sqlnt_add_column_reference[8547]
    sqlnt_add_expression[13127]
    sqlnt_add_expression[13085]
    sqlnt_add_function[12868]
    sqlnt_add_function[10684]
    sqlnt_add_expression[13127]
    sqlnt_add_expression[13085]
    sqlnt_add_function[12868]
    sqlnt_add_function[11309]
    sqlnt_add_expression[13127]
    sqlnt_add_expression[13085]
    sqlnt_add_function[12868]
    sqlnt_add_function[10684]
    sqlnt_add_expression[13127]
    sqlnt_add_expression[13085]
    sqlnt_add_function[12868]
    sqlnt_add_function[10684]
    sqlnt_add_expression[13127]
    sqlnt_add_expression[13085]
    sqlnt_add_function[12868]
    sqlnt_add_function[10684]
    sqlnt_add_expression[13127]
    sqlnt_add_expression[13085]
    sqlnt_add_function[12868]
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * QUERY FAILS WITH SQLCODE -901                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * First fixed in v11.1 fp6                                     *
    ****************************************************************
    

Problem conclusion

  • First fixed in v11.1 fp6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT27904

  • 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

    2019-01-28

  • Closed date

    2020-03-09

  • Last modified date

    2020-03-09

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 March 2020