PI65581: DB2 ADMIN TOOL - DDL LINE COMMAND ISSUE WHEN COLUMN DEFINED WITHGENERATE ALWAYS AS (DATA OPERATION)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A column defined with "GENERATE ALWAYS AS (DATA OPERATION),
  using the DDL line command, it is not picking up the
  GENERATE ALWAYS option.
  
  DDL that was used to create:
  DEN_BEN_DCOP         CHAR(1) NOT NULL
  GENERATED ALWAYS AS (DATA CHANGE OPERATION),
  
  DDL generate from DB2 Admin Tools [DDL line command]:
  DEN_BEN_DCOP         CHAR(1) FOR SBCS DATA ,
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Admin Tool line command DDL does    *
  *                      not generate the 'GENERATED ALWAYS'     *
  *                      option.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Admin Tool line command DDL does not generate the
  'GENERATED ALWAYS' option on a table that is defined
  with 'GENERATE ALWAYS AS (DATA OPERATION)'.
  
  DDL that was used to create:
  DEN_BEN_DCOP    CHAR(1) NOT NULL
                  GENERATED ALWAYS AS (DATA CHANGE OPERATION),
  
  DDL generated from DB2 Admin Tool:
  DEN_BEN_DCOP    CHAR(1) FOR SBCS DATA ,
  

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:

  UI44353

Modules/Macros

•    ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI44353

     UP17/02/23 P F702

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.