IBM Support

LI74450: LOAD WITH CLIENT OPTION (OR CLI LOAD) THAT IS INTERRUPTED MAY TRAP WITH SQLODIAGNOSEFREEBLOCKFAILURE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • When the Load utility is invoked from a remotely connected
    client and the CLIENT option is specified (meaning data is being
    retrieved from the client), or the CLI Load interface is used,
    if the utility is interrupted or fails, it's possible in some
    timing situations that the Load Agent process drives a rollback
    and free's resources before all of it's child processes have
    exited, causing the Load to trap with errors such as this:
    
    2009-04-07-15.32.51.513504-240 I4089969E2013       LEVEL: Severe
    PID     : 12699                TID  : 208729532768 PROC :
    db2sysc 0
    INSTANCE: xxx             NODE : 000          DB   :xxx
    
    APPHDL  : 0-38628              APPID:P00000.D289.004E97180854
    AUTHID  : Kxxxx
    EDUID   : 3479                 EDUNAME: db2lfrm0 0
    FUNCTION: DB2 UDB, SQO Memory Management,
    sqloDiagnoseFreeBlockFailure, probe:60
    MESSAGE : The associated pool has already been freed.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of DB2 9.5 fp 5 or less                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Interrupted load with client option (or CLI load) may trap,  *
    * showing sqloDiagnoseFreeBlockFailure in diaglog              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.5 fix pack 5 or later               *
    ****************************************************************
    

Problem conclusion

  • First Fixed in V9.5 Fix pack 5
    

Temporary fix

Comments

  • SEE APAR LI74451 for v91 equivalent.
    

APAR Information

  • APAR number

    LI74450

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-04-21

  • Closed date

    2010-03-03

  • Last modified date

    2010-08-11

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

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

    LI74451 IC63646

Fix information

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
11 August 2010