PH08506: LOAD SHRLEVEL NONE ENFORCE NO NOCHECKPEND UTILITY ON THE PARENT TABLE STILL SET CHECK-PENDING STATUS ON THE DEPENDENT TABLES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• LOAD SHRLEVEL NONE ENFORCE NO NOCHECKPEND on a parent table
  still set CHKP status on its child tables' pagesets after APAR
  PI85722. With APAR PI85722 applied, the LOAD doesn't set CHKP on
  parent table, but still set it on the child tables.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 11 for z/OS and Db2 12 for z/OS      *
  *                 users of LOAD SHRLEVEL NONE utility with     *
  *                 NOCHECKPEND specified                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: LOAD REPLACE ENFORCE NO NOCHECKPEND     *
  *                      on a parent table incorrectly set CHKP  *
  *                      on its dependent child tables.          *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  User ran a LOAD REPLACE SHRLEVEL NONE ENFORCE NO NOCHECKPEND
  utility against a parent table in a referential integrity
  relationship.  The LOAD utility completed successfully, but
  it left the dependent table spaces in check pending (CHKP)
  even when NOCHECKPEND is specified by the user to avoid
  check pending from being set.
  
  The reported problem is caused by incorrect program logic
  where the LOAD REPLACE SHRLEVEL NONE utility does not take into
  account the specification of NOCHECKPEND in avoiding setting
  CHKP on the dependent tables after the parent table has been
  reset.
  

Problem conclusion

• Code has been modified for LOAD REPLACE SHRLEVEL NONE to honor
  the NOCHECKPEND specification and not leave the child table
  spaces in CHKP when the parent table is being reset.
  

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:

  UI62490 UI62493

Modules/Macros

•    DSNURRST
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI62493

     UP19/04/25 P F904

• RC10 PSY UI62490

     UP19/04/24 P F904

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.