IBM Support

PI80906: CKZ99041E SUBTASK 01, TABLE NOT FOUND BY OBID = 1163

A fix is available

Subscribe

You can track all active APARs for this component.

 

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