Cannot see DB Views in Fact Build Wizard

[pr0ph3t]

I'm using Data Manager 10.2 against DB2 databases (source and destination). I'm trying to use the Fact Build Wizard and I'm on the Data Source Wizard screen. I see all my schemas and regular tables, but I cannot see my views or the schemas for those views. Does anyone know how to make database views show up? I know I've gotten this to work before. I'm wondering if maybe it was in an earlier version of Data Manager.

Even if I go into Tools-->SQLTerm and choose my database, I can see no views (or their schemas) listed. Just regular tables.

[pr0ph3t]

OK...more information. I can in fact see some views. What's happenings is if a schema only contains views and/or nicknames, but no regular tables, the schema does not show up in Data Manager. Therefore you cannot select the views for use. If a schema contains a mix of regular tables and views it will show up. You can then drill-down into the schema and choose your table or view. So the key is that the schema in question contains no regular tables. This renders it invisible.

I seem to recall a similar problem with Framework Manager some time back. I believe the solution was to edit a file that controlled the system tables that were queried and how they were queried to construct the list of schemas and tables. Does anyone know how to do this for Data Manager?

[MFGF]

Firstly, are you sure it's not just a permissions issue? Does your database login definitely have access to see the schemas containing the views?

I'd be very careful if you're considering editing any of the ini files. If you're using DB2, I suspect the file is cogdmd2.ini but I wouldn't know where to start editing it. Normally those kinds of changes are done under explicit instruction from IBM support guys.

Good luck!

MF.

[pr0ph3t]

Yes, I definitely have permissions. And cogdmd2.ini is the one I was looking at. I remember I had this problem with UDFs not showing up in Framework Manager. I had to edit a .ini file then, too. It was fixed in a later version.