IT21996: SQL0901N ERROR CAN BE HAPPENED WHEN USING AN INDEX ON EXPRESSION

Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as fixed if next.

Error description

• When an application uses index on expression package
  and 'current package path' is set but SYSIBM is not part of it,
  it would hit the -901 error.
  
  SQL0901N  The SQL statement or command failed because of a
  database system
  error. (Reason "index on expression package not found!".)
  SQLSTATE=58004
  
  db2diag log may report the following patterns.
  
  FUNCTION: DB2 UDB, relation data serv, sqlrrSqlCode, probe:15
  DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
  sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -805   sqlerrml: 42
  
  
  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: 38
  sqlerrmc: index on expression package not found!
  

Local fix

• Add 'SYSIBM' into current package path.
  
  For example,
  SET CURRENT PACKAGE PATH '<your package path name to use in
  applications>,SYSIBM'
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * DB2 V11.1                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 V11.1 FP3                                     *
  ****************************************************************
  

Problem conclusion

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

Applicable component levels

• RB10 PSY

     UP