Hi - I've added a datasource in Cognos and set it to use a password. I can connect to the DB2 database outside of cognos using this userid/password combo, and can select from objects within a given schema (does not match the userid), so the privs are set correctly in DB2. However, when I go to run the metadata wizard in framework manager, I am not able to see the given schema, although I can see other schemas in the database.
I've tried dropping and recreating the datasource, but this doesn't help.
Is there something I can do to refresh the list of schemas visible in a specific datasource connection?
TIA!