PK15580: ADMIN GEN COMMAND DOES NOT INCLUDE PRIQTY SYNTAX IN DDL FOR DEFI NE NO INDEX WHEN ALLOC TS SIZE OPTION USED SPECIFIED ON ADB2GEN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration GEN command omits the PRIQTY syntax for
  the generated DDL when 'Alloc TS size as' USED is specified on
  panel ADB2GEN for an index defined as DEFINE NO.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who  run   *
  *                 GEN CREATE INDEX and/or CREATE TABLE which   *
  *                 are specified with DEFINE NO, are affected.  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The GEN command omits the PRIQTY syntax *
  *                      for  the  generated  DDL when 'Alloc TS *
  *                      size as'  USED  is specified on ADB2GEN *
  *                      panel for an index defined as DEFINE NO *
  *                      .*                                      *
  *                      GEN  was  not  providing a PRIQTY value *
  *                      for CREATE INDEX  and CREATE TABLESPACE *
  *                      when they are specified with DEFINE NO, *
  *                      SPALLOC = USED and no space allocations *
  *                      have been made.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• ADB2REG has been changed to correct the problem.
  

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.