PK10287: DDL GEN AND AL PROBLEMS WITH PRIQTY OR SECQTY ON TABLE BASED PARTITIONED INDEX

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool line commands DDL GEN and AL are
  not handling PRIQTY and SECQTY properly for table based
  partitioned index when PRIQTY and/or SECQTY values differ
  from first partition values. PRIQTY values are either omitted
  or only the first partition values are reported.
  .
  Additional symptoms: primary secondary quantity pqty sqty
    partitioning indexes negative one -1 value
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who use    *
  *                 ADB2GEN  to  generate DDL for PARTITIONED    *
  *                 indexes, are affected.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Line commands  DDL GEN  and AL are not  *
  *                      handling PRIQTY  and  SECQTY  properly  *
  *                      for table based partitioned index when  *
  *                      PRIQTY  and/or  SECQTY  values  differ  *
  *                      from  first  partition  values. PRIQTY  *
  *                      values  are either omitted or only the  *
  *                      first  partition  values are reported.  *
  *                      .*                                      *
  *                      Currently,  GEN  does not generate the  *
  *                      PARTITION BY  clause  for  partitioned  *
  *                      indexes when  the PARTITIONED  keyword  *
  *                      is specified.  While the VALUES clause  *
  *                      (ENDING AT clause)  is  not  valid  in  *
  *                      these   cases,   other  parts  of  the  *
  *                      PARTITION BY clause are valid.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• ADB2REG has been changed so that the valid clauses are
  generated for PARTITIONED tables. Apply the fix.
  

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

•    ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK10136

     UP05/12/23 P F512

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.