|
Problem IC79065
|
Status: Closed |
TRAP: DB2 CLP CAN TRAP WHEN CALLING A STORED PROCEDURE THAT RESIDES ON Z/OS AND WHEN -433 ERROR IS RETURNED |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
Fixed |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.10.2011
05.06.2012
05.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
