IT24513: ADMIN_MOVE_TABLE: INTRODUCE OPTIONS TO PREVENT CREATION OF NON-UNIQUE INDEXES AND MODSTATE INDEX ON TARGET TABLE

Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows

APAR status

• Closed as new function.

Error description

• New options:
  - WITHOUT_NONUNIQUE_INDEXES: Avoids that secondary get created
  on target table
  - SYNC_MODSTATE_INDEX: Create MODSTATE, if source table has a
  MODSTATE index, otherwise drop MODSTATE index on target table.
  - ADD_MODSTATE_INDEX: Add MODSTATE index regardless, if the
  source table has one.
  - REMOVE_MODSTATE_INDEX: Drop MODSTATE index from target table
  during the MOVE.
  WITHOUT_NONUNIQUE_INDEXES should be specified during
  COPY,REPLAY,SWAP and CLEANUP.
  SYNC_MODSTATE_INDEX, ADD_MODSTATE_INDEX and
  REMOVE_MODSTATE_INDEX has to be specified for MOVE, SWAP and
  CLEANUP operation  to take effect.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 11.1 Fixpack 3 Mod 2 or higher                *
  ****************************************************************
  

Problem conclusion

• First fixed in Db2 11.1 Fixpack 3 Mod 2
  

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:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP