PI95768: MISCELLANEOUS FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1) SQLCODE = -104, ERROR: ILLEGAL SYMBOL ",". SOME SYMBOLS THAT
  MIGHT BE LEGAL ARE: CHECK  CONSTRAINT UNIQUE FOREIGN PRIMARY
  2) LISTDEF that contains keywords RI and HISTORY generated
  incorrectly
  3) CKZ54437W Index BASRC1.XFHASPAB_#_ZVE in List TESTLIST.01
  has Specified a PARTLEVEL 3 that Exceeds the Number of
  Partitions
  4) -104 occurs for part level cloning when enable PROCESS-DDL
  5) CKZ54721W and CKZ00137E are issued for implicit objects with
  CATALOG-PREFETCH enabled
  6) ABEND S0C4 may occur when source Db2 is in data sharing group
  and LOG-APPLY is enabled
  7) QA issue: DOCID is not updated for history table with XML
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Cloning Tool z/OS.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. SQLCODE = -104, ERROR: ILLEGAL       *
  *                      SYMBOL ",". SOME SYMBOLS THAT MIGHT BE  *
  *                      LEGAL ARE: CHECK  CONSTRAINT UNIQUE     *
  *                      FOREIGN PRIMARY                         *
  *                      2. LISTDEF that contains keywords RI    *
  *                      and HISTORY generated incorrectly       *
  *                      3. CKZ54437W Index                      *
  *                      BASRC1.XFHASPAB_#_ZVE in List           *
  *                      TESTLIST.01 has Specified a             *
  *                      PARTLEVEL 3 that Exceeds the Number     *
  *                      of Partitions                           *
  *                      4. -104 occurs for part level cloning   *
  *                      when enable PROCESS-DDL                 *
  *                      5. CKZ54721W and CKZ00137E are issued   *
  *                      for implicit objects with               *
  *                      CATALOG-PREFETCH enabled                *
  *                      6. ABEND S0C4 may occur when source     *
  *                      Db2 is in data sharing group            *
  *                      and LOG-APPLY is enabled                *
  *                      7. QA issue: DOCID is not updated for   *
  *                      history table with XML                  *
  ****************************************************************
  * 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

•    CKZCALNC
  

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.