Unable to reverse engineer DB2 tables to UML

[Sekhar]

In the "Import DB schema from ODBC source" window, upon clicking the [...], in the following popup under the "Machine Data Source" tab, I am able to see my DB2 database. I select it and click OK, and in the following window if I enter the username and password and hit OK, I get "Unable to obtain table information" message.

We are using the IBM DB2 ODBC Driver.

In the "Open Project" window, after checking the 'Connect to server' box and hitting on the [...], the Data Link Properties window comes up. On this under the Provider tab, should I be selecting the 'IBM OLE DB Provider for DB2' or the 'Microsoft OLE DB Provider for ODBC Drivers' ?

If I pick the 'IBM OLE DB Provider for DB2', under the 'Connection' tab the Datasource dropdown is disabled.

If I pick 'Microsoft OLE DB Provider for ODBC Drivers' I am able to see my DB2 database under the Datasource name dropdown.
I pick my database, enter username and password, and hit TestConnection, I get an error saying 'Test connection failed because of an error in initializing provider. [IBM][CLI Driver] SQL1039C  An I/O error occurred while accessing the database directory.  SQLSTATE=58031'. If I still go ahead and click on 'OK', then the message is 'Invalid datasource check configuration'

Using TOAD for DB2 I am able to connect to the database perfectly fine with the same username and password.

Please advise a solution.

[Geert Bellekens]

Sekhar,

First of all, the "open project" window is only for opening EA models, that might have been saved to a database server, so don't bother trying that to reverse engineer a database.

The first option you tried seems to be the correct one. There are two possible problems I see:
- You haven't used the correct ODBC driver for DB2 (EA is rather picky as to which driver you use)
- Your user doesn't have enough rights to be able to reverse engineer the database. (try with the admin/owner user to be sure)

Geert

[Sekhar]

Geert,

Actually my DB2 install itself was not properly done. I reinstalled and with an upgraded verison for the client. Now the same driver did work  when I connected from EA and was successful in reverse engineering the tables to UML elements.

Thanx !