PH54408: ADMIN TOOL:ADDING SOURCE EXCLUDE CAUSES UNRELATED GRANT STATEMENTS AND DROP ALIAS STATEMENTS TO BE MISSING FROM THE WSL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABSTRACT:  Adding source exclude causes unrelated GRANT
  statements and DROP ALIAS statements to be missing from the WSL
  
  
  
  
  DESCRIPTION:  When the user attempts to generate a change that
  contains excludes on source for table/view authorization ids,
  unrelated GRANT and DROP statements are unintentionally excluded
  from the WSL.
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who use Object Comparison Tool               *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a compare job is generated that    *
  *                      uses source exclude specifications,     *
  *                      unrelated objects are unintentionally   *
  *                      excluded from the work statement list   *
  *                      (WSL).                                  *
  ****************************************************************
  When the user attempts to run Object Compare using source
  exclude specification TA based on a specific grantee, the
  generated WSL has missing GRANT statements and
  missing DROP ALIAS and CREATE ALIAS statements in certain
  scenarios.
  
  Object Compare is fixed to correctly exclude table
  authorizations based on the specified grantee.
  
  Keywords:
  

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:

  UI93441 UI93442

Modules/Macros

• ADB2CM1  ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP
  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADBCMPDB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI93441

     UP23/09/08 P F309

• RD10 PSY UI93442

     UP23/09/08 P F309

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.