IBM Support

IC98755: SEGV ENCOUNTERED DURING LOAD WHEN TABLE HAS MANY RANGE PARTITIONS DEFINED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Segv can be encountered while processing a load that is
    operating on a range partitioned table.  The segv can occur in
    both normal load processing, as well as during replay of load
    during crash recovery.
    
    Segv will only occur if there are greater than 1070 objects
    defined in the range partitioned table.
    
    The number of objects for a table varies depending on the
    definition of the range partitioned table.
    
    The multiplier can be determined by adding the following
    +1 for the base table
    +1 if there is at least one partitioned index defined
    +1 if the table includes long varchar columns
    +1 if the table uses organize by clause (MDC)
    +1 if the table includes XML columns
    +2 if the table includes LOB columns
    
    The number of objects is the multiplier times the number of
    ranges defined in the partition by range clause of the create
    table statement.
    
    When the segv is encountered, the db2diag.log will contain the
    following entry
    
    2014-01-14-00.15.30.468082+480 I37308E513          LEVEL:
    Warning
    PID     : 20695                TID  : 140736964060928PROC :
    db2sysc 0
    INSTANCE: db2inst1           NODE : 000          DB   : SAMPLE
    APPHDL  : 0-54                APPID: *N00.db2inst1.140113154903
    AUTHID  : DB2INST1
    EDUID   : 53                   EDUNAME: db2redom (HNDB) 42
    FUNCTION: DB2 UDB, RAS/PD component,
    pdEDUIsInDB2KernelOperation, probe:600
    DATA #1 : String, 35 bytes
     _Z30sqlu_process_pending_operation
    DATA #2 : String, 4 bytes
    sqlu
    
    The corresponding trap file will include this stack
    0        ossDumpStackTraceEx
    1        OSSTrapFile::dumpEx
    2        sqlo_trce
    3        sqloEDUCodeTrapHandler
    4        __PRETTY_FUNCTION__.6775
    5        memcpy
    6        _intel_fast_memcpy.A
    7        sqlu_process_pending_operation
    8        sqlptppl
    9        sqlpRFWppl
    10       sqlpRecDbRedo
    11       sqlprProcDPSrec
    12       sqlpPRecReadLog
    13       sqlpParallelRecovery
    14       sqleSubCoordProcessRequest
    15       sqeAgent::RunEDU
    16       sqzEDUObj::EDUDriver
    17       sqlzRunEDU
    18       sqloEDUEntry
    19       _L_mutex_lock_3503
    20       clone
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 10                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version 9.7 Fix Pack 10
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC98755

  • 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

    2014-01-15

  • Closed date

    2014-11-10

  • Last modified date

    2014-11-10

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

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

    IT03504 IT03506

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

Modified date: 10 November 2014