IBM Support

PH53016: CANNOT INSERT INTO SQLENG.TABLESTATS UNLESS RUNSTATS HAVE BEEN CAPTURED ON THE SERVER

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Cannot insert into SQLENG.TABLESTATS unless RUNSTATS have been
    captured on the server
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: ALL USERS                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: PH53016                                 *
    *                      Cannot insert into SQLENG.TABLESTATS    *
    *                      unless RUNSTATS have been captured on   *
    *                      the server                              *
    ****************************************************************
    * RECOMMENDATION: APPLY PTF                                    *
    ****************************************************************
    PH53016
    Cannot insert into SQLENG.TABLESTATS unless RUNSTATS have been
    captured on the server
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH53016

  • 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-03-06

  • Closed date

    2023-08-22

  • Last modified date

    2023-09-01

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

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

Modules/Macros

  • AVZCCUBU AVZCDLCH AVZCGTMM AVZCISBR AVZCOPDM AVZCSQMM AVZCSQOP
    AVZCTSOP AVZCXDLI AVZMBTPA AVZOBRSQ AVZOBRSR AVZOCLUP AVZODMWR
    AVZOINSQ AVZOIO31 AVZOMPTP AVZOPPA  AVZORXDM AVZPB    AVZSFPAR
    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 UI93275

       UP23/08/23 P F308

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:
01 September 2023