IBM Support

PI77288: CLONING TOOL AND REALTIME STATS - OPTION TO COPY DB2 RTS STATS WITHIN THE JOBS FOR TABLESPACE CLONING

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • We have problems running DB2 utilities like Reorgs against
    cloned tablespaces because of missing real-time statistics ( we
    receive SB37  abends because of wrong space estimations ). This
    APAR will add option to copy DB2 RTS statistics within the jobs
    for tablespace cloning.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of IBM DB2 Cloning Tool z/OS.          *
    ****************************************************************
    * PROBLEM DESCRIPTION: We have problems running DB2 utilities  *
    *                      like Reorgs against cloned tablespaces  *
    *                      because of missing real-time statistics *
    *                      ( we receive SB37  abends because of    *
    *                      wrong space estimations ). This APAR    *
    *                      will add option to copy DB2 RTS         *
    *                      statistics within the jobs              *
    *                      for tablespace cloning.                 *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

Temporary fix

Comments

  • APPLY the PTF.
    

APAR Information

  • APAR number

    PI77288

  • Reported component name

    DB2 CLONING TOO

  • Reported component ID

    5655N1000

  • Reported release

    320

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-02-27

  • Closed date

    2017-04-17

  • Last modified date

    2017-05-01

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

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

    UI46483

Modules/Macros

  •    CKZ$$SEQ CKZBAKS  CKZBAKT  CKZBBKS  CKZBBKT
    CKZBCKS  CKZBCKT  CKZBTS   CKZCD002 CKZDDLAL CKZDDLAQ CKZDDLCL
    CKZDDLCT CKZDDLDB CKZDDLDT CKZDDLIX CKZDDLPK CKZDDLPL CKZDDLRL
    CKZDDLRO CKZDDLRT CKZDDLSG CKZDDLSN CKZDDLSQ CKZDDLTB CKZDDLTR
    CKZDDLTS CKZDDLVA CKZDDLVT CKZDDLXT CKZFCONN CKZGCSTL CKZGDBGP
    CKZGDIBI CKZGDIBP CKZGFDCM CKZGFLST CKZGLOG2 CKZGLOG3 CKZGLST2
    CKZGMETL CKZGOBJT CKZGOBJZ CKZGPDBG CKZGRTSI CKZGRTSM CKZGRTST
    CKZGSIXN CKZGSIX2 CKZGSLSN CKZGSQLE CKZGSSGN CKZGSTBN CKZGSTSN
    CKZGSTS1 CKZGSTS2 CKZGUTIL CKZHCOPC CKZHDRTS CKZHEDAC CKZHRTSC
    CKZHSETC CKZHTCOP CKZHTDDC CKZHTSET CKZHTULD CKZHUEDA CKZHULDC
    CKZHVTDD CKZH040E CKZH042E CKZH050E CKZH055E CKZH481E CKZH490E
    CKZH492E CKZINI#  CKZJOBRN CKZNORMT CKZPSIXN CKZPSIX2 CKZPSLSN
    CKZPSSGN CKZPSTBN CKZPSTSN CKZPSTS1 CKZPSTS2 CKZTS2   CKZ00500
    CKZ00501 CKZ00506 CKZ00510 CKZ00530 CKZ00532 CKZ00535 CKZ00536
    CKZ00537 CKZ00540 CKZ00544 CKZ00545 CKZ00546 CKZ00547 CKZ00548
    CKZ00549 CKZ00555 CKZ00562 CKZ00569 CKZ00600 CKZ00619 CKZ00625
    CKZ00634 CKZ00637 CKZ00713 CKZ00715 CKZ00716 CKZ00719 CKZ00720
    CKZ00725 CKZ00734 CKZ00737 CKZ00760 CKZ00761 CKZ00764 CKZ00765
    CKZ00769 CKZ00781 CKZ00992 CKZ00993 CKZ04    CKZ05    CKZ1COPC
    CKZ1DRTS CKZ1RTSC CKZ1SETC CKZ1TCOP CKZ1TSET CKZ2ADRD CKZ2BCLC
    CKZ2BDCJ CKZ2BLSJ CKZ2CLON CKZ2CMND CKZ2CMPN CKZ2COCP CKZ2COMM
    CKZ2CTCP CKZ2CULC CKZ2DALV CKZ2DAPS CKZ2DBSS CKZ2DB2A CKZ2DCCC
    CKZ2DCCH CKZ2DCRN CKZ2DDAT CKZ2DDSP CKZ2DEFD CKZ2DFIX CKZ2DREN
    CKZ2DRFD CKZ2DSAP CKZ2DSCJ CKZ2DSCL CKZ2DSCN CKZ2DSCP CKZ2DSCS
    CKZ2DSQL CKZ2DSTP CKZ2DTCP CKZ2DTCS CKZ2EDAC CKZ2EDCV CKZ2EDDF
    CKZ2EDDL CKZ2EDDS CKZ2ELDC CKZ2EMCS CKZ2EMDC CKZ2ESCP CKZ2ETCP
    CKZ2FTSJ CKZ2GFSJ CKZ2GVAR CKZ2IVPL CKZ2JSKL CKZ2LACR CKZ2LAOP
    CKZ2LSTS CKZ2MAIN CKZ2MEPL CKZ2MSTF CKZ2MTMB CKZ2NPPR CKZ2OMRC
    CKZ2PDAC CKZ2PDBL CKZ2PJCI CKZ2PLAP CKZ2PLDC CKZ2PMDC CKZ2PRDM
    CKZ2PRFL CKZ2PRIM CKZ2PZPI CKZ2RTSC CKZ2SASV CKZ2SBCI CKZ2SCLT
    CKZ2SFRJ CKZ2SFSJ CKZ2SFTJ CKZ2SIDL CKZ2SJCI CKZ2SJCL CKZ2SJTS
    CKZ2SJTV CKZ2SKL  CKZ2SOMT CKZ2SOPR CKZ2SPCC CKZ2SPRF CKZ2SRNM
    CKZ2SRSV CKZ2SSCP CKZ2SSDS CKZ2SSID CKZ2SSLB CKZ2SSMC CKZ2SSSC
    CKZ2SSSJ CKZ2SSTM CKZ2SSTN CKZ2SSTS CKZ2SSTT CKZ2SSTV CKZ2STSS
    CKZ2TCOP CKZ2TDDC CKZ2TDDF CKZ2TDSP CKZ2TJCL CKZ2TRCF CKZ2TSCI
    CKZ2TSCP CKZ2TSET CKZ2TTRN CKZ2ULCL CKZ2USET CKZ4ASYS CKZ4PROF
    CKZ4RDLL CKZ4TPRF CKZ48    CKZ49    CKZ6ADLL CKZ6BCPR CKZ6BLST
    CKZ6BOCL CKZ6BPDD CKZ6BSSP CKZ6BTCL CKZ6BTSS CKZ6DACL CKZ6DDFL
    CKZ6FIXC CKZ6GRPR CKZ6HLLS CKZ6IGNR CKZ6IPRM CKZ6JBCD CKZ6JTLS
    CKZ6MAIN CKZ6OMRC CKZ6OPDD CKZ6OTLS CKZ6RPDD CKZ6SCPR CKZ6SPDD
    CKZ6SPRM CKZ6SQLC CKZ6SSPL CKZ6SSPR CKZ6STPC CKZ6STRT CKZ6TCPR
    CKZ6TPDD CKZ6TPRM CKZ6TVLS CKZ6UPDC CKZ6UXCL CKZ8CMDE CKZ8UTIL
    HCKZ320
    

Fix information

  • Fixed component name

    DB2 CLONING TOO

  • Fixed component ID

    5655N1000

Applicable component levels

  • R320 PSY UI46483

       UP17/04/24 P F704

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":"SSAUUE","label":"IBM Db2 Cloning Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 May 2017