IBM Support

PH12917: SQLCODE = -104 MAY OCCUR IF COMMA IS USED AS DECIMAL POINT VALUEIN ZPARM

A fix is available

Subscribe

You can track all active APARs for this component.

 

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