IBM Support

IC63280: LOAD HANGS WITH ALL LOAD FORMATTERS(DB2LFRM) WAITING FOR SYNCUP OR TRANSFER BUFFER.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • This problem with LOAD hanging is rarely hit, and it only
    affects LOAD using DEL files or ASC files (i.e. it does not
    affect other LOAD input types like IXF files, LOAD from CURSOR,
    etc.)  The trigger is when customer's input data has very long
    records.
    
    This problem could be identified by checking the stack
    trace(call stack) of "load formatters (db2lfrmX)" and "load
    media reader (db2lmr)".
    
    "load media reader (db2lmr)" are stuck on stack trace like this:
    
    select
    sqlorqueInternal
    sqlorque2
    sqluReadBufferFromQueue
    sqluMCContinueRestore
    sqluMCProcessRestoreStates
    sqluMCStartRestoreMediaController
    sqloCreateEDU
    ......
    
    
    "load formatters (db2lfrmX)" are stuck on either stack trace:
    
    sqloWaitEDUWaitPost
    sqloSyncUp
    sqluRiddifyRecords
    sqluGetAndFormatRecords
    sqluldat
    sqloCreateEDU
    ......
    
    or:
    
    msgrcv
    sqlorqueInternal
    sqlorque2
    sqlulGetBuff
    sqlulcgf (for DEL file) or  sqlulagr (for ASC file)
    sqlulcrr (for DEL file) or  sqlularr (for ASC file)
    sqluGetAndFormatRecords
    sqluldat
    sqloCreateEDU
    ......
    

Local fix

  • 1. Specify "CPU_PARALLELISM 1" in LOAD command; or
    2. Specify "ANYORDER" option in LOAD command; or
    3. Increase the amount of load buffer either explicitly via DATA
    BUFFER option or implicitly via increasing UTIL_HEAP_SZ
    database configuration parameter.  (This will work around
    a specific problem instance, but it is possible to hit a
    different load hang with the new load buffer value.)
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of version 9.7 on Linux, Unix and Windows          *
    * platforms.                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * This problem is rarely hit and only affects LOAD using DEL   *
    * files or ASC files(i.e. does not affect other LOAD input     *
    * types like IXF files, LOAD from CURSOR etc.)                 *
    * The trigger is when customer's input data has very long      *
    * records.                                                     *
    *                                                              *
    * This problem could be identified by checking the stack       *
    * trace(call stack) of "load formatters(db2lfrmX)" and "load   *
    * media reader(db2lmr)".                                       *
    *                                                              *
    * "load media reader(db2lmr)" are stuck on stack trace like    *
    * this:                                                        *
    *   select                                                     *
    *   sqlorqueInternal                                           *
    *   sqlorque2                                                  *
    *   sqluReadBufferFromQueue                                    *
    *   sqluMCContinueRestore                                      *
    *   sqluMCProcessRestoreStates                                 *
    *   sqluMCStartRestoreMediaController                          *
    *   sqloCreateEDU                                              *
    *   ......                                                     *
    *                                                              *
    * "load formatters(db2lfrmX)" are stuck on either stack trace: *
    *   sqloWaitEDUWaitPost                                        *
    *   sqloSyncUp                                                 *
    *   sqluRiddifyRecords                                         *
    *   sqluGetAndFormatRecords                                    *
    *   sqluldat                                                   *
    *   sqloCreateEDU                                              *
    *   ......                                                     *
    * or:                                                          *
    *   msgrcv                                                     *
    *   sqlorqueInternal                                           *
    *   sqlorque2                                                  *
    *   sqlulGetBuff                                               *
    *   sqlulcgf (for DEL file) or  sqlulagr (for ASC file)        *
    *   sqlulcrr (for DEL file) or  sqlularr (for ASC file)        *
    *   sqluGetAndFormatRecords                                    *
    *   sqluldat                                                   *
    *   sqloCreateEDU                                              *
    *   ......                                                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to DB2 LUW Version 9.7 Fix Pack 6 or higher levels.   *
    ****************************************************************
    

Problem conclusion

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

Temporary fix

  • 1. Specify "CPU_PARALLELISM 1" in LOAD command; or
    2. Specify "ANYORDER" option in LOAD command; or
    3. Increase the amount of load buffer either explicitly via DATA
    BUFFER option or implicitly via increasing UTIL_HEAP_SZ database
    configuration parameter.(This will work around a specific
    problem instance, but it is possible to hit a different load
    hang with the new load buffer value.)
    

Comments

APAR Information

  • APAR number

    IC63280

  • 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

    2009-09-20

  • Closed date

    2012-06-05

  • Last modified date

    2012-06-05

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

    IZ60800

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

    IC84863

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC63280

Modified date: 05 June 2012