IBM Support

PH54468: CLASSIC PANEL HZ2IN DISPLAYS DYNAMIC SQL YES WHEN IT SHOULD DISPLAY FULL

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Classic Panel HZ2IN displays Dynamic SQL Yes when it should
    display Full
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Classic Interface                            *
    ****************************************************************
    * PROBLEM DESCRIPTION: Incorrect DynamicSQL option displayed.  *
    ****************************************************************
    * RECOMMENDATION: Apply PTF.                                   *
    ****************************************************************
    Problem occurs on panel ZH2IN when displaying NTH Collection
    options that originate from RKD2PAR(COPTxxxx) member (where
    xxxx is DB2 subsystem). DynamicSQL(FULL) incorrectly displays
    as DynamicSQL(YES).
    

Problem conclusion

  • ZH2IN panel changed to display Dynamic SQL - Full when
    DYNAMICSQL(FULL) is input in RKD2PAR(COPTxxxx) member (where
    xxxx is Db2 subsystem).
    
    Keywords:
    DynamicSQL Full RKD2PAR Z2HIN NTH History
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH54468

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    540

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2023-05-11

  • Closed date

    2023-07-26

  • Last modified date

    2023-08-01

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

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

    UI92899

Modules/Macros

  • DGOAFGBP DGOAFGEN DGOBGENL DGOBSRAL DGOBSRBN DGOBSRCM DGOBSRDD
    DGOBSRLG DGOBSRLK DGOBSRLO DGOBSROC DGOBSRPO DGOBSRQP DGOBSRRI
    DGOBSRSH DGOBSRSP DGOBSRSQ DGOBSRSS DGOBSRTM DGOBSTAL DGOBSTBN
    DGOBSTCM DGOBSTDD DGOBSTLG DGOBSTLK DGOBSTLO DGOBSTOC DGOBSTPO
    DGOBSTQP DGOBSTRI DGOBSTSH DGOBSTSP DGOBSTSQ DGOBSTSS DGOBSTTM
    DGOER000 DGOFPDAT DGOFSXST DGOFUCA1 DGOFUCAL DGOFUFAC DGOFUFDI
    DGOPMICO DGOPSB10 DGOPSB20 DGOPSC10 DGOPSC20 DGOPSCNV DGOSACMG
    DGOSACU2 DGOSACUM DGOSAPAW DGOSAPTS DGOSBLKX DGOSBORD DGOSBORE
    DGOSCREC DGOSFILE DGOSFMTQ DGOSFMTR DGOSFMTS DGOSFMTT DGOSGENS
    DGOSI225 DGOSI365 DGOSI411 DGOSI412 DGOSP365 DGOSP411 DGOSP412
    DGOSREDC DGOSREPG DGOSREPM DGOSRMGS DGOSSAVE DGOSSTDA DGOSSWSR
    DGOSTRAC DGOVCRDB DGOVFTAB DGOVFTIN DGOVMSTR DGOVRA   DGOVSCLO
    DGOVSCNI DGOVSCNT DGOVSFLR DGOVSGFT DGOVSLOC DGOVSORT DGOVSQFM
    DGOVSTQL DGOVUDAT DGOVUFTL FPECMDAT FPEFUCAL FPEUCBPR FPEVFTM
    FPEVSFLR FPEVZMAI KD5AGENT KDPACC71 KDPACC72 KDPCPDBI KDPDYNST
    KDPHBP   KDPPLEX  KO2BDDTL KO2CCAFB KO2CCAPB KO2CINTB KO2CPC52
    KO2CPC5A KO2CPC5S KO2CPC62 KO2CPC6A KO2CPC6S KO2CWRKB KO2DDSB2
    KO2DDSBA KO2DDSBK KO2DDSBS KO2DSIF2 KO2DSIFA KO2DSIFS KO2OH2IB
    KO2OQAL2 KO2OQALA KO2OQALS
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R540 PSY UI92899

       UP23/07/28 P F307

  • R550 PSY UI92898

       UP23/07/28 P F307

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":"5.4.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 August 2023