IC95932: LOAD MIGHT HANG IF INPUT DATA HAS LARGE CORRUPTED SECTION

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The problem rarely occurs and only affects Load with DEL or ASC
    files. Load might hang if input data has large corrupted
    section, e.g. 100MB of 0x0 accidentally appended to one row.
    
    When the Load hang occurs, you can observe the following stacks:
    
    Load Media Reader (db2lmr) is stuck on:
    
    select
    sqlorqueInternal
    sqlorque2
    sqluReadBufferFromQueue
    sqluMCContinueRestore
    sqluMCProcessRestoreStates
    sqluMCStartRestoreMediaController
    iRun_sqluCMediaReader
    
    Load Formatters (db2lfrmX) are stuck on:
    
    sqloWaitEDUWaitPost
    sqloSyncUp
    sqluRiddifyRecords
    sqluGetAndFormatRecords
    iRun_sqluCFormatter
    
    or
    
    msgrcv
    sqlorqueInternal
    sqlorque2
    sqlulGetBuff
    sqlulcgf (DEL) or sqlulagr (ASC)
    sqlulcrr (DEL) or sqlularr (ASC)
    sqluGetAndFormatRecords
    iRun_sqluCFormatter
    

Local fix

  • Fix the corrupted input data and load again, or try either of
    the following workarounds:
    - Specify the CPU_PARALLELISM 1 parameter for Load;
    - Specify the "ANYORDER" file modifier for Load.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Version 9.7 FixPack 9                             *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.7 FixPack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC95932

  • 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

    2013-09-13

  • Closed date

    2013-12-23

  • Last modified date

    2013-12-23

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

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

    IC95992 IC97045 IC97064

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 #:

IC95932

Modified date:

2013-12-23

Translate my page

Machine Translation

Content navigation