PM45653: ANALYZE FAILS WHEN CHANGE FOUND IN INDEX CHANGE FROM TYPE 2 TO PARTITIONING RC=12 MSGADB3009E 11/08/12 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Object Comparison Tool for z/OS, when Analyzing a
  change where INDEX changes from Type 2 to Partitioning, and
  VALIDATE WSL = Y, then failure may occur resulting in RC=12.
  Failure message:
  ADB3009E Error processing Index ixowner.ixname in CREATE
  statement: Number of index partitions does not match the
  number of table space partitions.
  .
  Additional Symptoms: rc12 msgADB009E
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 the DB2 Object Comparison Tool for z/OS      *
  *                 who compare a source object that has more    *
  *                 partitions than a target object, and who     *
  *                 run Validate Work Statement ( WSL ) either   *
  *                 by specifying 'Validate WSL = 'YES' on       *
  *                 panel ADB2C11A 'Generate Analyze Job'        *
  *                 while analyzing a change, or by using the    *
  *                 'V' line command on panel ADB2W1 'Work       *
  *                 Statement List'. Users who run the DB2       *
  *                 Object Compare Tool and specify 'Run         *
  *                 Validate' = 'V' on panel GOC5 'Generate      *
  *                 Compare Jobs' are also affected.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      Validate Work statement List (WSL)      *
  *                      function incorrectly issues a message:  *
  *                                                              *
  *                      "ADB3009E Error processing Index        *
  *                      in CREATE statement: Number of index    *
  *                      partitions does not match the number of *
  *                      table space partitions."                *
  *                                                              *
  *                      The WSLVALn Validate step fails with a  *
  *                      return code 8 / RC=8.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS Validate Work statement
  List ( WSL ) function incorrectly issues a message ADB3009E
  because it does not correctly parse the ALTER TABLE ... ADD
  PARTITION statements.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK72496 UK72497

Modules/Macros

•    ADB2DEP  ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK72496

     UP11/10/05 P F110

• R720 PSY UK72497

     UP11/10/05 P F110

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.