I'm trying to use 'JPA Reverse Engineering' on a very small table (< 10 fields) in a DB2 v8 database running on z/OS.

It works, but it takes about 15 minutes to finish.

In my experience this type of action completes almost instantly, so I was wondering if there are any known compatibility issues with DB2 v8 on z/OS?

-Jeff

itchyjim ,

1) Which version of MyEclipse are you working with ? Paste your Build Id here from Help > About MyEclipse Enterprise Workbench > Build Id.

2) Do you see the same issue when working with DB2 from outside the IDE ?

3) Is your workspace very large?

4) Check this link for the Performance issues in DB2 V8:
http://www.craigsmullins.com/zjdp_018.htm

Thanks for the reply.

1) Build id: 8.5-20100319

2) I don't see this issue outside the IDE. There's no delay when I view tables through the IBM DB2 command line tools. That said, myEclipse also loads the tables without delay. It's only slow on certain operations, like reverse engineering and retrieving the table info (i.e foreign keys). As a test I tried viewing a table's foreign keys via DB2's command editor and didn't run into any issues.

3) My workspace is about 50MB. I have other connections to local db2 instances (running on windows) in the same workspace. I'm able to run JPA reverse engineering against those without issue, so that would lead me to guess that workspace is fine.

4) Thanks for the link. I read it over but nothing jumped out at me. I've asked the DBAs to monitor the DB2 instance during my attempts at JPA reverse engineering. They didn't see anything abnormal, but maybe I should try to pursue that further.

Thanks again,

-Jeff

Further to my last post. It seems there's an issue when myEclipse tries to execute the DB2PKG( DB2LIC.SYSLIC ).

I understand DB2LIC is a function/command for DB2 on the Unix side and doesn't exist on z/OS.

Should I be looking for different drivers at this point? Or are there configuration options through myEclipse that allow me to indicate which OS I'm using.

Thanks again,

-Jeff

itchyjim ,

Thank you for your findings. I have escalated it to the dev team.
They will get back to you. Sorry for the inconvenience caused.

Jeff,

We don't have a z/OS environment on which to test this but I did perform a JPA reverse engineering on the DB2 SAMPLE database, with DB2 running on Windows XP and MyEclipse running on Linux. I also tried from a Windows 7 machine. It was a swift operation in both cases.

I used the com.ibm.db2.jcc.DB2Driver JDBC driver.