PI77310: ALLOW A USER TO EXPLICITLY DEFINE A HIDDEN ROWID COLUMN.

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• Allow a user to explicitly define a hidden ROWID column.
  Enablement code.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * DB2 12 for z/OS users of ROWID columns                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * There is a need to allow users to explicitly define a hidden *
  * ROWID column.                                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  DB2 implicitly generates a hidden ROWID column when a table is
  created with a LOB column or altered to add a LOB column and the
  user does not explicitly define a ROWID column. The advantage of
  a hidden (ROWID) column is that such a column is not included
  when an application uses the SELECT * construct.
  
  Currently, users cannot explicitly define a hidden ROWID column.
  Any attempt to explicitly define a hidden ROWID column (using
  the IMPLICITLY HIDDEN clause) will return SQLCODE -270. This
  limitation makes it impossible to use a ROWID column and hide it
  from applications when no LOBs are involved. A possible use case
  could be to use a ROWID column as a partitioning column to
  spread inserts across partitions and hide it to minimize the
  impact on (existing) applications.
  

Problem conclusion

• PI77310 enables function to allow users to explicitly define a
  hidden ROWID column with a CREATE TABLE statement. Enabling APAR
  PI77310 requires pre-conditioning APAR PI76972 to be applied to
  all members of a data sharing group prior to PI77310's
  application. In a coexistence environment, this APAR also
  requires DB2 11 pre-conditioning APAR PI77718 to be applied to
  all DB2 11 members prior to PI77310's application.
  
  External changes include, but are not limited to:
  - CREATE TABLE processing will be modified to allow specifying
  the IMPLICITLY HIDDEN clause for ROWID columns.
  - ALTER TABLE processing will be modified to support dropping an
  explicitly defined hidden ROWID column under specific
  conditions.
  - The SYSIBM.SYSCOLUMNS.HIDDEN column will be populated with a
  value of 'R' to indicate ROWID columns that were explicitly
  defined with the IMPLICITLY HIDDEN attribute.
  
  PI77719 is the DB2 11 version of this APAR.
  
  PI77302 is a related APAR that is recommended for users of
  metadata stored procedures SYSIBM.SQLPSEUDOCOLUMNS and
  SYSIBM.SQLSPECIALCOLUMNS. It updates the stored procedures to
  include support for explicitly defined hidden ROWID columns.
  Refer to PI77302's description for more information.
  
  Additional Keywords:
  SQLCREATE
  

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:

  UI47249

Modules/Macros

• DSNXICB3
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI47249

     UP17/06/01 P F705

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.