IBM Support

PH53991: RACF CHECKING FOR VT QUERIES USING INCORRECT SCHEMA NAME

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • On SQL Queries for virtual tables, the RACF READ/UPDATE
    test uses the default schema name from IN00 even if the
    virtual table is for a schema different from the default
    (ex. DVSQL.TABLENAME instead of NEWSCHEMA.TABLENAME).
    This only applies to SQL queries as authorization checking
    for the purpose of the presenting tables in the Data Studio
    works correctly
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: ALL USERS                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: PH53991                                 *
    *                      RACF Checking for VT Queries using      *
    *                      incorrect schema name                   *
    ****************************************************************
    * RECOMMENDATION: APPLY PTF                                    *
    ****************************************************************
    PH53991
    RACF Checking for VT Queries using incorrect schema name
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH53991

  • 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

    2023-04-18

  • Closed date

    2023-05-29

  • Last modified date

    2023-06-01

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

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

Modules/Macros

  • AVZBINDW AVZOAOEX AVZORXAO AVZSQ29D AVZSQ29N AVZSQ2BN AVZSQ2CN
    AVZSQ2DN AVZSQL9D AVZSQL9N AVZSQLBN AVZSQLCN AVZSQLDN
    

Fix information

  • Fixed component name

    DATA VIRT MGR Z

  • Fixed component ID

    5698DVM00

Applicable component levels

  • R110 PSY UI92010

       UP23/05/31 P F305

[{"Business Unit":{"code":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19O"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"110"}]

Document Information

Modified date:
01 June 2023