PH35869: POOR PERFORMANCE USING INFORMIX DATA SERVER SCHEMA LOAD WITH DATA SAMPLING ON COGNOS ANALYTICS 11.1.

APAR status

• Closed as Permanent restriction.

Error description

• Poor performance using Informix Data Server Schema load with
  data sampling on Cognos Analytics 11.1.x with ?NO SELECT
  permission on X? objects
  
  Workaround
  
  Option 1
  
  Use Load options > Tables to select specific View objects only.
  Do not generate metadata schema import and data sampling on
  Table objects which have NO SELECT access on the ?rpt_usr?
  Informix user logon.
  
  Option 2
  
  Un-select the Load options > Retrieve sample data prior to
  loading of schema metadata import for the schema
  
  However, with no data sampling loose the functionality on the
  underlying data for the Cognos AI engine to learn about the
  data, perform SMART logic to automate and suggest better
  exploration visualizations to end user.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * n/a                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * see formal description                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• A fix will not be provided for this issue. If you find it exists
  in a current release of our software and would like
  re-evaluation, please contact Technical Support
  

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

Applicable component levels