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 ONE Support launchpad (Login required).

Search for additional results

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