|
Problem IC79065
|
Status: Geschlossen |
TRAP: DB2 CLP CAN TRAP WHEN CALLING A STORED PROCEDURE THAT RESIDES ON Z/OS AND WHEN -433 ERROR IS RETURNED |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
When the following repro script is executed on a z/os:
db2 uncatalog node v33cc38
db2 uncatalog db STLEC1
db2 uncatalog DCS db v33cc38
db2 catalog tcpip node v33cc38 remote TOREC48.vmec.svl.ibm.com
server 446 ostype mvs
db2 catalog dcs database v33cc38 as STLEC1
db2 catalog database v33cc38 as v33cc38 at node v33cc38
authentication DCS
db2 connect to v33cc38 user newton using t3amri0t
CREATE PROCEDURE msdb2.test_char(in p1 char(3), out o1 char(3))
LANGUAGE SQL
BEGIN
select 'XXX' into o1 from sysibm.sysdummy1;
END
db2 "call msdb2.test_char('XXXX',?)"
clp traps with the below stack trace:
Stack #1 Signal #11 Timestamp
2011-09-20-02.27.52.897294
0 ossDumpStackTraceEx
1 OSSTrapFile::dumpEx
2 sqlo_trce
3 clp_bp_sigterm
4 __restore_rt
5 strstr
6 clp_extract_data_from_call
7 clp_handle_check
8 clpbp_exe_sqlecall
9 clpbp_exe_sqleproc
10 clp_bp_con
11 main
12 __libc_start_main
13 USE_SSE2 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* CLP users connected to Z/OS *
****************************************************************
* PROBLEM DESCRIPTION: *
* CLP may trap when displaying the error message when a stored *
* procedure call on z/os returns -433 error. *
****************************************************************
* RECOMMENDATION: *
* upgrade to v97fp6 or later versions *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
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 |
Fixed |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 05.10.2011
05.06.2012
05.06.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP6
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.6
|
 |
