A fix is available
APAR status
Closed as program error.
Error description
CICS IA 5.2 CIUDBCP1 job fails with SQLCODE -401 while trying to create stored procedure CIUSPTSR due to PTF UI20622(APAR PI19804) which can not be applied in customer's DB2 system.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: CICS Interdependency Analyzer V520 users who * * wish to exploit CIUSPTSR stored procedure * * in DB2 V11. But PTF UI20622(APAR PI19804) * * can not be applied in customer's DB2 V11 * * system. * **************************************************************** * PROBLEM DESCRIPTION: SQLCODE -401 or unexpected ABEND0C4 or * * ABEND04E occurs for a CREATE PROCEDURE * * CIUSPTSR statement because this * * procedure contains control statements * * with an IN-LIST predicate which * * references SQL variables. * **************************************************************** * RECOMMENDATION: Apply the PTF and perform the HOLD ACTION * * items. * **************************************************************** If PTF UI20622(APAR PI19804) is not applied in customer's DB2 V11 system, DB2 does not process the SQL variables in the IN-LIST predicate properly which can result in the incorrect SQLCODE or unexpected ABEND.
Problem conclusion
All IN-LIST predicates have been changed to IF (...) statements in the CIUSPTSR stored procedure to avoid the incorrect SQLCODE or unexpected ABEND.
Temporary fix
Comments
APAR Information
APAR number
PI67651
Reported component name
CICS IA V5
Reported component ID
5655Y2200
Reported release
520
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-08-16
Closed date
2016-09-23
Last modified date
2016-10-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI41067
Modules/Macros
CIUSNTSR
Fix information
Fixed component name
CICS IA V5
Fixed component ID
5655Y2200
Applicable component levels
R520 PSY UI41067
UP16/09/30 P F609
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSPPUS","label":"CICS Interdependency Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 October 2016