IC88474: Load Remote Fetch might trap and crash DB2 instance during the INDEX COPY phase

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When loading from cursor with database option (Load Remote
    Fetch), if there is no DELETE phase, Load might trap and crash
    DB2 instance during the INDEX COPY phase.
    
    You can see the following errors from db2diag.log:
    
    2012-10-29-13.39.00.277586-300 I3210667A579       LEVEL: Error
    PID     : 18022488             TID  : 1           PROC :
    db2lueff
    INSTANCE: sample             NODE : 000
    APPID   : 157.146.32.89.45390.121029183900
    EDUID   : 1
    FUNCTION: DB2 UDB, database utilities, sqluffOpenOutputStream,
    probe:283
    MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid
    memory addr"
              DIA8561C A invalid memory block was encountered.
    DATA #1 : String, 0 bytes
    Object not dumped: Address: 0x0000000000000000 Size: 0 Reason:
    Address is NULL
    DATA #2 : File name, 13 bytes
    sqluueffApp.C
    
    2012-10-29-13.39.00.289921-300 I3211247A623       LEVEL: Error
    PID     : 18022488             TID  : 1           PROC :
    db2lueff
    INSTANCE: sample             NODE : 000
    APPID   : 157.146.32.89.45390.121029183900
    EDUID   : 1
    FUNCTION: DB2 UDB, database utilities, sqluffMain, probe:2321
    MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid
    memory addr"
              DIA8561C A invalid memory block was encountered.
    DATA #1 : String, 0 bytes
    Object not dumped: Address: 0x0000000000000000 Size: 0 Reason:
    Address is NULL
    DATA #2 : File name, 13 bytes
    sqluueffApp.C
    DATA #3 : String, 27 bytes
    Error opening output stream
    
    ... ...
    
    2012-10-29-13.39.00.291626-300 I3213616A504       LEVEL: Warning
    PID     : 44957714             TID  : 14253       PROC : db2sysc
    0
    INSTANCE: sample             NODE : 000         DB   : SAMPLE
    APPHDL  : 0-30372              APPID:
    *LOCAL.db2ppp1p.121029173618
    AUTHID  : SAMPLE
    EDUID   : 14253                EDUNAME: db2lurex 0
    FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
    DATA #1 : String, 83 bytes
    LOADID: 9112.2012-10-29-12.36.22.735144.0 (8;961)
    UserExitSA is done -2145779603, 0
    
    ... ...
    
    2012-10-29-13.39.00.298634-300 I3215719A775       LEVEL: Error
    PID     : 44957714             TID  : 14253       PROC : db2sysc
    0
    INSTANCE: sample             NODE : 000
    EDUID   : 14253                EDUNAME: db2lurex 0
    FUNCTION: DB2 UDB, database utilities,
    sqlusCUserExitSubAgent::iRun, probe:1394
    MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
              "SQLCA has already been built"
    DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes
    LOADID: 9112.2012-10-29-12.36.22.735144.0 (8;961)
    DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid :           sqlcabc: 0   sqlcode: -83   sqlerrml: 0
     sqlerrmc:
     sqlerrp : SQLUFFAP
     sqlerrd : (1) 0x8015006D      (2) 0x00000000      (3)
    0x00000000
               (4) 0x00000000      (5) 0x00000000      (6)
    0x00000000
     sqlwarn : (1)
    
    ... ...
    
    2012-10-29-13.39.20.618199-300 I3218219A514       LEVEL: Warning
    PID     : 44957714             TID  : 9112        PROC : db2sysc
    0
    INSTANCE: sample             NODE : 000         DB   : SAMPLE
    APPHDL  : 0-30372              APPID:
    *LOCAL.db2ppp1p.121029173618
    AUTHID  : SAMPLE
    EDUID   : 9112                 EDUNAME: db2agent (DB2PPP1P) 0
    FUNCTION: DB2 UDB, RAS/PD component,
    pdEDUIsInDB2KernelOperation, probe:600
    DATA #1 : String, 33 bytes
     bCleanUp__20sqluCMediaListServer
    DATA #2 : String, 4 bytes
    sqlu
    
    The stack trace looks like the following:
    
      sqluCMediaListServer::bCleanUp
      sqluCleanupUserExitPipes
      sqluCleanupUserExitCB
      sqluAppCbCleanup
      sqluCommitCallBack
      sqlrrcom_dps
      sqlrrcom
      sqlrr_commit
      sqluv_commit
      sqlu_register_table_load
      sqluvtld_route_in
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users using Load Remote Fetch with the INDEX COPY phase      *
    * might be affected.                                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 for LUW Version 10.1 Fixpack 3 or higher.     *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 for LUW Version 10.1 Fixpack 3.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC88474

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-21

  • Closed date

    2013-10-07

  • Last modified date

    2013-10-07

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

    IC88167

  • 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

  • RA10 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC88474

Modified date:

2013-10-07

Translate my page

Machine Translation

Content navigation