Reports not working on Db2 in a sharded environment

About this task

If your user name is not the same as your schema, reports may not work properly.

Procedure

  1. In the Framework Manager, open the model provided in the <ANALYTICS_HOME>/Model directory.
  2. Edit the problem data source and set the Schema in the data source.
  3. Edit each problem query subject in the Database Layer without making changes, and click OK. You can test the query subject to determine if there is a problem.
  4. Save the model.
  5. Remove the schema from the data sources. You may choose to test some of the problem query subjects to ensure that there are no issues.
  6. Publish the package and overwrite the existing package.
  7. Save the model.