SUPPORT / SAMPLES & SAS NOTES
 

Support

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

DetailsHotfixAboutRate It

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 FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to DB2z/OS9.1 TS1M09.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.