PM63459: IBM INTERNAL APAR FOR DEFECT 24509

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• "In the DB2 catalog table SYSTABLEPART" should be "In the table
  SYSTABLEPART" in message ADB1944E.
  ADB1944E In the DB2 catalog table SYSTABLEPART, there is a
           a record of PARTITION <partition-no> of
           <obj_type> <obj_qualifier>.<obj_name>,
           which has an invalid value <invalid-value>
           for part <col_sequence> of column LIMITKEY.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) function     *
  *                 with the Catalog Copy function.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS,    *
  *                      when using the GEN function with        *
  *                      Catalog Copy, the error message         *
  *                      ADB1944E 'In the DB2 catalog table      *
  *                      SYSTABLEPART' is not accurate.          *
  *                      The correct message should read         *
  *                      'In the table SYSTABLEPART'.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 Administration Tool for z/OS, when using the GEN
  function with Catalog Copy, the error message ADB1944E 'In the
  DB2 catalog table SYSTABLEPART' is not accurate.  The correct
  message should read 'In the table SYSTABLEPART'.
  

Problem conclusion

• Problem has been resolved.  The message has been updated to:
  
  ADB1944E In the table SYSTABLEPART, there is
           a record of PARTITION >partition-no< of
           >obj_type< >obj_qualifier<.>obj_name<,
           which has a invalid value >invalid-value<
           for part >col_sequence< of column
           LIMITKEY.
  
  partition-no: partition number.
  obj_type: index or table.
  obj_qualifier: qualifier of the object which caused error.
  obj_name: name of the object which caused the error.
  invalid-value: invalid value in the catalog table.
  col_sequence: the sequence of column in the 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:

  UK78988

Modules/Macros

•    ADB1000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK78988

     UP12/05/30 P F205

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.