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

• 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

Db2 LUW IBM 11.01.02
Db2 LUW IBM 11.01.03

corruption, alias, buffer, pool, , KBA , BC-DB-DB6-CCM , CCMS/Database Monitors , Problem