PM76070: GEN PANEL ADB2GEN FIELD 'TARGET DB2 VERSION' SQLCODEN628 THE CLAUSES ARE MUTUALLY EXCLUSIVE SEGSIZE PARTITION UTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS panel ADB2GEN 'Generate SQL
  from DB2 catalog' field 'Target DB2 version' does not effect
  the DDL produced by the GEN function resulting in a SQLCODE -628
  when the DDL is executed on the target DB2 version:
  
  DSNT408I SQLCODE = -628, ERROR:  THE CLAUSES ARE MUTUALLY
  EXCLUSIVE
  DSNT418I SQLSTATE   = 42613 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXICTS SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 130  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'00000082'  X'00000000'  X'00000000'
  X'FFFFFFFF'
           X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) function     *
  *                 on a partitioned-by-range (PBR) table        *
  *                 space, then specify a field 'Target DB2      *
  *                 version' for a DB2 version which does not    *
  *                 support PBR table space on panel ADB2GEN     *
  *                 'Generate SQL from DB2 catalog'.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      panel ADB2GEN field 'Target DB2         *
  *                      version' does not affect the DDL        *
  *                      produced by the GEN function            *
  *                      resulting in a SQLCODE=-628 /           *
  *                      SQLCODEN628 when the DDL is             *
  *                      executed on the target DB2              *
  *                      version:                                *
  *                                                              *
  *                      DSNT408I SQLCODE = -628,                *
  *                      ERROR:  THE CLAUSES ARE                 *
  *                      MUTUALLY EXCLUSIVE                      *
  *                      DSNT418I SQLSTATE   = 42613             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  GEN generates both NUMPARTS and SEGSIZE keywords which causes a
  SQLCODEN628 / SQLCODE=-628 error when executing the DDL on the
  DB2 version which does not support the PBR table space type.
  

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:

  UK90400

Modules/Macros

•    ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK90400

     UP12/12/19 P F212

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.