PH55592: Import DDL to recreate a table without CREATE TS should have error message to include TS in DDL.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• For FL506 and higher, the user should include CREATE TABLESPACE
  statement in the DDL if a table is recreated using a DROP TABLE
  statement via Change management Import. If the user fails to
  include the tablespace in the DDL, Admin tool should provide an
  error message that the tablespace is missing.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who import DDL                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: If imported DDL is attempting a DROP    *
  *                      TABLE operation followed by a CREATE    *
  *                      TABLE operation for APPLCOMPAT V12R1506 *
  *                      or higher, but it does not include the  *
  *                      parent table space, the import should   *
  *                      not be valid.                           *
  ****************************************************************
  When using change management to import DDL that has a DROP TABLE
  statement followed by a CREATE TABLE statement on
  APPLCOMPAT V12R1506 or higher, Db2 Admin tool should return an
  error and tell the user to include the CREATE TABLESPACE
  statement for the parent table space. This requirement is
  because DROP TABLE on FL 506 or higher implicitly drops the
  parent table space.
  
  ADB8074E Parent table space @DB2IVPA.SREFGE61 not found.
  Please include CREATE TABLESPACE statement.
  Table space is required to create table. Table space may be
  implicitly dropped via a DROP TABLE statement and not recreated.
  

Problem conclusion

• The current behavior has been addressed.
  

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:

  UI94026 UI94027

Modules/Macros

• ADB8000  ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI94026

     UP23/10/18 P F310

• RD10 PSY UI94027

     UP23/10/18 P F310

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.