PK70536: WSLVAL ADB3009E ERROR PROCESSING INDEX <NAME> IN CREATE STATEMENT NUMBER OF INDEX PARTITIONS DOES NOT MATCH TABLE SPACE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool WSL Validate function issues the
  following message in error:
  ADB3009E Error processing Index OA1A.IDG302A1 in CREATE
  statement: Number of index partitions does not match the number
  of table space partitions.
  and end RC=08
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Admin and Object Compare Ver 7.2    *
  *                 using validation  when comments or labels    *
  *                 on tables included in SQL statements.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Validation message ADB3009E about index *
  *                      and the table space  partition mismatch *
  *                      generated  when index  partitions match *
  *                      the table space partitions.             *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Validation  message ADB3009E about index and table space
  partition mismatch generated when index partitions match
  the table space partitions.
  

Problem conclusion

• The problem has been fixed in v7.2.
  

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

•    ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK40537

     UP08/10/16 P F810

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.