PM46457: MSGADB5031W 'NO STATEMENTS WERE FOUND THAT CAN BE RUN' ADMIN DRO P INDEX CHG FILE INDEX <SCHEMA>.<IXNAME> WILL BE DROPPED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' Change Management function
  creates a CHG file with DROP INDEX syntax after the OBJECT
  COMPARISON REPORT shows:
  Compare table source(<schema>.<tab> and target(<schema>.<tab>)
   Source and/or target tablespaces use table-controlled
   partitioning
   Comparison results may not reflect actual object differences
   No changes to Table
  Index <schema>.<index> not found on source
    Index <schema>.<index> will be dropped
  
  GOC2CMP - Ended normally
  however running the change results in a message:
    Migrate to table controlled not done because table is not part
    of the change
  and:
    ADB5031W No statements were found that can be run.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who compare the source and target which *
  *                 will drop an index without a constraint.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When running the change result, the     *
  *                      user will see the message:              *
  *                                                              *
  *                      ADB5031W No statements were found       *
  *                      that can be run.                        *
  *                                                              *
  *                      Also, the changes file produced by      *
  *                      the DB2 Object Comparison Tool is       *
  *                      empty.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  To correctly address this issue, the DB2 Object Comparison Tool
  should generate the statement:
  
  'DROP INDEX ..'
  
  in the changes file.
  

Problem conclusion

• 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:

Modules/Macros

•    ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK72756

     UP11/10/13 P F110

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.