PH66938: Unable to handle multiple partition keys.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. During component installation the product creates an invalid
  SQL ALTER TABLE statement. This occurs during GENERATE
     PARTITIONING process and resulted in SQL errors or
     DRL0046E messages.
  
  2. Support 22nd century in 0CYYDDDF date format.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All IBM Z Decision Support 1.9.0 and IBM Z   *
  *                 Performance and Capacity Analytics 3.1.0     *
  *                 users.                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Component installation process       *
  *                         output shows the following errors:   *
  *                         A. DSNT408I SQLCODE = -104, ERROR:   *
  *                            ILLEGAL SYMBOL "') INCLUSIVE,     *
  *                            PARTITION 7 ENDING AT ('". SOME   *
  *                            SYMBOLS THAT MIGHT BE LEGAL ARE:  *
  *                            , ) .                             *
  *                         B. DRL0046E The string starting with *
  *                            'x too long. The maximum length   *
  *                            is 254 bytes.                     *
  *                      2. Unable to process DATE(OCYYDDDF)     *
  *                         field containing 22nd century value. *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF(s).                   *
  ****************************************************************
  1. Generate Partitioning statement is unable to handle multiple
     partition keys.
  2. DATE(0CYYDDDF) date format does not handle '2' in the 'C'
     field.
  

Problem conclusion

• 1. DB2 ALTER statement generation is modified to support
     multiple partition keys.
  2. DATE(0CYYDDDF) date format processing is modified to support
     22nd century value.
  

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:

  UO04308 UO04309

Modules/Macros

• DRLPPGEN DRLPTDCD DRLTKEYS
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• R901 PSY UO04309

     UP25/08/30 P F508

• RC01 PSY UO04308

     UP25/08/30 P F508

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.