IBM Support

IT31384: IN PURESCALE UNNECESSARY SQLB_EAT_OBJ_TYPE_NOT_FOUND MESSAGES MAY BE WRITTEN INTO DB2DIAG.LOG

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Here are sample unnecessary messages in db2diag.log:
    -----
    2019-12-11-13.06.20.023441+540 I43865676A1384       LEVEL:
    Severe
      omit
    FUNCTION: DB2 UDB, buffer pool services, sqlbpfAddToQ, probe:821
    MESSAGE : ZRC=0x8002045A=-2147351462=SQLB_EAT_OBJ_TYPE_NOT_FOUND
              "Requested object type could not be found in the
    Extent Anchor Table for the table space."
    DATA #1 : String, 65 bytes
    Failed to setup the extent anchor table for this prefetch
    request
    DATA #2 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 104 bytes
      omit
    
    2019-12-11-13.06.20.024414+540 I43867061A1461       LEVEL:
    Severe
      omit
    FUNCTION: DB2 UDB, buffer pool services, sqlbServiceLeafRequest,
    probe:3791
    MESSAGE : ZRC=0x8002045A=-2147351462=SQLB_EAT_OBJ_TYPE_NOT_FOUND
              "Requested object type could not be found in the
    Extent Anchor Table for the table space."
    DATA #1 : String, 7 bytes
    req_ptr
    DATA #2 : Prefetcher SQLB_pfRequest structure,
    PD_TYPE_SQLB_PFREQUEST, 1000 bytes
      omit
    
    2018-11-08-23.20.20.658960-300 I5164711A7025        LEVEL:
    Warning
      omit
    FUNCTION: DB2 UDB, buffer pool services,
    sqlbLoadExtentAnchorFromObjTable, probe:1736
    MESSAGE : ZRC=0x8002045A=-2147351462=SQLB_EAT_OBJ_TYPE_NOT_FOUND
              "Requested object type could not be found in the
    Extent Anchor Table for the table space."
    DATA #1 : String, 98 bytes
    OT record skipped load into EAT due to one of the table's
    objects being in SQLD_OBJ_PARTIAL state.
    -----
    
    DB2DUMP and/or ALT_DB2DUMP will have the associated dump.bin
    files and may impact disk space.
    
    These messages may be written unexpectedly.  It can be ignored
    and the associated dump.bin files also can be deleted.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Db2 Version 11.1                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 Version 11.1 Mod 4 Fix Pack 6.                *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Db2 Version 11.1 Mod 4 Fix Pack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT31384

  • 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

    2019-12-25

  • Closed date

    2021-03-14

  • Last modified date

    2021-03-14

  • 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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022