PM77986: SYSTABLEPART/LIMITKEY ROW NOT FOUND FOR CREATE INDEX (PART. INDEX LIMITKEY) WHEN COMPARING PBG AND PBR TABLESPACES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS issues a message:
  Compare index source(>schema<.>ix<) and target(>schema<.>ix<)
      (D)Field TYPE changed from 'DATA PARTITIONED SECONDARY
  INDEX' to 'TYPE 2 INDEX'
    (D)Index change from partitioned to simple
    Ignored fields will get values from target partition 1
    Index >schema<.>ix< will be dropped
  systablepart/limitkey  row not found for Create index (part.
  index limitkey)
  ADBC002E - Severe error. Compare terminates
  ADB0380E Module ADB2CMP - Severe error Compare terminates
  when comparing PBG and PBR tablespaces.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who compare objects that contain    *
  *                 partitioned indexes.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Object Compare, the following    *
  *                      message is issued when comparing        *
  *                      partition-by-growth (PBG) and           *
  *                      partition-by-range (PBR) table spaces:  *
  *                                                              *
  *                      Compare index source(>schema<.>ix<)     *
  *                      and target(>schema<.>ix<)               *
  *                         (D)Field TYPE changed from           *
  *                         'DATA PARTITIONED SECONDARY          *
  *                         INDEX' to 'TYPE 2 INDEX'             *
  *                        (D)Index change from partitioned      *
  *                        to simple Ignored fields will get     *
  *                        values from target partition 1        *
  *                        Index >schema<.>ix< will be dropped   *
  *                                                              *
  *                      'systablepart/limitkey row not found    *
  *                      for Create index (part.index limitkey)' *
  *                                                              *
  *                      and does not have a message ID.         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 Object Compare, the error message 'systablepart/limitkey
  row not found for Create index (part.index limitkey)' displayed
  does not have a message ID.
  

Problem conclusion

• Problem has been resolved.
  Message ID ADB1810E is now displayed with the error:
  
  ADB1810E systablepart/limitkey row not found for Create
  index (part.index limitkey)
  

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:

  UK92577 UK92578

Modules/Macros

•    ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK92577

     UP13/03/19 P F303

• RA20 PSY UK92578

     UP13/03/19 P F303

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.