PH40076: SUPPORT ADDITIONAL CREATE TABLE CLAUSES FOR IMPLICIT TABLESPACES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR adds support for additional CREATE TABLE clauses for
  implicitly created tablespaces.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for         *
  *                 z/OS and Db2 Object Comparison Tool for      *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides enhancements to      *
  *                      support additional CREATE TABLE         *
  *                      clauses for implicitly created table    *
  *                      spaces.                                 *
  ****************************************************************
  The following options are supported for CREATE TABLE when
  the table space is implicitly created:
  1. BUFFERPOOL
  2. DSSIZE
  3. MEMBER CLUSTER
  4. TRACKMOD
  5. COMPRESS
  The subsystem parameter values for TRACKMOD and COMPRESS
  are also supported.
  
  The affected components are as follows:
  1. GEN:
  New CREATE TABLE options are generated when the associated
  table space is implicit.
  
  2. DDL Reader:
  The DDL Reader supports the new CREATE TABLE options.
  
  3. Compare:
  New CREATE TABLE options are supported during object
  comparison, and ADMIN ALTER TABLESPACE statements are
  generated for implicitly created table spaces.
  
  Object Compare now supports ADMIN ALTER TABLESPACE ..MEMBER
  CLUSTER statements on implicit table spaces.
  Object Compare supports the TRACKMOD attribute at the
  table space level.
  Compare also supports the subsystem parameter value for the
  TRACKMOD attribute.
  
  4. Panels:
  The options are visible on the CREATE TABLE panels
  ADB26CT and ADB26TOP.
  

Problem conclusion

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:

  UI77359

Modules/Macros

• ADB26CTF ADB26CTS ADB26TOP ADB2CDC  ADB2CM1  ADB2CM2  ADB2CM3
  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT
  ADB2CMU  ADB2DEP  ADB2MSK  ADB2PA   ADB2RE   ADB2REE  ADB2REG
  ADB2REH  ADB2REM  ADB2REP  ADB2RER  ADB2RES  ADB2RET  ADB2REU
  ADB2REY  ADB2REZ  ADB2RGC  ADB2RPT  ADB2WCL  ADB7000  ADBALT
  ADBCCM   ADBCCME  ADBCCMM  ADBCDTS  ADBCP    ADBCVCT  ADBCVEY
  ADBCVIC  ADBCVOC  ADBGDDL  ADBH6CTS ADBH6TOP ADBVFC   ADBVFCA
  ADBVFCF  ADBVVFG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI77359

     UP21/10/01 P F109

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.