IBM Support

IT22464: DB2DIAG.LOG FILLED WITH ERROR ON FUNCTION SQLBFINDPAGEINBPORSIMPROBE: 1952 SQL0003N THE DATABASE NAME IS NOT VALID

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After upgrading to DB2 11.1 FP2, error messages similar to the
    following can be seen:
    
    2017-09-17-01.27.19.467245+120 E3696412E3814         LEVEL:
    Error
    PID     : 10599                TID : 103
    PROC : db2sysc 0
    INSTANCE: db2inst1        NODE : 000
    DB   : DB1
    APPHDL  : 0-10               APPID: xx.xx.xx.xx
    AUTHID  : DB2INST1       HOSTNAME: localhost
    EDUID   : 714                 EDUNAME: db2agnts (DB1) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbFindPageInBPOrSim,
    probe:1952
    MESSAGE : ZRC=0x00000003=3
              SQL0003N  The database name is not valid.
              DIA8003C The interrupt  has been received.
    DATA #1 : String, 41 bytes
    Excessive retries while removing STMM BPD
    DATA #2 : unsigned integer, 4 bytes
    100
    DATA #3 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 112 bytes
        Pagekey: {pool:886;obj:4;type:0} PPNum:4485018
    .....
    
    This message is expected and can be ignored if there are no
    other symptoms. This message should not be logged as an Error.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 3 Fix Pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT22464

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-09-20

  • Closed date

    2018-03-19

  • Last modified date

    2018-03-19

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       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:
19 March 2018