PI85825: DDL OR GEN LINE COMMAND GENERATES ACCELERATOR TABLE DDL WHICH MAY RESULT IN SQLCODE -4747 WHEN EXECUTED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Accelerator Table DDL generated by the DDL or GEN line command
  may have 'WITH DEFAULT'  in the column definition.  This option
  is not allowed in Accelerator tables, and attempting to execute
  the DDL will cause the following error message:
  
  DSNT408I SQLCODE = -4747, ERROR: THE CREATE OR ALTER TABLE
  STATEMENT FAILED BECAUSE SOME FUNCTIONALITY WAS SPECIFIED IN
  THE TABLE DEFINITION THAT IS NOT SUPPORTED WITH THE TABLE TYPE.
  UNSUPPORTED FUNCTIONALITY:   DEFAULT
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use the DDL or GEN line         *
  *                 command to generate DDL.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Executing 'Create Table' from DDL       *
  *                      generated by DDL or GEN line            *
  *                      command for Accelerator Only Table      *
  *                      may result in SQLCODE -4747 /           *
  *                      SQLCODEN4747.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DDL for an Accelerator Only Table (AOT) generated by
  DDL or GEN may contain 'WITH DEFAULT' in the column
  definition. This option is not allowed in AOT. Executing
  the DDL may cause the following error message:
  
  DSNT408I SQLCODE=-4747, ERROR: THE CREATE OR
  ALTER TABLE STATEMENT FAILED BECAUSE SOME
  FUNCTIONALITY WAS SPECIFIED IN THE TABLE
  DEFINITION THAT IS NOT SUPPORTED WITH THE
  TABLE TYPE. UNSUPPORTED FUNCTIONALITY:
  DEFAULT
  

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:

Modules/Macros

•    ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI51740

     UP17/11/11 P F711

• RC10 PSY UI51741

     UP17/11/09 P F711

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.