IBM Support

PH58394: POSSIBLE INCORRECT RESULT OF FAST APPLY EXECUTION WHEN DEALING WITH FLOAT VALUES

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Possible incorrect execution of the SQL containing FLOAT numbers
    when using Fast Apply SQL executor.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Log Analysis Tool for z/OS      *
    ****************************************************************
    * PROBLEM DESCRIPTION: Possible incorrect execution of         *
    *                      the SQL containing FLOAT numbers when   *
    *                      using Fast Apply SQL executor.          *
    *                      This APAR corrects this situation.      *
    *                                                              *
    *                      This is a PE fixer for PTF UI94156.     *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    Possible incorrect result of Fast Apply execution when dealing
    with FLOAT values
    

Problem conclusion

  • Apply the PTF
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH58394

  • Reported component name

    DB2 LOG ANALYSI

  • Reported component ID

    5655E6601

  • Reported release

    350

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2023-11-27

  • Closed date

    2023-12-01

  • Last modified date

    2024-01-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    PH58467 UI94653

Modules/Macros

  • ALA#CMET ALA#DSA  ALA#ERRM ALA#HSA  ALA#LCLF ALA#LDSN ALA#LOAD
    ALA#MREP ALA#STOR ALA#TRS  ALA#WTO  ALA$$CCQ ALA$$DSC ALA$$PRM
    ALA$$SEQ ALA$ADM1 ALA$ADMN ALA0PCNF ALA0PNL  ALA0PROC ALA0RPT
    ALA@ALI  ALA@ASTM ALA@CAF  ALA@CAFA ALA@CALL ALA@CCNV ALA@CFIL
    ALA@CMUT ALA@CSTR ALA@DCAF ALA@DFLT ALA@FCFG ALA@FCOM ALA@FD28
    ALA@FDCP ALA@FERR ALA@FFN8 ALA@FRES ALA@FSP  ALA@FST2 ALA@MNT
    ALA@PDEC ALA@POBJ ALA@PSPS ALA@STCK ALAA00   ALAA01   ALAA02
    ALAA03   ALAA04   ALAA05   ALAA06   ALAA07   ALAA08   ALAA09
    ALAA10   ALAA11   ALAA12   ALAA13   ALAA14   ALAA15   ALAA16
    ALAA17   ALAA18   ALAA19   ALAA20   ALAA21   ALAA22   ALAA23
    ALAA2M   ALAA30   ALAA31   ALAA32   ALAA33   ALAA34   ALAA35
    ALAA36   ALAA40   ALAA41   ALAA42   ALAA43   ALAA44   ALAA45
    ALAA46   ALAA47   ALAA48   ALAA49   ALAA50   ALAA51   ALAA52
    ALAA53   ALAA54   ALAA55   ALAA56   ALAA57   ALAA58   ALAA59
    ALAA60   ALAA61   ALAA62   ALAA63   ALAA64   ALAA65   ALAA66
    ALAA67   ALAA68   ALAA69   ALAA70   ALAA71   ALAA72   ALAA73
    ALAA74   ALAA75   ALAA76   ALAA81   ALAA90   ALAAA1   ALAAA10
    ALAAA11  ALAAA11A ALAAA11B ALAAA12  ALAAA12A ALAAA12B ALAAA13
    ALAAA13A ALAAA13I ALAAA13P ALAAA13Q ALAAA14A ALAAA14B ALAAA15
    ALAAA16  ALAAA16A ALAAA16B ALAAA17  ALAAA18  ALAAA19  ALAAA2
    ALAAA20  ALAAA3   ALAAA3A  ALAAA3B  ALAAA4   ALAAA5   ALAAA5C
    ALAAA5CA ALAAA5D  ALAAA5DA ALAAA5E  ALAAA5F  ALAAA5G  ALAAA6
    ALAAA7   ALAAA7A  ALAAA7AP ALAAA7B  ALAAA8   ALAAA9   ALAAAD
    ALAAATV  ALAAC    ALAACCEP ALAACVLT ALAACVTL ALAADB2  ALAADBI
    ALAADBI2 ALAADBI3 ALAADSLP ALAADSNP ALAAFER  ALAAFPS  ALAAFVL
    ALAAFWC  ALAAFWR  ALAALLOC ALAALLOP ALAALOG  ALAAP1   ALAAP2C
    ALAAP5   ALAAPICD ALAAPPLY ALAAPYN  ALAARC1  ALAARC2  ALAARCH
    ALAARCPN ALAARD   ALAARDCU ALAARDDO ALAARDLU ALAARDRT ALAARDTU
    ALAARDUW ALAATSC  ALAATVB  ALAATVI  ALAATVS  ALAAUDPN ALABDCT
    ALABHDR  ALABIND1 ALABINDA ALABINDC ALABINDP ALABINDR ALABINDU
    ALABLNKT ALABPC   ALABSCV  ALABSDM  ALABSDR  ALABSDS  ALABSQL
    ALABSSQL ALABZPRM ALACADMN ALACATF  ALACC    ALACCFG  ALACCORD
    ALACDC   ALACDF   ALACDICT ALACFG   ALACFGRP ALACFREP ALACFRR
    ALACLDEL ALACLST1 ALACMDR  ALACNTL1 ALACQT   ALACRRF  ALACSQL
    ALACSSQL ALACTAU  ALACTV   ALACUOW  ALACUOW6 ALACURR  ALADATA
    

Fix information

  • Fixed component name

    DB2 LOG ANALYSI

  • Fixed component ID

    5655E6601

Applicable component levels

  • R350 PSY UI94653

       UP23/12/07 P F312 {

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":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"350","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 January 2024