This content has been marked as final. Show 6 replies
it's possible to import from IBM DB2/LUW version 9 database even with DM 3.1 - you need to add proper JDBC driver, and UDB tab will appear in connection dialog.
There is more support for DB2/LUW 9 in DM 3.3 - new data types are supported and you can create UDB 9 physical model. Please pay attention to following 3.3 release notes:
You need to copy types.xml and defaultRDBMSSites.xml files from datamodeler\datamodeler\types directory to directory set as default system types directory in preferences when preferences are migrated from earlier version.Philip
I had set up the JDBC driver and licence which is how I was able to connect to the box in the first place and view the objects in the wizard. The point you said I needed to ‘pay attention to’ regarding the types was irrelevant to me since I was previously using a 3.1.4 and the files in 3.3 are more up-to-date.
The one thing you mentioned in your reply that made me look at this differently was using the UDB tab and not the DB2 tab. It did not occur to me that this was a connection option since as far as I was concerned I was connecting to a DB2 database (what the heck is UDB anyway? - answer not expected). This is important for anyone else who wants to do this. After I had loaded the JDBC driver and licence both a DB2 AND a UDB tab appear in the connection list. I now understand there is a difference between actual IBM mainframe data dictionaries and mid-range UNIX based DB2 systems. Whichever you have depends on which of these connectors you use. When I connected using the DB2 tab (the database I was told we have) it did show me all of the objects but would not reverse engineer anything. However, if I now use the UDB tab instead it also sees the objects and more importantly solves the problem and successfully reverse engineers objects.
So, thanks for mentioning the UDB tab.
Edited by: tyroneward on Nov 23, 2012 1:15 PM
I now understand there is a difference between actual IBM mainframe data dictionaries and mid-range UNIX based DB2 systemsIt's not only in data dictionary.
what the heck is UDB anyway? - answer not expectedIt's interesting how things evolve - at version 7 there were:
- IBM DB2 Universal Database
- DB2 Universal Database for OS/390 and z/OS
now they are (at version 9/10):
- DB2 Version 9 for Linux, Unix ans Windows
- DB2 10 for z/OS
They are not any more Universal - we should change something.
The log is clear. I've had a chat with someone who has tried something similar with a different tool previously and eventually had to hand join the relationships in the model. Something to do with the ANSI standards not being used to create the joins in the DB2 database in the first place, apparently. I'll do some more digging.