IBM Support

PH58467: 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

  • ×**** PE24/01/11 FIX IN ERROR. SEE APAR PH59145  FOR DESCRIPTION
    ×**** PE24/01/11 FIX IN ERROR. SEE APAR PH59145  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PH58467

  • Reported component name

    DB2 LOG ANALYSI

  • Reported component ID

    5655E6601

  • Reported release

    350

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2023-11-30

  • Closed date

    2023-12-01

  • Last modified date

    2024-01-12

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

    PH58394

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

    UI94654

Modules/Macros

  • ALA#CMET ALA#DSA  ALA#ERRM ALA#HSA  ALA#LCLF ALA#LOAD ALA#MREP
    ALA#STOR ALA#WTO  ALA$$DSC ALA$$PRM ALA$$SEQ ALA$ADM1 ALA$ADMN
    ALA0ISPF ALA0PNL  ALA0PROC ALA0RPT  ALA@ASIN ALA@CAFA ALA@CALL
    ALA@CCNV ALA@CLG2 ALA@CSTR ALA@DCBI ALA@FCCH ALA@FCOM ALA@FDVR
    ALA@FFN8 ALA@FFNG ALA@FSFL ALA@HLI2 ALA@PCOM ALA@PGLN ALA@PPRS
    ALA@PSTN ALA@TIAR ALAA01   ALAA03   ALAA04   ALAA06   ALAA07
    ALAA08   ALAA09   ALAA13   ALAA14   ALAA15   ALAA17   ALAA18
    ALAA20   ALAA21   ALAA22   ALAA2M   ALAA31   ALAA32   ALAA33
    ALAA36   ALAA44   ALAA48   ALAA49   ALAA52   ALAA53   ALAA56
    ALAA59   ALAA62   ALAA64   ALAA66   ALAA67   ALAA72   ALAA73
    ALAA74   ALAA75   ALAA76   ALAA90   ALAAA1   ALAAA10  ALAAA11A
    ALAAA12  ALAAA12A ALAAA12B ALAAA13J ALAAA13P ALAAA14B ALAAA16A
    ALAAA18  ALAAA20  ALAAA3   ALAAA3A  ALAAA4   ALAAA5C  ALAAA5D
    ALAAA5DA ALAAA5E  ALAAA7   ALAAA7B  ALAAA7BP ALAAATV  ALAAC
    ALAACCEP ALAACVLT ALAADBI2 ALAAFWC  ALAALLOP ALAALOG  ALAAP2
    ALAAP2V  ALAAP3   ALAAP4   ALAAPPLY ALAARC2  ALAARCH  ALAARCPN
    ALAARD   ALAARDCU ALAARDDO ALAARDLU ALAARDRT ALAARDTU ALAARDUW
    ALAATVB  ALAATVI  ALAATVS  ALABDCT  ALABIND  ALABINDA ALABINDC
    ALABLNKT ALABSDM  ALABSDS  ALACADMN ALACATR  ALACDF   ALACFRR
    ALACLDEL ALACLST1 ALACMDR  ALACNTL  ALACNTL1 ALACSQL  ALACSSQL
    ALACTV   ALACUOW  ALACUOW6 ALACURR  ALADATA  ALADCTP  ALADELER
    ALADFLT  ALADLMPN ALADSA   ALADSNM  ALADSUMR ALADTL2  ALAEBS
    ALAEDIT  ALAERR   ALAESQL  ALAETV   ALAFADDL ALAFCP   ALAFFV
    ALAFLD   ALAFR1A  ALAFR1AV ALAFR1CX ALAFR1GV ALAFR1LV ALAFR1PV
    ALAFR1X  ALAFR2M  ALAFR64  ALAFR6TC ALAFRC8  ALAFRCA  ALAFRCCM
    ALAFRCRV ALAFRFLO ALAFRGNR ALAFRJSN ALAFRLCV ALAFRONT ALAFRPEX
    ALAFRPIE ALAFRPMC ALAFRPMN ALAFRQGR ALAFRQIV ALAFRSP  ALAFRTVB
    ALAFRTVI ALAFUTIL ALAGAL   ALAGEN1  ALAGEND  ALAGENR  ALAGFL2
    ALAGFLA  ALAGIC   ALAGL2   ALAGL3   ALAGLCS  ALAGLOAD ALAGLOAT
    ALAGLS   ALAGMT   ALAGNJCL ALAGVRFY ALAHDR   ALAHDRPN ALAHLP0
    ALAHLP1  ALAHLP2  ALAHLP3  ALAIDCM  ALAIDRP  ALAIF    ALAIN1
    ALAIN1R  ALAIN4R  ALAIN4X  ALAIN5   ALAIN5DX ALAIN5X  ALAIN9
    ALAIN9XR ALAINAX  ALAINB   ALAINBR  ALAINC   ALAINCX  ALAIR2
    ALAISPMN ALAJSDEF ALAJSON  ALAJSONO ALAJSONW ALALB1   ALALCOPN
    ALALDCR  ALALF1B  ALALF2   ALALF3W  ALALFCPN ALALIN   ALALOAD1
    

Fix information

  • Fixed component name

    DB2 LOG ANALYSI

  • Fixed component ID

    5655E6601

Applicable component levels

  • R350 PSY UI94654

       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:
12 January 2024