PH42193: OBJECT COMPARE PBG SEGMENTED TABLESPACES ERRORS ADB7955E ADB1664E

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a source tablespace is PBG and the target tablespace is
  segmented, tablespace compare fails with the following error
  messages during DDL generation:
  
  ADB7955E ADB1664E An internal error occurred. Diagnostic
  text=ADB2REG.CREATE_TABLESPACE(27421):INTERR00000003TP.TS
  >database_name<
  
  ADB7350E Module : ADB2CMF detected an ONCODE condition 8094 in
  CREATE_OBJECT at 20272
  
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped.
  
  
  Note: After applying APAR PH38495 / PTF UI77496, message
  ADB7382S appears instead of message ADB7350E:
  
  
  ADB7955E ADB1664E An internal error occurred. Diagnostic
  text=ADB2REG.CREATE_TABLESPACE(27745):INTERR00000003TP.TS
  >database_name<
  
  ADB7382S Severe error while generating DDL for Tablespace
  >tablespace_name<. Please confirm the DDL is valid.
  
  ADB7380E Module ADB2CMP - Severe error Compare has been stopped.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who use Object Compare to convert a table    *
  *                 space from segmented to partition-by-growth  *
  *                 (PBG)                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: If PARTITIONS are ignored when the      *
  *                      source has a PBG table space and the    *
  *                      target has a segmented table space,     *
  *                      Object Compare returns a severe error   *
  *                      but no messages to direct the user to   *
  *                      existing warnings.                      *
  ****************************************************************
  When comparing a source with a PBG table space to a target with
  a segmented table space and specifying an ignore for PARTITIONS,
  a severe error is returned with no explanation. The error
  message ADB7382S is updated to the following:
  
  ADB7382S Severe error while generating DDL for Tablespace
  >tablespace_name<. Please confirm the DDL is valid.
  Please refer to any previously issued warnings/messages.
  

Problem conclusion

• The problem has been resolved.
  
  Keywords: ADB7382S
  

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:

  UI79000

Modules/Macros

• ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI79000

     UP22/01/25 P F201

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.