IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    IT21996

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-08-12

  • Closed date

    2018-03-16

  • Last modified date

    2018-03-16

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"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:
16 March 2018