A fix is available
APAR status
Closed as program error.
Error description
SQLCODE = -104 may occur if comma is used as decimal point value in ZPARM.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: IBM Db2 SQL Performance Analyzer * * users of component : * * - Basic DB2 SQL PA Processing * * Process SQL statements from various sources * **************************************************************** * PROBLEM DESCRIPTION: SQLCODE=-104 may occur if comma is used * * as decimal point value in ZPARM * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** SQLCODE=-104 may occur if comma is used as decimal point value in ZPARM during perform of processing SQL statements from various sources in Db2 SQL Performance Analyzer .
Problem conclusion
Code logic was corrected to fix the issue described. Search Keywords: SQLCODE -104
Temporary fix
Comments
APAR Information
APAR number
PH12917
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
2019-06-04
Closed date
2019-06-26
Last modified date
2019-07-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI63874
Modules/Macros
ANLEEE ANLMAIN ANLPIDD ANLPTSM ANLSQLPA ANLTSO ANLWIF
Fix information
Fixed component name
DB2 SQL PERF AN
Fixed component ID
5697F5701
Applicable component levels
R510 PSY UI63874
UP19/06/28 P F906
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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"5.1.0"}]
Document Information
Modified date:
04 January 2021