IBM Support

PH65148: RUNNING CONCAT SQL QUERY AGAINST A DVM VIRTUAL TABLE USING Z/OS CONNECT DOES NOT WORK

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Running CONCAT SQL query against a DVM virtual table using z/OS
    Connect does not work
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: ALL USERS                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: DVM Concat SQL commands not working     *
    ****************************************************************
    * RECOMMENDATION: APPLY PTF                                    *
    ****************************************************************
    DVM Concat SQL commands not working
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH65148

  • Reported component name

    DATA VIRT MGR Z

  • Reported component ID

    5698DVM00

  • Reported release

    110

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2025-02-06

  • Closed date

    2025-04-02

  • Last modified date

    2025-05-02

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

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

Modules/Macros

  • AVZCOPDM AVZDB2SQ AVZIMSDR AVZIMSSQ AVZINPIO AVZINTMR AVZISACI
    AVZOBRSQ AVZOCXA0 AVZODF9D AVZODF9N AVZODFAD AVZODFAN AVZODFBD
    AVZODFBN AVZODFCD AVZODFCN AVZODFDD AVZODFDN AVZSQ29D AVZSQ29N
    AVZSQ2BN AVZSQ2CN AVZSQ2DN AVZSQL9D AVZSQL9N AVZSQLBN AVZSQLCN
    AVZSQLDN AVZZCLNT
    

Fix information

  • Fixed component name

    DATA VIRT MGR Z

  • Fixed component ID

    5698DVM00

Applicable component levels

  • R110 PSY UO02692

       UP25/04/04 P F504

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":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"110"}]

Document Information

Modified date:
05 May 2025