A fix is available
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 number
PH08506
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-02-14
Closed date
2019-04-10
Last modified date
2019-05-02
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
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 May 2019