IBM Support

IT27904: QUERY FAILS WITH SQLCODE -901

Subscribe

You can track all active APARs for this component.

 

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: db2inst1 NODE : 000 DB : MYDB1
    APPHDL : 0-84 APPID: *LOCAL.db2inst1.190122224749
    AUTHID : db2inst1 HOSTNAME: MYHOST1
    EDUID : 2058 EDUNAME: db2agent (MYDB1)
    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: db2inst1 NODE : 000 DB : MYDB1
    APPHDL : 0-84 APPID: *LOCAL.db2inst1.190122224749
    AUTHID : db2inst1 HOSTNAME: MYHOST1
    EDUID : 2058 EDUNAME: db2agent (MYDB1)
    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 MYTAB1.COL1 >
    10101 THEN round(months_between( date(
    replace(substr(cast(cast(MYTAB1.COL2 as INTEG
    ER) as varchar(10)),1,4),'.','')||'-'||
    replace(substr(cast(cast(MYTAB1.COL3
    as INTEGER) as varchar(10)),5,2),'.','')||'-'||
    ...
    
    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

    2022-03-31

  • 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

  • RB10 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022