JR45533: IMPORTING MATERIALIZED VIEWS IF THE 'INCLUDE VIEWS' CHECKBOX IS ENABLED IN IMAM

APAR status

• Closed as program error.

Error description

• Importing materialized views  if the 'Include views' checkbox
  is enabled in the Oracle Connector of InfoSphere Metadata Asset
  Manager
  

Local fix

• Use Datastage Connector Metadata Import to import Oracle
  Materialized View
  

Problem summary

• Cannot import materialized views usimg InfoSphere Metadata Asset
  Manager with Oracle Connector.
  

Problem conclusion

• InfoSphere Metadata Asset Manager does not set the property that
  tells Oracle Connector whether to include materialized views or
  not. Long term correct solution is for IMAM to add a checkbox
  for materialized views and set the property accordingly. Oracle
  Connector will be fixed such that if there is no value for the
  include materialized views property, it will take on the value
  of the include views property (instead of the current default of
  FALSE).
  

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:

Fix information

• Fixed component name

  METADATA WORKBE

• Fixed component ID

  5724S4100

Applicable component levels

• R870 PSY

     UP