IBM Support

IC99746: FORCE APPLICATION OF LOAD FROM CURSOR MIGHT CAUSE LOAD TO HANG

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Load from cursor might hang when the following conditions are
    met:
    
    -- Large UTIL_HEAP_SZ (database parameter) and/or DATA BUFFER
    (load parameter) are set.
    -- Large CPU_PARALLELISM and/or DISK_PARALLELISM are specified
    explicitly or implicitly.
    -- Load a large amount of data from cursor into target table.
    -- Load is forced/interrupted during loading data.
    
    Coordinator agent will have stack below waiting for all LOAD
    EDU's to finish clean up:
    
    __nanosleep
    ossSleep
    sqlorest
    sqlulTermEDU
    sqluvload
    sqluLoadPartition
    sqlu_register_table_load
    
    while all the LOAD EDUs are blocked by "msgsnd()" when sending
    feedback to the agent:
    
    msgsnd
    sqlowqueInternal
    sqlowque
    sqluWriteQueue
    sqluCleanupAndSendFinalMessage
    
    
    Error in db2diag.log:
    ================================================================
    =======================
    2014-01-03-08.06.22.609542-360 I15909E459          LEVEL: Severe
    PID     : 5428                 TID  : 47687680387392PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
    APPHDL  : 0-19705              APPID:
    192.95.202.157.53762.1401031024
    AUTHID  : DB2INST1
    EDUID   : 62617                EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrrbck, probe:150
    MESSAGE : SQLEU_STATE2_LOAD_ROLLBACK_PENDING state is set
    
    2014-01-03-08.06.22.609822-360 I16369E552          LEVEL: Error
    PID     : 5428                 TID  : 47687680387392PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
    APPHDL  : 0-19705              APPID:
    192.95.202.157.53762.1401031024
    AUTHID  : DB2INST1
    EDUID   : 62617                EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    DATA #1 : String, 123 bytes
    LOADID: 62617.2014-01-03-04.24.33.946350.0 (4;9)
     , -1224, 0xffffffff8012006d, Detected in file:sqlulxld_fetch.C,
    Line:1122
    

Local fix

  • Possible workarounds
    -- Increase kernel parameter value msgmnb limit to
    262144
    -- Reduce UTIL_HEAP_SZ and/or DATA BUFFER.
    -- Reduce CPU_PARALLELISM and/or DISK_PARALLELISM.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V10.5 Fix Pack 4                                  *
    ****************************************************************
    

Problem conclusion

  • Upgrade to V10.5 Fix Pack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC99746

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-02-28

  • Closed date

    2014-09-17

  • Last modified date

    2014-09-17

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

    IC99287

  • 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

  • RA50 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 10.5

Reference #: IC99746

Modified date: 17 September 2014