PH29649: DB2 ADMIN TOOL: ADB1664E AN INTERNAL ERROR OCCURRED WHEN DROPPING A DATABASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 Admin Tool: ADB1664E An internal error occurred when
  dropping a database
  
  Example
  
  ADB7955E ADB2CM2 ADB1664E An internal error occurred. Diagnostic
   text=ADB2REG.CREATE_TABLE(17575):INTERR00000003TB.
  
  ADB7382S ADB2CMR Severe error while generating DDL for TB
  'table name'. Please confirm the DDL is valid.
  
  ADBC026E ADB2CMR Severe Error when generating DDL
  ADB7380E ADB2CMP Module ADB2CMP - Severe error Compare has been
  stopped.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Object Comparison Tool      *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Using Change Management to drop         *
  *                      a table with a view, an alias           *
  *                      on the view, and a trigger              *
  *                      might result in the following errors:   *
  *                                                              *
  *                      ADB7954W Warning : There might be       *
  *                      differences in encoding scheme values.  *
  *                      Information on encoding scheme from     *
  *                      tablespace is not available.            *
  *                                                              *
  *                      ADB7169W The page size of the table     *
  *                      space is unknown because the table      *
  *                      space is not included in the            *
  *                      compared objects. Ensure that the row   *
  *                      length for the table does not exceed    *
  *                      the page size limit.                    *
  *                                                              *
  *                      ADB7955E ADB1664E An internal error     *
  *                      occurred. Diagnostic text=              *
  *                      ADB2REG.CREATE_TABLE(17575):            *
  *                      INTERR00000003TB.                       *
  *                                                              *
  *                      ADB7382S Severe error while generating  *
  *                      DDL for TB <database>.<table>. Please   *
  *                      confirm the DDL is valid.               *
  *                                                              *
  *                      ADB7380E Module ADB2CMP -               *
  *                      Severe error Compare has been stopped.  *
  ****************************************************************
  Analyzing a change to drop either a table with a view, alias on
  that view, and a trigger or an object that contains such a
  table might result in RC12 with the following errors:
  
  ADB7955E ADB1664E An internal error occurred.
  Diagnostic text=ADB2REG.CREATE_TABLE(17575):INTERR00000003TB.
  
  ADB7382S Severe error while generating DDL for
  TB <database>.<table>. Please confirm the DDL is valid.
  

Problem conclusion

• The problem has been resolved.
  
  Search keywords: MSGADB7169W MSGADB7169 MSGADB7382S MSGADB7382
  MSGADB7954W MSGADB7954 MSGADB7955E MSGADB7955
  MSGADB1664E MSGADB1664 MSGADB7380E MSGADB7380
  

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:

  UI72549

Modules/Macros

• ADB2CMF
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI72549

     UP20/12/01 P F011

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.