PI53030: UTS CREATE TABLE FAILS WITH SQLCODEN763/SQLSTATE 560A1

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS created incorrect
  DDL for a CREATE TABLE resulting in a SQLCODEN763 / SQLCODE -763
  error.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who compare tablespaces and         *
  *                 tables where the source tablespace is        *
  *                 a UTS Partition-By-Growth (PBG) tablespace,  *
  *                 the target tablespace is segmented, and      *
  *                 the compared tables need to be dropped       *
  *                 and created.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare created incorrect        *
  *                      DDL for a CREATE TABLE resulting        *
  *                      in a SQLCODEN763 / SQLCODE=-763         *
  *                      error:                                  *
  *                                                              *
  *                      DSNT408I SQLCODE = -763, ERROR:         *
  *                      INVALID TABLE SPACE NAME                *
  *                      >ts_name<                               *
  *                      DSNT418I SQLSTATE = 560A1               *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      The generated DDL contains a            *
  *                      'PARTITION BY SIZE' clause.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Object compare generates invalid DDL for the CREATE TABLE
  statement.
  
  .
  

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:

  UI34946 UI34947 UI34948

Modules/Macros

•    ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI34946

     UP16/02/04 P F602

• RB10 PSY UI34947

     UP16/02/04 P F602

• RB20 PSY UI34948

     UP16/02/04 P F602

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.