PM53449: GEN ONCODE150 ONCODE340 ONCODE350 ABENDU4038 ABENDU4039 WHEN DB2 CATALOG HAS INVALID DATA FOR LIMIT KEY SQLCODEN104

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' GEN function can fail
  with an ABENDU4038, ABENDU4039, ONCODE=150, ONCODE=340 or
  ONCODE=350 when attempting to create DDL for an object which has
  an invalid limit key recorded in the DB2 Catalog e.g.
  SYSIBM.SYSTABLEPART.LIMITKEY may have just a decimal point and
  no number.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) function to  *
  *                 generate the DDL statement for a partitioned *
  *                 object which has an invalid limit key        *
  *                 defined in the DB2 Catalog table.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS,    *
  *                      when using the GEN function to          *
  *                      generate the DDL statement for a        *
  *                      partitioned object and there is a       *
  *                      period without any digit specified      *
  *                      for a decimal column when the           *
  *                      LIMITKEY for a partition is defined,    *
  *                      the GEN function failed with an         *
  *                      ONCODE350 / ONCODE=350:                 *
  *                                                              *
  *                      IBM0361W ONCODE=350                     *
  *                      The STRINGRANGE condition               *
  *                      was raised.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 Administration Tool for z/OS, when using using the
  GEN function to generate the DDL statement for a partitioned
  object and there is a period without any digit specified for
  a decimal column when the LIMITKEY for a partition is defined,
  the GEN function fails with an ONCODE350 / ONCODE=350:
  
  IBM0361W ONCODE=350
     The STRINGRANGE condition was raised.
  

Problem conclusion

• The program has been changed to generate an error message
  and terminate if the GEN function encounters an invalid LIMITKEY
  value during process.  The user should correct the invalid value
  in the DB2 Catalog table and then try again:
  
  ADB1944E In the DB2 catalog 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:

Modules/Macros

•    ADB1000  ADB2REM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK78293

     UP12/04/28 P F204

• R720 PSY UK78294

     UP12/04/28 P F204

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.