PH58813: JANUARY 2023 RELEASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• January Release
  - Delete on multiple records fails
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: PH58813                                 *
  *                      The Delete query is not removing all    *
  *                      rows as intended.                       *
  *                      MU Subtable Insert failing with Build2  *
  *                      load saying Parent Key not present      *
  *                      even when the key is present in         *
  *                      Parent Table.                           *
  *                      Delete with Sub Select is clearing out  *
  *                      the whole table.                        *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  PH58813
  The Delete query is not removing all rows as intended.
  MU Subtable Insert failing with Build2 load saying Parent
  Key not present even when the key is present in Parent Table.
  Delete with Sub Select is clearing out the whole table.
  

Problem conclusion

Temporary fix

Comments

APAR Information

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

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

  UI95414

Modules/Macros

• AVZOBRIM 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 UI95414

     UP24/02/01 P F401

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.