DB2 FOR LUW / DB2FORLUW / 970 - DB2

Users affected: 
Programs that run on VSE and connect to a DB2 LUW 
(DB2 for Linux, UNIX and Windows) database and call a stored 
procedure. 
 
 
Problem Description: 
No rows are returned to a client program on VSE 
when it calls a stored procedure in a DB2 LUW server 
that opens a cursor that is declared using the 
WITH RETURN TO CLIENT clause. 
 
After the stored procedure returns no rows, SQLSTATE is set to 
02000, and SQLCODE is set to SQL0100W or SQL0231W. 
 
Here is an example of such a stored procedure. 
 
 CREATE PROCEDURE PROCEDURE1( ) 
 P1: BEGIN 
     DECLARE cursor1 CURSOR WITH RETURN TO CLIENT FOR 
         SELECT cast(PROCSCHEMA as char(8)) FROM 
          SYSCAT.PROCEDURES; 
     OPEN cursor1; 
 END P1 
 
 
Problem Summary: 
This problem only happens when you use a version of DB2 LUW that 
contains the change described by APAR LI72598. 
The APAR LI72598 change was introduced in DB2 LUW 9.5 fixpak 4 
to improve performance for DB2 version 7 on zOS clients. 
This APAR fix keeps the performance improvement for DB2 
version 7 on zOS clients that was effected by the APAR LI72598 
change.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Programs that run on VSE and connect to a DB2 LUW (DB2 for   * 
* Linux, UNIX and Windows) database and call a stored          * 
* procedure.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* .                                                            * 
****************************************************************

The stored procedure returns the correct result if the cursor is 
declared as WITH RETURN TO CALLER instead of 
WITH RETURN TO CLIENT.

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 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 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in Version 9.7 Fix Pack 2

The stored procedure returns the correct result if the cursor is 
declared as WITH RETURN TO CALLER instead of WITH RETURN TO 
CLIENT.

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

07.12.2009
25.01.2011
25.01.2011

9.7.FP2