IC87149: LOAD COMMAND MIGHT HANG WHEN LOADING DATA INTO DATA PARTITIONED TABLES OR MDC TABLES

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The problem only happens to data partitioned tables and MDC
    tables.
    
    When it happens, the LOAD command appears to hang in LOAD phase.
    In snapshot the application is stuck in "Performing a Load"
    status.
    
    After 'db2pd -stack all' command is performed, the following
    stack traces can be seen in stack files:
    
    +++++ Load coordinator agent if DPF +++++
    ===========================================
    _p_nsleep
    nsleep
    nanosleep
    ossSleep
    sqlorest
    iFinalSyncUp_sqlusCLoadMPPCoordinator
    iCoordinateSAs_sqlusCLoadMPPCoordinator
    sqlu_register_table_load
    iRun_sqlusCLoadMPPCoordinator
    sqlu_register_table_load_MPP
    sqluvtld_route_in
    ===========================================
    
    +++++ db2lload subagent if DPF or Load agent if EE +++++
    ===========================================
    select
    sqlorqueInternal
    sqlorque2
    sqlulReadQ
    sqlulPollMsg
    sqluvload
    call_sqluvload
    sqluLoadPartition
    iRun_sqlusCLoadSubAgent
    ===========================================
    
    +++++ db2lfrmX +++++
    ===========================================
    msgrcv
    sqlorqueInternal
    sqlorque2
    squFetchNewRecListBuf
    sqluGetNewRecordStruct
    sqluFormatDMRec
    sqluGetAndFormatRecords
    iRun_sqluCFormatter
    
    If there is only one formatter (i.e. db2lfrm0), then the stack
    of db2lfrm0 might be as below or almost the same as the stack of
    db2lrid.
    
    thread_wait
    sqloWaitEDUWaitPost
    sqloSyncUp
    sqluFlushRidderData
    iRun_sqluCFormatter
    ===========================================
    
    +++++ db2lrid +++++
    ===========================================
    msgrcv
    sqlorqueInternal
    sqlorque2
    squGetMsgFromEQ2
    sqlulGetBuff
    sqlulNextPage
    sqluCreateAndInitPage
    sqlulGetRID
    sqluAssignRIDsToDMRecList
    sqluRiddifierProcOneSubList
    sqluRiddifierProcessRecList
    sqluMDCRPProcessAnyCachedLists
    sqluGetDMRecLists
    iRun_sqluCRidder
    ===========================================
    
    +++++ db2lbm +++++
    ===========================================
    _p_nsleep
    nsleep
    nanosleep
    ossSleep
    sqlorest
    sqlulBMGetNextBuffer
    sqluGetMoreDataForBM
    sqlulBMCont
    iRun_sqluCBufferManipulator
    ===========================================
    

Local fix

  • Increasing the size of data buffer (by specifying a large value
    for DATA BUFFER option in LOAD command, such as 50000 or larger)
    sometimes can solve the problem.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of version 9.7 on Linux, Unix and Windows          *
    * platforms.                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to DB2 LUW Version 9.7 Fix Pack 8 or higher levels.   *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 LUW Version 9.7 Fix Pack 8.
    

Temporary fix

  • Increasing the size of data buffer (by specifying a large value
    for DATA BUFFER option in LOAD command, such as 50000 or larger)
    sometimes can solve the problem.
    

Comments

APAR Information

  • APAR number

    IC87149

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-10

  • Closed date

    2013-04-08

  • Last modified date

    2013-04-08

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

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

    IC88134

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC87149

Modified date:

2013-04-08

Translate my page

Machine Translation

Content navigation