|
Problem IC77841
|
Status: Geschlossen |
SQLEMERGESQLCA() REPORTS INCORRECT NODE SENDING -1229 IF THE SENDING NODE CANNOT BE REACHED. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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: |
| Problem-Zusammenfassung: |
****************************************************************
* 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. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
Problem was first fixed in DB2 v9.7 FP5 version. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC78044
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 29.07.2011
25.12.2011
25.12.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.5
|
 |
