PH01085: ADD EXECUTE-CREATE-DDL(Y/N) PARAMETER TO DB2SCHEMA-UPDATE COMMAND

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Before these changes, the DB2SCHEMA-UPDATE command always runs
  DROP DDL, calls Db2 CATMAINT SCHEMA SWITCH, and runs
  CREATE DDL, without the possibility of turning off CREATE DDL
  execution.
  After these changes, the user can turn off CREATE DDL execution
  if needed.
  If a column name value matches the name of an existing table,
  then a new schema name is added as a qualifier to this column
  name value in the SQL text of the object during DB2SCHEMA-UPDATE
  processing. After applying this fix, the the column name values
  in the SQL text of the object are not changed during
  DB2SCHEMA-UPDATE processing.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Cloning Tool z/OS.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Before these changes, the               *
  *                      DB2SCHEMA-UPDATE command always runs    *
  *                      DROP DDL, calls Db2 CATMAINT SCHEMA     *
  *                      SWITCH, and runs CREATE DDL, without    *
  *                      the possibility of turning off CREATE   *
  *                      DDL execution.                          *
  *                      After these changes, the user can turn  *
  *                      off CREATE DDL execution if needed.     *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

• ×**** PE18/11/14 PTF IN ERROR. SEE APAR PH05310  FOR DESCRIPTION
  

APAR Information

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

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

  UI58442

Modules/Macros

•    CKZ$$SEQ CKZBSS   CKZBTS   CKZCATM  CKZCATMO
  CKZCBDCL CKZCP1SB CKZCP2SB CKZDDLLA CKZFATTR CKZHEDCV CKZHSCHM
  CKZHSSTC CKZHSSTV CKZHVSCH CKZHVSTC CKZH402E CKZH403E CKZH404E
  CKZH465E CKZJOBT6 CKZJOBT7 CKZJOBT8 CKZREPJB CKZVOLOP CKZ00020
  CKZ00021 CKZ00022 CKZ00023 CKZ00024 CKZ00030 CKZ00031 CKZ00032
  CKZ00035 CKZ00040 CKZ00055 CKZ00056 CKZ00057 CKZ00060 CKZ00070
  CKZ00071 CKZ00072 CKZ00073 CKZ00100 CKZ00110 CKZ00111 CKZ00112
  CKZ00113 CKZ00114 CKZ00115 CKZ00116 CKZ00117 CKZ00130 CKZ00135
  CKZ00136 CKZ00140 CKZ00141 CKZ00143 CKZ00150 CKZ00151 CKZ00215
  CKZ00220 CKZ00221 CKZ00222 CKZ00223 CKZ00224 CKZ00230 CKZ00235
  CKZ6ICFL CKZ6IPRM CKZ6JBCD CKZ6JTLS CKZ6LDLS CKZ6MAIN CKZ6MDLS
  CKZ6OMRC CKZ6OPDD CKZ6OTLS CKZ6PDLS CKZ6RENM CKZ6RPDD CKZ6SCHM
  CKZ6SCPR CKZ6SMSL CKZ6SPDD CKZ6SPRM CKZ6SQLC CKZ6SSMS CKZ6SSPL
  CKZ6SSPR CKZ6STGL CKZ6STPC CKZ6STRT CKZ6TCPR CKZ6TPDD CKZ6TPRM
  CKZ6TVLS CKZ6UDDS CKZ6UPDC CKZ6UXCL CKZ6VPLS CKZ6WEMS CKZ7ADLL
  CKZ8UTIL HCKZ320
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI58442

     UP18/09/14 P F809

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.