IBM Support

JR32310: LOAD FROM CURSOR OR CLIENT OR CLI LOAD ENCOUNTERS 'UNEXPECTED CHILD PID' ERROR AND FAILS WITH SQL2044N

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Description:
    The Load utility, when either invoked with the CLIENT keyword,
    or from CURSOR datatype, or when using CLI Load,  may fail with
    an SQL2044n in rare timing scenarios with a message in the
    db2diag.log that states 'unexpected Child PID' followed by a
    messages that states 'Child's message: , 22'.
    
    2009-02-23-02.44.37.562000+540 I5206472H553       LEVEL: Error
    PID     : 3056                 TID  : 4216        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : ENET
    APPHDL  : 0-389                APPID: *LOCAL.DB2.090222174434
    AUTHID  : ENET01
    EDUID   : 4216                 EDUNAME: db2agent (ENET)
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    DATA #1 : String, 124 bytes
    LOADID: 4216.2009-02-23-02.44.35.203000.0 (3;158)
    unexpected Child PID. , 0, 000015A0, Detected in file:sqluvld.C,
    Line:4286
    
    2009-02-23-02.44.37.562000+540 I5207027H549       LEVEL: Error
    PID     : 3056                 TID  : 4216        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : ENET
    APPHDL  : 0-389                APPID: *LOCAL.DB2.090222174434
    AUTHID  : ENET01
    EDUID   : 4216                 EDUNAME: db2agent (ENET)
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    DATA #1 : String, 120 bytes
    LOADID: 4216.2009-02-23-02.44.35.203000.0 (3;158)
    Child's message: , 22, 00000000, Detected in file:sqluvld.C,
    Line:4287
    
    This is caused by an oversight in the handshake protocol used
    by the db2agent servicing the Load when collecting messages from
    all the Load EDUs.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Use the load with the CLIENT keyword, or from CURSOR         *
    * datatype, or when using CLI Load                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The Load utility, when either invoked with the CLIENT        *
    * keyword,                                                     *
    * or from CURSOR datatype, or when using CLI Load, may fail    *
    * with                                                         *
    * an SQL2044n in rare timing scenarios with a message in the   *
    * db2diag.log that states 'unexpected Child PID' followed by a *
    *                                                              *
    * messages that states 'Child's message: , 22'.                *
    *                                                              *
    * 2009-02-23-02.44.37.562000+540 I5206472H553 LEVEL: Error     *
    * PID : 3056 TID : 4216 PROC :                                 *
    * db2syscs.exe                                                 *
    * INSTANCE: DB2 NODE : 000 DB : ENET                           *
    * APPHDL : 0-389 APPID: *LOCAL.DB2.090222174434                *
    * AUTHID : ENET01                                              *
    * EDUID : 4216 EDUNAME: db2agent (ENET)                        *
    * FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0   *
    * DATA #1 : String, 124 bytes                                  *
    * LOADID: 4216.2009-02-23-02.44.35.203000.0 (3;158)            *
    * unexpected Child PID. , 0, 000015A0, Detected in             *
    * file:sqluvld.C,                                              *
    * Line:4286                                                    *
    *                                                              *
    * 2009-02-23-02.44.37.562000+540 I5207027H549 LEVEL: Error     *
    * PID : 3056 TID : 4216 PROC :                                 *
    * db2syscs.exe                                                 *
    * INSTANCE: DB2 NODE : 000 DB : ENET                           *
    * APPHDL : 0-389 APPID: *LOCAL.DB2.090222174434                *
    * AUTHID : ENET01                                              *
    * EDUID : 4216 EDUNAME: db2agent (ENET)                        *
    * FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0   *
    * DATA #1 : String, 120 bytes                                  *
    * LOADID: 4216.2009-02-23-02.44.35.203000.0 (3;158)            *
    * Child's message: , 22, 00000000, Detected in file:sqluvld.C, *
    *                                                              *
    * Line:4287                                                    *
    *                                                              *
    * This is caused by an oversight in the handshake protocol     *
    * used                                                         *
    * by the db2agent servicing the Load when collecting messages  *
    * from                                                         *
    * all the Load EDUs.                                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version V9.5 Fix Pack 5.                      *
    ****************************************************************
    

Problem conclusion

  • Problem is first fixed in DB2 Version V9.5 Fix Pack 5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32310

  • Reported component name

    DB2 UDB WSE WIN

  • Reported component ID

    5765F3501

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-03-11

  • Closed date

    2010-01-13

  • Last modified date

    2010-01-13

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

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

    JR32311

Fix information

  • Fixed component name

    DB2 UDB WSE WIN

  • Fixed component ID

    5765F3501

Applicable component levels

  • R950 PSN

       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:
13 January 2010