PI97591: MISCELLANEOUS FIXES IN DDL GENERATION FOR DB2 V11 CM

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This fix resolves the following problems in DDL generation for
  Db2 v11 CM:
  1) Stored procedures are not generated.
  2) Global temporary tables that are required for views are not
  generated.
  3) Tables that are required for views are not generated.
  4) Tables that are required for materialized query tables are
  not generated.
  5) Functions that are required for triggers are not generated.
  6) Sequences that are required for triggers are not generated.
  7) Columns are not included in CREATE INDEX for materialized
  query table.
  8) Schema name was not translated in the inner SQL statement.
  9) Explode functionality issue.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Cloning Tool z/OS.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: This fix resolves the following         *
  *                      problems in DDL generation for          *
  *                      Db2 v11 CM:                             *
  *                      1. Stored procedures are not generated. *
  *                      2. Global temporary tables that are     *
  *                      required for views are not generated.   *
  *                      3. Tables that are required for views   *
  *                      are not generated.                      *
  *                      4. Tables that are required for         *
  *                      materialized query tables are not       *
  *                      generated.                              *
  *                      5. Functions that are required for      *
  *                      triggers are not generated.             *
  *                      6. Sequences that are required for      *
  *                      triggers are not generated.             *
  *                      7. Columns are not included in CREATE   *
  *                      INDEX for materialized query table.     *
  *                      8. Schema name was not translated in    *
  *                      the inner SQL statement.                *
  *                      9. Explode functionality issue.         *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

•    CKZ7ADLL
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI56351

     UP18/06/09 P F806

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.