SAP Knowledge Base Article - Preview

2569186 - SQL0003N The database name is not valid Db2 LUW 11.1 Fixpack 2 - APAR IT22464

Symptom

  • The db2diag.log contains the following error message on Db2 Luw 11.1 fixpack 2

    2017-11-07-18.04.28.                                     LEVEL: Error
    PID     : 000000000            TID : 11111          PROC : db2sysc 0
    INSTANCE: db2xxx              NODE : 000           DB   : XXX
    APPHDL  : 0-0000             APPID: XXX
    AUTHID  : DB2XXX             HOSTNAME: XXX
    EDUID   : 00000               EDUNAME: db2agnts 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbFindPageInBPOrSim, probe:
    MESSAGE : ZRC=0x00000003=3
    SQL0003N  The database name is not valid.
    DIA8003C The interrupt  has been received.
  • Additionally, in the db2diag.log where there is no reoccurrence of same Pagekeys PPNum this is another indicator of the APAR IT22464.

    2017-11-07-18.04.28.                                     LEVEL: Error
    PID     : 000000000            TID : 11111         PROC : db2sysc 0
    INSTANCE: db2xxx              NODE : 000           DB   : XXX
    APPHDL  : 0-0000             APPID: XXX
    AUTHID  : DB2XXX             HOSTNAME: XXX
    EDUID   : 00000               EDUNAME: db2agnts 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbFindPageInBPOrSim, probe:
    SQL0003N  The database name is not valid.
    DIA8003C The interrupt  has been received.
    Excessive retries while removing STMM BPD
    DATA #3 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 112 bytes
    Pagekey: {pool:111;obj:1;type:0} PPNum:123456
  • An example of what to check for regarding the PPNum 
    Search with a tool like notepad++ for example to capture all occurrences. 
  • Once you have the list of Pagekey's as per the exmaple below, if this was an inconsistency issue there would be
    multiple PPNum with the same value. 
  • Where we see only one value then this along with the other error SQL0003N indicate APAR IT22464.
    Search "pagekey"
     Line 160825:     Pagekey: {pool:11;obj:1789;type:1} PPNum:66789
     Line 167237:     Pagekey: {pool:11;obj:20098;type:1} PPNum:23457
     Line 167343:     Pagekey: {pool:11;obj:20098type:1} PPNum:13456
     Line 167450:     Pagekey: {pool:11;obj:20098;type:1} PPNum:12602

Read more...

Environment

Db2 LUW IBM 11.01.02

Product

SAP ERP 6.0

Keywords

corruption, alias, buffer, pool, , KBA , BC-DB-DB6-CCM , CCMS/Database Monitors for DB2 Universal Database , 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.