IT27904: QUERY FAILS WITH SQLCODE -901

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