IBM Support

IC77841: SQLEMERGESQLCA() REPORTS INCORRECT NODE SENDING -1229 IF THE SENDING NODE CANNOT BE REACHED.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The sqleMergeSqlca() ambiguously reports the node affected when
    reporting -1229 error because the node affected cannot be
    reached.  In these cases the node reported is itself.
    
    Looking at the db2diag.log, it is implied that "node number 0"
    is the node where sqlcode -1229 is coming from.
    
    2011-07-25-16.25.54.728351-240 I115019723A467     LEVEL: Severe
    PID     : 12517520             TID  : 491852      PROC : db2sysc
    0
    INSTANCE: xxxxxx               NODE : 000         DB   : xxx
    APPHDL  : 0-36843              APPID: *N0.db2bp1.xxxxxxxxxxxx
    AUTHID  : xxxxxx
    EDUID   : 491852               EDUNAME: db2agent (xxx) 0
    FUNCTION: DB2 UDB, base sys utilities, sqleMergeSqlca, probe:20
    MESSAGE : Received sqlcode -1229 for request 80000017 from node
    number 0
    
    However, in this case, node 11 is the one having troubles.  Node
    11 is not sending -1229 because it cannot be reached.
    SqleMergeSqlca() is reporting node 0 as the one sending -1229
    but sqlca (sqlerrd 6th parameter) reports that -1229 came from
    node 11 (0xB).  Node 11 is the node that should have been
    reported by SqleMergeSqlca() as sending -1229.
    
    
    2011-07-25-16.25.54.744499-240 I115020191A834     LEVEL: Severe
    PID     : 12517520             TID  : 491852      PROC : db2sysc
    0
    INSTANCE: xxxxxx               NODE : 000         DB   : xxx
    APPHDL  : 0-36843              APPID: *N0.db2bp1.xxxxxxxxxxxx
    AUTHID  : xxxxxx
    EDUID   : 491852               EDUNAME: db2agent (xxx) 0
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
    logging func, probe:0
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -1229   sqlerrml: 0
     sqlerrmc:
     sqlerrp : SQL09072
     sqlerrd : (1) 0x00000000      (2) 0x00000000      (3)
    0x00000000
               (4) 0x00000000      (5) 0x00000000      (6)
    0x0000000B
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL DPF users.                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The sqleMergeSqlca() ambiguously reports the node affected   *
    * when                                                         *
    * reporting -1229 error because the node affected cannot be    *
    *                                                              *
    * reached.  In these cases the node reported is itself.        *
    *                                                              *
    *                                                              *
    *                                                              *
    * Looking at the db2diag.log, it is implied that "node number  *
    * 0"                                                           *
    * is the node where sqlcode -1229 is coming from.              *
    *                                                              *
    *                                                              *
    *                                                              *
    * 2011-07-25-16.25.54.728351-240 I115019723A467     LEVEL:     *
    * Severe                                                       *
    * PID     : 12517520             TID  : 491852      PROC :     *
    * db2sysc                                                      *
    * 0                                                            *
    *                                                              *
    * INSTANCE: xxxxxx               NODE : 000         DB   : xxx *
    *                                                              *
    * APPHDL  : 0-36843              APPID:                        *
    * *N0.db2bp1.xxxxxxxxxxxx                                      *
    * AUTHID  : xxxxxx                                             *
    *                                                              *
    * EDUID   : 491852               EDUNAME: db2agent (xxx) 0     *
    *                                                              *
    * FUNCTION: DB2 UDB, base sys utilities, sqleMergeSqlca,       *
    * probe:20                                                     *
    * MESSAGE : Received sqlcode -1229 for request 80000017 from   *
    * node                                                         *
    * number 0                                                     *
    *                                                              *
    *                                                              *
    *                                                              *
    * However, in this case, node 11 is the one having troubles.   *
    * Node                                                         *
    * 11 is not sending -1229 because it cannot be reached.        *
    *                                                              *
    * SqleMergeSqlca() is reporting node 0 as the one sending      *
    * -1229                                                        *
    * but sqlca (sqlerrd 6th parameter) reports that -1229 came    *
    * from                                                         *
    * node 11 (0xB).  Node 11 is the node that should have been    *
    *                                                              *
    * reported by SqleMergeSqlca() as sending -1229.               *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    * 2011-07-25-16.25.54.744499-240 I115020191A834     LEVEL:     *
    * Severe                                                       *
    * PID     : 12517520             TID  : 491852      PROC :     *
    * db2sysc                                                      *
    * 0                                                            *
    *                                                              *
    * INSTANCE: xxxxxx               NODE : 000         DB   : xxx *
    *                                                              *
    * APPHDL  : 0-36843              APPID:                        *
    * *N0.db2bp1.xxxxxxxxxxxx                                      *
    * AUTHID  : xxxxxx                                             *
    *                                                              *
    * EDUID   : 491852               EDUNAME: db2agent (xxx) 0     *
    *                                                              *
    * FUNCTION: DB2 UDB, trace services, sqlt_logerr_data          *
    * (secondary                                                   *
    * logging func, probe:0                                        *
    *                                                              *
    * DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes                *
    *                                                              *
    *  sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -1229           *
    * sqlerrml: 0                                                  *
    *  sqlerrmc:                                                   *
    *                                                              *
    *  sqlerrp : SQL09072                                          *
    *                                                              *
    *  sqlerrd : (1) 0x00000000      (2) 0x00000000      (3)       *
    *                                                              *
    * 0x00000000                                                   *
    *                                                              *
    *            (4) 0x00000000      (5) 0x00000000      (6)       *
    *                                                              *
    * 0x0000000B                                                   *
    *                                                              *
    *  sqlwarn : (1)      (2)      (3)      (4)        (5)         *
    * (6)                                                          *
    *            (7)      (8)      (9)      (10)        (11)       *
    *                                                              *
    *  sqlstate:                                                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 9.7 FP5.                                      *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 v9.7 FP5 version.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77841

  • 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

    2011-07-29

  • Closed date

    2011-12-25

  • Last modified date

    2011-12-25

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

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

    IC78044

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSN

       UP

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC77841

Modified date: 25 December 2011