IBM Support

IT32394: Db2 instance crash might be experienced due to an uninitialized prefetcher, when restoring to a new database in DPF environment.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Db2 instance crash might be experienced due to an uninitialized
    prefetcher queue, especially when restoring to a new database in
    DPF environment.
    
    In such DPF environment that has a large number
    of nodes, prefetcher size is incorrectly determined as 0 and
    results not initializing the prefetcher queue.
    
    Following statck will be dumped as part of the FODC_TRAP:
    
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x090000002C02C7F0
    IPRA.$sqlbpfAddToThisQ__FP12SQLB_pfQUEUEP9SQLB_BPCBPP14SQLB_pfRe
    questP12SQLB_GLOBALS + 0x3F0
    0x090000002C02BFF4
    sqlbpfAddToQ__FP12SQLB_GLOBALSPP14SQLB_pfRequest + 0x2F4
    0x090000002C277394
    sqlbDMSAddContainerRequest__FP12SQLB_POOL_CBP16SQLB_POOLCONT_CBP
    12SQLB_GLOBALSP14SQLB_pfParIoCbbUl + 0x834
    0x090000002DB05920
    sqlbDoDMSAddContainerRequests__FP12SQLB_POOL_CBP16SQLB_POOLCONT_
    CBUiP26SQLB_AS_CONT_AND_PATH_INFOP12SQLB_GLOBALS + 0x320
    0x090000002DB063F0
    sqlbDMSAddContainersToNewPool__FP12SQLB_POOL_CBiP16SQLB_POOLCONT
    _CBP12SQLB_GLOBALS + 0x530
    0x090000002C250FE0
    sqlbSetPoolCont__FP12SQLB_GLOBALSUiUsiP16SQLB_POOLCONT_CBbT6 +
    0x3800
    0x090000002EBF75B0
    IPRA.$sqlbRestorePoolContainers__FP12SQLB_GLOBALSi + 0xBD0
    0x090000002EBF4EA8
    sqlbRestoreContainers__FCP12SQLB_GLOBALSCP12SQLB_POOL_CBl +
    0x628
    0x090000002EBFDEA4
    sqlbRestorePoolDef__FP15SQLB_RESTORE_CBUsP20SQLB_POOL_CB_ON_DISK
    UiPib + 0x1C24
    0x090000002EBC9CFC
    sqludProcessSPCS__FP14SQLU_BUFMAN_CBPP24SQLUD_TABLESPACE_DETAILS
    + 0xE7C
    0x090000002EBBF7E4 sqludBMInit2__FP14SQLU_BUFMAN_CB + 0x2A4
    0x090000002EBBE644 sqludbuf__FPcUi + 0x584
    0x090000002A9A6200 sqloEDUEntry + 0x360
    </StackTrace>
    
    Below db2diag.log message will be logged that the prefetcher
    size is invalid:
    
    2020-02-19-16.15.33.465510-300 I7816A721            LEVEL:
    Warning
    PID     : 26214910             TID : 3600           PROC :
    db2sysc 31
    EDUID   : 3600                 EDUNAME:
    FUNCTION: DB2 UDB, buffer pool services,
    sqlbPFCalcNumPrefetchers, probe:40
    MESSAGE : ZRC=0xFFFFEBF6=-5130
              SQL5130N  The value specified for the configuration
    parameter "" is
              not in the valid range of "" to "".
    

Local fix

  • Manually configure the prefetcher size via DB2_PARALLEL_IO, or
    apply the fix.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to V11.1.4.6                                         *
    ****************************************************************
    

Problem conclusion

  • upgrade to V11.1.4.6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32394

  • 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

    2020-04-01

  • Closed date

    2022-07-10

  • Last modified date

    2022-07-10

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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"}]

Document Information

Modified date:
11 July 2022