PK31611: GOC DEFER YES OMITTED FROM CREATED DDL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparision Tool omitted the DEFER YES from the
  syntax created for a CREATE INDEX statement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool, who     *
  *                 attempt to CREATE INDEX, may be affected.    *
  *                 .* Note:                                     *
  *                 PK31611 requires PK32461 as an IFREQ.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The  DEFER  YES  was  omitted  from the *
  *                      syntax  created  for  a  CREATE   INDEX *
  *                      statement.                              *
  *                      .*                                      *
  *                      DDL for a CREATE INDEX statement didn't *
  *                      have the  DEFER YES statement specified *
  *                      in the source DDL.                      *
  *                      .* Note: PK31611 fix includes:          *
  *                      * CREATE INDEX statement with DEFER YES *
  *                      is created for new or dropped/recreated *
  *                      indexes.                                *
  *                      * If Run REORG/REBUILD option  on panel *
  *                      GOC5  is  set to mandatory and REORG is *
  *                      not needed a rebuild step for the index *
  *                      will be generated.                      *
  *                      .* Note                                 *
  *                      PK31611 requires PK32461 as an IFREQ.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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

•    GOC2CMF  GOC2CMP  GOC2CMR
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK20017

     UP06/11/30 P F611

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.