PH32354: OBJECT COMPARE ADD PARTITION DECIMAL COLUMN LEADING ZEROES ADB7383E ERROR PROCESSING LIMIT KEY WRONG INPUT PARAMETERS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When adding a table partition on a decimal column in conjunction
  with another column, a compare analyze job may fail with the
  following error, depending on the decimal precision and decimal
  value:
  
  ADB7383E ADB2CMT  A severe error occured when processing the
                    specified limit key for table >tablename<.
                    Wrong input parameters in column >column_name<
  
  
  The following will result in the error:
  
  Column definitions:
  
  DECIMAL(5, 0) NOT NULL,
  TIMESTAMP (6) WITHOUT TIME ZONE NOT NULL,
  
  Example Partition:
  
  PARTITION 3 ENDING AT (00000., '2009-12-31-24.00.00.000000'),
  
  Internally, the leading zeroes are trimmed off for comparison,
  but then compare cannot handle processing the solitary decimal
  point.
  
  
  The following does not result in an error:
  
  Column definitions:
  
  DECIMAL(5, 1) NOT NULL,
  TIMESTAMP (6) WITHOUT TIME ZONE NOT NULL,
  
  Example Partition:
  
  PARTITION 3 ENDING AT (00000.1, '2009-12-31-24.00.00.000000'),
  
  Compare can handle the remaining .1
  
  
  Keywords:  msgadb7383e
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Object Comparison Tool for      *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Appending partitions to a table by      *
  *                      using Object Compare might result in    *
  *                      ADB7383E.                               *
  ****************************************************************
  When using Object Compare to append a partition to a table, the
  compare might fail if the specified value is a decimal with
  leading zeroes, for example:
  
  PARTITION 40 ENDING AT (00000., '2012-07-10-24.00.00.000000')
  
  Example error message:
  ADB7383E ADB2CMT
  A severe error occurred when processing the specified limit key
  for table >schema<.>table<. Wrong input parameters in column
  <column_name>.
  

Problem conclusion

• The problem has been resolved.
  
  Search keywords: MSGADB7383 MSGADB7383E
  

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:

  UI74740

Modules/Macros

• ADB2CM3
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI74740

     UP21/05/03 P F104

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.