PI92866: CREATE COMPLETE DDL FOR TARGET SYSTEM WHEN CLONING RFE 74602

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Request to support all DDL creation on the target beyond the
  level of tables and indexes. (views, synonyms, etc.)
  Description
  http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&C
  R_ID=74602
  The customer uses cloning for moving data from production into
  his integration and acceptance environments. In additiona the
  customer needs to create new test environments. This requires
  generation of DDL as well so that the target environment matches
  the source environment.
  .
  Currently the DDL capabilities in DB2 Cloning Tool (DB, TS, TB,
  IX) are very limited and restrictive. This applies also to
  masking capabilities which need a more granular differentiation
  capability.
  ..
  Use Case
  In a clone process the customer has the need to also copy
  additional object types - such as Views, Aliases, Synonyms,
  triggers, Stored Procedures.
  That is a mandatory application requirement that occurs on an
  adhoc base.
  Without that the customer has no possibility to properly select
  the objects that require cloning and make them accessible for
  application use on the target side.
  For masking example, the customer has the need to distinguish
  CREATORs for the various object types. Currently DB2 Cloning
  Tool does not provide this capability. This makes it dificcult
  to define the clone process and make it time consuming to set up
  and test.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Cloning Tool z/OS.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Request to support all DDL creation on  *
  *                      the target beyond the level of tables   *
  *                      and indexes. (views, synonyms, etc.)    *
  *                      Description                             *
  *                      http://www.ibm.com/developerworks       *
  *                      /rfe/execute?use_case=viewRfe&C         *
  *                      R_ID=74602                              *
  *                      The customer uses cloning for moving    *
  *                      data from production into his           *
  *                      integration and acceptance              *
  *                      environments. In addition the           *
  *                      customer needs to create new test       *
  *                      environments. This requires             *
  *                      generation of DDL as well so that the   *
  *                      target environment matches the source   *
  *                      environment.                            *
  *                      Currently the DDL capabilities in DB2   *
  *                      Cloning Tool (DB, TS, TB, IX) are very  *
  *                      limited and restrictive. This applies   *
  *                      also to masking capabilities which      *
  *                      need a more granular differentiation    *
  *                      capability.                             *
  *                      Use Case                                *
  *                      In a clone process the customer has     *
  *                      the need to also copy additional        *
  *                      object types - such as Views, Aliases,  *
  *                      Synonyms, triggers, Stored Procedures.  *
  *                      That is a mandatory application         *
  *                      requirement that occurs on an adhoc     *
  *                      basis. Without that the customer has    *
  *                      no possibility to properly select       *
  *                      the objects that require cloning and    *
  *                      make them accessible for application    *
  *                      use on the target side.                 *
  *                      For masking example, the customer has   *
  *                      the need to distinguish CREATORs for    *
  *                      the various object types. Currently     *
  *                      DB2 Cloning Tool does not provide this  *
  *                      capability. This makes it dificcult     *
  *                      to define the clone process and make    *
  *                      it time consuming to set up and test.   *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

  UI54978

Modules/Macros

•    CKZBAKS  CKZBAKT  CKZBBKS  CKZBBKT  CKZBCKS
  CKZBCKT  CKZBSS   CKZBTD   CKZBTS   CKZCALNC CKZCAL9C CKZCAQNC
  CKZCAQ1C CKZCATM  CKZCATMO CKZCAT01 CKZCCTNC CKZCCT9C CKZCDB9C
  CKZCDPNC CKZCDTNC CKZCDT0C CKZCDT1C CKZCDT9C CKZCD002 CKZCFNNC
  CKZCFN0C CKZCFN9C CKZCHECK CKZCIXNC CKZCIX0C CKZCIX2C CKZCIX9C
  CKZCMTNC CKZCMT0C CKZCPKNC CKZCPK0C CKZCPK1C CKZCPK9C CKZCPLNC
  CKZCPL0C CKZCPL1C CKZCPL9C CKZCRL2C CKZCRL9C CKZCRO9C CKZCRTNC
  CKZCSGVA CKZCSG9C CKZCSNNC CKZCSN9C CKZCSPNC CKZCSP9C CKZCSQNC
  CKZCSQ1C CKZCSQ9C CKZCTBNC CKZCTB0C CKZCTB1C CKZCTB2C CKZCTB9C
  CKZCTRNC CKZCTR0C CKZCTR9C CKZCTSNC CKZCTS0C CKZCTS2C CKZCTS9C
  CKZ6TCPR CKZ6TPDD CKZ6TPRM CKZ6TVLS CKZ6UDDS CKZ6UPDC CKZ6UXCL
  CKZ6VALF CKZ6VPLS CKZ6WEMS HCKZ320
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI54978

     UP18/04/07 P F804

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.