A fix is available
APAR status
Closed as program error.
Error description
ANLPTEX returns SQL error -514 during closing cursor
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users processing TEST of packages for * * updated access paths * **************************************************************** * PROBLEM DESCRIPTION: While performing the TEST function * * ANLPTEX returns SQL error -514 when * * closing cursor * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** While performing the TEST function ANLPTEX returns SQL error -514 when closing cursor
Problem conclusion
Code logic was corrected to fix the issues described
Temporary fix
Comments
APAR Information
APAR number
PH38853
Reported component name
DB2 SQL PERF AN
Reported component ID
5697F5701
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-07-09
Closed date
2021-08-27
Last modified date
2021-09-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ANLBATCH ANLBIND ANLBNDGR ANLCAT ANLCMIG1 ANLCSTA1 ANLJCRE8 ANLPAPPL ANLPCOLL ANLPCRE8 ANLPJCL ANLPTEX ANLWLMSP
Fix information
Fixed component name
DB2 SQL PERF AN
Fixed component ID
5697F5701
Applicable component levels
R510 PSY UI76944
UP21/08/31 P F108
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0"}]
Document Information
Modified date:
02 September 2021