SAP Knowledge Base Article - Preview

2894304 - DB6 . . . SQL20249N The statement was not processed because the package named NULLID.* . . . SQL0595W . . . SQL0082C

Symptom

  • db2diag.log
     . . .
       YYYY-MM-DD-24.mm.ss.msmsms+### I#######F####        LEVEL: Error
       PID     : ####                 TID : ####           PROC : db2bp.exe
       INSTANCE: DB2<SID>             NODE : 000           DB   : <SID>
       APPID   : *LOCAL.DB2<SID>.############
       HOSTNAME: <hostnm>
       EDUID   : ####
       FUNCTION: DB2 UDB, base sys utilities, sqleUpgradeTS, probe:1485
       DATA #1 : String, 49 bytes
       failed to check if db is enabled for text search.
       DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
        sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -20249   sqlerrml: 15
        sqlerrmc: NULLID.SQLE0O07
        sqlerrp : SQLRA144
        sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3) 0x00000000
                  (4) 0x00000000      (5) 0xFFFFFD92      (6) 0x00000000
        sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)   
                  (7)      (8)      (9)      (10)        (11)    
        sqlstate:     

     . . .
       YYYY-MM-DD-24.mm.ss.msmsms+### E#######F### LEVEL: Error
       PID : #### TID : #### PROC : db2bp.exe
       INSTANCE: DB2<SID> NODE : 000 DB : <SID>
       APPID : *LOCAL.DB2<SID>.############
       HOSTNAME: <hostnm>
       EDUID : ####
       FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsDbInfo::validateBaseTables, probe:300
       MESSAGE : ZRC=0xFFFFB0E7=-20249
       SQL20249N The statement was not processed because the package named
       "" needs to be explicitly rebound.
      
       DATA #1 : <preformatted>
       [IBM][CLI Driver][DB2/NT64] SQL20249N The statement was not processed because the package named "NULLID.SYSSH200" needs to be explicitly rebound.

  • db2ubind_lst.log
     . . .
       LINE MESSAGES FOR db2uimpm.bnd . . . db2clpcs.bnd . . . db2clprr.bnd . . . db2clpur.bnd . . . db2clprs.bnd . . . db2clpnc.bnd
       ------ --------------------------------------------------------------------
                 SQL20249N The statement was not processed because the
                 package named "NULLID.SQLABO02" needs to be explicitly
                 rebound.
     . . .
                SQL0595W Isolation level "NC" has been escalated to "UR".
                SQLSTATE=01526
     . . .
      LINE MESSAGES FOR db2ubind.lst
      ------ --------------------------------------------------------------------
                SQL0082C An error has occurred which has terminated
                processing.


Read more...

Environment

upgrading from
    IBM Db2 11.1.4.4 to  IBM Db2 11.1.4.5

Product

SAP ERP 6.0

Keywords

KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.