IBM Support

LI74298: LOAD FAILURE IN DPF MAY LEAVE A TEMPFILE LOCKED, CAUSING SUBSEQUENT LOADS INTO SAME TABLE TO FAIL.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The Load utility, in DPF environment; when a Load PartSA
    (Partitioning Subagent) encounters an error creating a tcp
    socket (for example due to network unavailability), it may
    incorrectly leave this subagent's temporary load message file
    locked.  A subsequent Load into the same table will not be able
    to replace this file and will fail.
    
    Relevant db2diag.log entries include and error from
    sqloPdbConnectSocket, followed by errors from sqloclose.
    
    EDUID   : 217076               EDUNAME: db2agntp (FR1WKLYU) 1
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
    logging func, probe:0
    MESSAGE : LOADID: 199188.2009-02-12-16.10.38.677305.1 (13;8)
    sqloPdbConnectSocket
    DATA #1 : Hexdump, 488 bytes
    0x0000002B6EBFD490 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0000002B6EBFD4A0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    
    EDUID   : 217076               EDUNAME: db2lpart 1
    FUNCTION: DB2 UDB, oper system services, sqloclose, probe:10
    CALLED  : OS, -, fsync                            OSERR: EBADF
    (9)
    DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
    0x0000002B6EBFD908 : 9703 0000 8004 0000
    ........
    
    And subsequent Loads into this table will fail while opening the
    temporary message file.
    
    EDUID   : 217046               EDUNAME: db2agntp (FR1WKLYU) 1
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    DATA #1 : String, 187 bytes
    LOADID: 175991.2009-02-12-16.10.49.621149.1 (13;8)
    /var/ibmdb2/nyqxt070/db2back/load/tempfiles/DB20000D.PID/DB20000
    8.OID/load0001.part , 13, 0x8, Detected in file:sqlusPartSA.C,
    Line:1296
    

Local fix

  • Restart the instance
    

Problem summary

  • LOAD FAILURE IN DPF MAY LEAVE A TEMPFILE LOCKED, CAUSING
    SUBSEQUENT LOADS INTO SAME TABLE TO FAIL.
    

Problem conclusion

  • This APAR is first fixed in version 9.5 fixpack 5.
    

Temporary fix

  • Restart the instance
    

Comments

APAR Information

  • APAR number

    LI74298

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-03-23

  • Closed date

    2010-02-12

  • Last modified date

    2010-02-12

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

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

    LI74442 IC61630

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

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:
12 February 2010