INCLUDE column(s) are missing in DDL of an index.

Article Id: 33235

Status: Published

Updated On: 14-02-2018 08:21

Legacy Id: TEC1671742

Products:

CA RC/Migrator , CA Endevor SCM Interface , DB2 Administration , CA RC Compare for DB2 for z/OS , CA RC Extract for DB2 for z/OS , CA RC/Query , CA RC Secure for DB2 for z/OS , CA RC Update for DB2 for z/OS

Issue/Introduction:

Problem:

The DDL command for an 'Include Index' generates DDL without INCLUDE columns. This occurs with DB2 11 CM.

Resolution:

This happens if option RCQ_OFS(NO) is specified in the ENABLExx CDBAPARM member.

Delete the line with this entry.

Object Framework Services (OFS) is a services layer that is used to perform DB2 system catalog access.

We recommend not disabling OFS as many features are only supported with OFS.

Environment:

Release:
Component: RCQ