A fix is available
APAR status
Closed as program error.
Error description
Target job with DDL-ENABLE(Y) processing columns that are included in hash keys may encounter error message 'CKZ99041E Subtask 01, Table not found by OBID = 1163.' This issue was a result of 'Hash home page' being processed as 'data page' in the data masking module. The processing of 'hash home page' was added. Warning messages were added: 1) CKZ990101W Subtask subtask_number, Unable to add mask_rule for creator.table(column) column because it is part of the hash key 2) CKZ990102W Subtask subtask_number, Unable to add mask_rule for creator.table(column) column because it is related to a hash key by RI
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Cloning Tool for Z/OS * **************************************************************** * PROBLEM DESCRIPTION: Target job with DDL-ENABLE(Y) * * processing columns that are included * * in hash keys may encounter error * * message 'CKZ99041E Subtask 01, Table * * not found by OBID = 1163.' This issue * * was a result of 'Hash home page' being * * processed as 'data page' in the data * * masking module. * * The processing of 'hash home page' was * * added. * * Warning messages were added: * * 1) CKZ990101W Subtask subtask_number, * * Unable to add mask_rule for * * creator.table(column) column because * * it is part of the hash key * * 2) CKZ990102W Subtask subtask_number, * * Unable to add mask_rule for * * creator.table(column) column because * * it is related to a hash key by RI * **************************************************************** * RECOMMENDATION: * **************************************************************** Code to fix this problem has been changed.
Problem conclusion
APPLY the PTF
Temporary fix
Comments
APAR Information
APAR number
PI80906
Reported component name
DB2 CLONING TOO
Reported component ID
5655N1000
Reported release
320
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-05-02
Closed date
2017-05-24
Last modified date
2017-07-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI47564
Modules/Macros
CKZFASM CKZFCOMM CKZFDB2 CKZFLOG CKZFMASK CKZFOBJX CKZFPIN CKZFPMIB CKZFPSDP CKZFPTRN CKZFRAND CKZZCOMM CKZZDB2 CKZZLOG CKZZMASK CKZZOBJX CKZZPIN CKZZPTRN CKZZRAND CKZ00501 CKZ00510 CKZ00528 CKZ00540 CKZ00546 CKZ00769 CKZ00990 CKZ00991
Fix information
Fixed component name
DB2 CLONING TOO
Fixed component ID
5655N1000
Applicable component levels
R320 PSY UI47564
UP17/06/03 P F706
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0"}]
Document Information
Modified date:
31 March 2021