19111 - Calling a DB2 stored procedure may cause an infinite loop under some circumstances or it might retrieve the wrong data

Problem Note 19111: Calling a DB2 stored procedure may cause an infinite loop under some circumstances or it might retrieve the wrong data

Calling a DB2 stored procedure on z/OS might result in an infinite loop requiring that the job be cancelled. This seems to occur when there are parameters that are of a decimal data type but that alone does not cause the infinite loop. It appears to be a result of the number of parameters. There is no current workaround for this issue.

Also, if a schema is not specified during the call to a stored procedure, there is a risk that a SELECT statement that the code executes against SYSIBM.SYSPARMS might retrieve the wrong data. The only workaround is to add the schema to the stored procedure call.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS/ACCESS Interface to DB2	z/OS	9.1 TS1M0	9.2 TS1M0

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#019111

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#019111

Type:	Problem Note
Priority:	high
Topic:	SAS Reference ==> LIBNAME Engines Data Management ==> Data Sources ==> External Databases ==> DB2

Date Modified:	2007-01-22 16:54:45
Date Created:	2006-12-06 13:05:30