PK42992: CM RUN REPORTS ' ADBC099E : WSL MISMATCH ' WHEN A TABLE CONTAINS RESTRICT ON DROP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool encountered message ADBC099E: WSL
  MISMATCH during re-issuing the analyze line command (AN) again
  onthe change panel ( ADB2C11 ).
  Additional symptoms: msgadbc099e
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 ADMIN TOOL users who use Change          *
  *                 Management and have the tables with          *
  *                 RESTRICT ON DROP.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: During a run of the  Change Management  *
  *                      (CM) change,  runtime analyze  is done  *
  *                      to generate the temporary WSL files to  *
  *                      compare  against  the WSL  files  that  *
  *                      were generated  during normal analyze.  *
  *                      The  problem is  that  runtime analyze  *
  *                      was not  producing the statements like  *
  *                      ALTER  TABLE <name>  DROP RESTRICT  ON  *
  *                      DROP,  which the results in the CM Run  *
  *                      process reporting WSL differences that  *
  *                      stopped the run of the change.          *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  CM Run incorrectly reported WSL differences when a CM change is
  run that involves an ALTER TABLE <name> DROP RESTRICT ON DROP.
  

Problem conclusion

• The problem has been fixed. The ALTER TABLE <name> DROP RESTRICT
  ON DROP statement is now included in the runtime analyze.
  

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

•    ADB2WCM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK29139

     UP07/10/17 P F710

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.