The error message return states that the StrataFrame app framework is looking for SYSTABLES. Our DBA's indicate that SYSTABLES do not exist on Mainframe versions of DB2 databases but do exist on Linux\Unix\Windows versions of the DB2 database. However, we are working with the Mainframe version of the database.

Hi Ben,

Which version of the IBM Data Provider does the Business Object Mapper use when the DB2 structure is selected?

Thanks,

Alan

We have fixed this issue. The connect string in the Business Object Mapper for the DB2 stucture needs to be of the following format:

Database=DSNT;User ID=USER;Password=Pwd;Server=HOST;SysSchema=SYSIBM;SchemaList=Schema

Excellent.  That format is good to know. 

FYI, when the BOMapper tries to enumerate the tables, it pulls the provider by the IBM.Data.DB2 name, so whatever ADO.NET provider is registered under that name will be used.  For instance, the client that I installed installed IBM.Data.DB2 and IBM.Data.DB2.9.1.2.  We use the IBM.Data.DB2 because according to the ADO.NET provider documentation, it will be installed with all versions of the client because it's the version-independent version of the provider.  So, we just pull the factory by name and use it.