PH32744: GEN/DDL NO 'IMPLICITLY HIDDEN' FOR ROWID COLUMN; INTERPRET ROWID COLUMN 'R' NOT TRANSLATED; COMPARE CHANGE ':NOT HIDDEN'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses 4 issues related to columns defined as
  ROWID and IMPLICITLY HIDDEN:
  
  1) GEN/DDL does not generate an IMPLICITLY HIDDEN clause for
  the column.
  
  2) When interpreting an IMPLICITLY HIDDEN column (line
  command 'I' on panel ADB21TC), the field 'Hidden from SELECT *'
  translates SYSCOLUMN values P and N to YES and NO
  respectively, but does not translate value R to YES.
  
  3) When Object Compare processes two tables containing a ROWID
  column with an IMPLICITLY HIDDEN clause, a change is incorrectly
  reported:
  
  
  Column >columnname<
  
  
  (D)Hidden value changed from : not hidden to : not hidden
  Tables have identical column lists
  Table >tablename< is partitioned and will be dropped by
  dropping tablespace >tablename<
  Table will be recreated
  
  With this APAR applied, the change will not be reported.
  
  4) An incorrect internal value is assigned to the version file,
  which might lead to incorrect comparisons when the target or
  source is DDL.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and Db2 Object Comparison Tool for      *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Various problems occur for table        *
  *                      columns that are defined as ROWID and   *
  *                      IMPLICITLY HIDDEN.                      *
  ****************************************************************
  This APAR addresses the following issues when a table column
  is defined as ROWID and IMPLICITLY HIDDEN:
  
  1) The GEN function does not produce the IMPLICITLY HIDDEN
  clause when
     generating the DDL for the table.
  2) Panel ADB21CI1, which displays column information, does
     not display YES for the field "Hidden from SELECT * :'
  3) The compare function reports a change when both source and
     target columns
     are defined as ROWID and IMPLICITLY HIDDEN in the catalog.
  4) The DDL Reader assigns an incorrect value for the version
     file, which might lead to incorrect comparisons when the
     source or target is DDL.
  

Problem conclusion

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

  UI74385

Modules/Macros

• ADB21CI1 ADB2CMT  ADB2CMU  ADB2REG  ADBCDTS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI74385

     UP21/03/16 P F103

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.