PH20832: DB2 ZOS ADMIN TOOL COMPARE LOOP WITH INVALID SQL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When comparing an invalid DDL to an object in the
  catalog, the compare abends and goes into a loop.
  
  For example, ddl for an index create had the invalid keyword
  PARTITION. A compare of this DDL with the catalog DDL caused
  the compare abend/loop
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for         *
  *                 z/OS or Object Comparison Tool for z/OS.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Issue 1:                                *
  *                      The DDL reader program (DTC) loops      *
  *                      while processing the DDL for a          *
  *                      partitioned index.                      *
  *                                                              *
  *                      Issue 2:                                *
  *                      A comparison that results in the        *
  *                      creation of an index with the keyword   *
  *                      PARTITIONED when it does not have any   *
  *                      partitions does not detect the -662 SQL *
  *                      error that would result from running    *
  *                      the created WSL.                        *
  ****************************************************************
  Issue 1:
  The DDL reader program (DTC) loops while processing the DDL for
  a partitioned index. The loop occurs when the PARTITIONED option
  is specified for an index and the parent table is not
  partitioned.
  
  Issue 2:
  Compare does not detect a -662 SQL error. The WSL that was
  generated by the comparison contains a CREATE INDEX statement
  with the keyword PARTITIONED when the index is not partitioned.
  Running the WSL results in SQL error -662.
  

Problem conclusion

• The problem has been resolved.
  

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:

  UI68842

Modules/Macros

• ADB2CME  ADB2CMP  ADB2CMR  ADB2CMU  ADBCDTS  ADBGAJOB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI68842

     UP20/04/08 P F004

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.