PI94255: DB2 ADMIN TOOL - WSL DOES NOT RECREATE THE LOB TABLE SPACES, REPORTS LOB TABLESPACE "NOT ADDED"

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Importing DDL script that drops existing base and aux table
  spaces resulting WSL does not recreate the LOB table spaces,
  reports LOB tablespace "Not added". The WSL fails with SQL -204,
  saying the LOB TABLESPACE the CREATE AUX TABLE statement refers
  to does not exist.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 and DB2 Object Comparison Tool for z/OS who  *
  *                 use Change Management function to Import     *
  *                 and Analyze a change.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A WSL does not recreate the LOB table   *
  *                      spaces, which causes the WSL execution  *
  *                      to fail with RC08 and SQLCODE=-204 /    *
  *                      SQLCODEN204.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Importing a DDL script that drops existing base and aux table
  spaces and then recreates the table spaces and tables (with LOB
  columns).
  
  The resulting WSL does not recreate the LOB table spaces, which
  causes the WSL execution to fail with RC08 and SQLCODE=-204.
  
  The LOB table spaces are marked "Not added" in the Comparison
  Summary Report.
  

Problem conclusion

• The 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:

  UI55509 UI55510

Modules/Macros

•    ADB2CMP  ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI55509

     UP18/04/30 P F804

• RC10 PSY UI55510

     UP18/04/28 P F804

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.