PH27089: ERROR MESSAGE ADB8052E ANALYZING CHANGE WITH ADVANCED TRIGGERS; VARIOUS OTHER FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR provides fixes for the
  following issues:
  
  1. Error ADB8052E (no base
  definition was found) might
  occur when analyzing a change
  with advanced triggers.
  2. A parser error might occur when
  altering a basic trigger by using the
  ALT function.
  3. A panel processing error might
  occur when altering a stored
  procedure by using the ALT function.
  4. The Change Management (CM) analyze
  function might produce an incorrect WSL
  when the table is renamed and an archive
  is enabled in a single change.
  5. The DET line command does not
  display SQL statements in the trigger
  body for advanced triggers.
  6. The error "DELIMITED and SPANNED
  are mutually exclusive options"
  might be displayed on panel ADB2USU
  during the migrate process.
  7. The GEN panel ADB2GENS does not
  change option 'Run as WSL' if
  a mask is used.
  8. The statements 'SET CURRENT SQLID',
  'PRIMARY KEY', 'FOREIGN KEY' and
  'KEY LABEL' are formatted incorrectly
  during various operations.
  
  Keywords:  msgadb8052e
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and Object Comparison Tool for z/OS.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides fixes for the        *
  *                      following issues:                       *
  *                                                              *
  *                      1. Error ADB8052E (no base              *
  *                      definition was found) might             *
  *                      occur when analyzing a change           *
  *                      with advanced triggers.                 *
  *                      2. A parser error might occur when      *
  *                      altering a basic trigger by using the   *
  *                      ALT function.                           *
  *                      3. A panel processing error might       *
  *                      occur when altering a stored            *
  *                      procedure by using the ALT function.    *
  *                      4. The Change Management (CM) analyze   *
  *                      function might produce an incorrect WSL *
  *                      when the table is renamed and an        *
  *                      archive is enabled in a single change.  *
  *                      5. The DET line command does not        *
  *                      display SQL statements in the trigger   *
  *                      body for advanced triggers.             *
  *                      6. The error "DELIMITED and SPANNED     *
  *                      are mutually exclusive options"         *
  *                      might be displayed on panel ADB2USU     *
  *                      during the migrate process.             *
  *                      7. The GEN panel ADB2GENS does not      *
  *                      change option 'Run as WSL' if           *
  *                      a mask is used.                         *
  *                      8. The statements 'SET CURRENT SQLID',  *
  *                      'PRIMARY KEY', 'FOREIGN KEY' and        *
  *                      'KEY LABEL' are formatted incorrectly   *
  *                      during various operations.              *
  ****************************************************************
  This APAR provides fixes to resolve the above errors.
  For #6, the DELIMITED option and other locked options are
  cleared before processing panel ADB2USU during the migrate
  process.
  

Problem conclusion

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

  UI70959

Modules/Macros

• ADB2CMF  ADB2CMO  ADB2FMT  ADB2GEN  ADB2GEN6 ADB2GENS ADB2REM
  ADB2USU  ADBCCMM  ADBDK    ADBE7JA0 ADBEALT  ADBP7J   ADBP7OA0
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI70959

     UP20/08/12 P F008

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.