|
Problem IT21996
|
Status: Closed |
SQL0901N ERROR CAN BE HAPPENED WHEN USING AN INDEX ON EXPRESSION |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem 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! |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 V11.1 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V11.1 FP3 *
**************************************************************** |
| Local Fix: |
Add 'SYSIBM' into current package path.
For example,
SET CURRENT PACKAGE PATH '<your package path name to use in
applications>,SYSIBM' |
| available fix packs: |
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
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.08.2017
16.03.2018
16.03.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
