PH29364: OBJECT COMPARE NUMPARTS SOURCE NOT TARGET TS ADB7955E ADBC024E UNEXPECTED CATALOG ROW; PANEL ADBHSARG UPDATED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses two issues:
  
  1) If the source tablespace has a NUMPARTS clause which is not
  defined on the target tablespace, comparing the two tablespaces
  may fail with the following error:
  
  ADB7955E ADBC024E - Unexpected catalog row on source file.
  Expected:TP found:YX
  
  ADB7380E Module ADB2CMP - Severe error Compare  has been
  stopped.
  
  
  2) Help panel ADBHSARG ('Search Fields') has been
  updated to explain how to filter a column
  that has a blank value.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool and     *
  *                 Object Comparison Tool for z/OS.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Issue 1:                                *
  *                                                              *
  *                      Analyzing a change to update the        *
  *                      NUMPARTS value for a                    *
  *                      partition-by-growth (PBG) table space   *
  *                      might result in the following error:    *
  *                      ADB7955E ADBC024E - Unexpected catalog  *
  *                      row on source file. Expected:TP         *
  *                      found:YX                                *
  *                                                              *
  *                      Issue 2:                                *
  *                                                              *
  *                      The help is missing information         *
  *                      to describe how to filter a column      *
  *                      that has a blank value.                 *
  ****************************************************************
  Issue 1:
  
  Compare adds extraneous statements to the changes file when
  comparing a PBG table space to another PBG table space with a
  different NUMPARTS value. The result of analyzing this change
  is a severe error causing processing to stop.
  
  Issue 2:
  
  Panel ADBHSARG 'Search Fields' has been updated to explain how
  to filter a column that has a blank value.
  

Problem conclusion

• The reported problems have been resolved.
  
  Search keywords: MSGADB7955E MSGADB7955 MSGADBC024E MSGADBC02
  

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:

  010PC2Ÿ UI72552 010PC2Ÿ 010PC2Ÿ

Modules/Macros

• ADB2CMT  ADBHSARG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI72552

     UP20/11/14 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.