PI53163: MEMBER CLUSTER SYNTAX MISSING FROM DDL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS produces DDL which is
  missing the MEMBER CLUSTER syntax.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and DB2 Object Comparison           *
  *                 Tool for z/OS who use DB2 for z/OS           *
  *                 in New Function mode, and the                *
  *                 value for parameter NEWFUN in                *
  *                 DSNHDECP is a lower version of               *
  *                 DB2.                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: When importing a change from DDL,       *
  *                      or the compare source is DDL,           *
  *                      the specifications available            *
  *                      only in DB2 New Function mode           *
  *                      in the SQL statements in the DDL        *
  *                      are missing in the job to run           *
  *                      or apply the change.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When importing a change from DDL, or comparing a source from
  DDL, the specifications available only in DB2 New Function
  mode in the SQL statements in the DDL are missing in the job
  to run or apply the change.
  
  For example,
  When DB2 for z/OS is version 10 in New Function mode,
  and the value for parameter NEWFUN in DSNHDECP
  is V9, if there is 'MEMBER CLUSTER' in the CREATE
  TABLESPACE statement, then import a change from the
  DDL, or compare the source DDL, the 'MEMBER CLUSTER'
  keyword is missing in the job to run or apply the
  change.
  

Problem conclusion

• Problem has been solved.
  
  Additionally, on panel ADB2PCO 'Options for Change Functions',
  a new field 'DB2 release number' is added for users to input
  the DB2 release number to indicate whether DB2 is new function
  mode or not when the compare source is DDL.
  

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:

  UI37641 UI37642

Modules/Macros

•    ADBCCM   ADBCDTS  ADBCDTW  ADBCMPC  ADBCRCA
  ADBCRCM  ADBCVEY  ADBHPCO  ADB2CID  ADB2PCO
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI37641

     UP16/05/12 P F605

• RB20 PSY UI37642

     UP16/05/12 P F605

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.