We have the following situation here:
The DB2 V7.1 database is hosted on OS/390 Mainframe Server.
The JDBC V4.6 adapter is running on Solaris V5.7 box. Its connecting to DB2 database using DB2 UDB drivers as recommended by webMethods. We are using JDBC APP drivers (COM.ibm.db2.jdbc.app.DB2Driver) distributed by DB2.
The adapter on Solaris shows a valid sign indicating that it has made successfull connection. But when you try to configure the SELECT or Basic Notification, it doesn’t get the table list which is very fundamental.
Using the same userid which is being used in adapter configuration we are able to fetch the data from the tables using DB2 Command Center. So its not a privilege issue from the database side.
This is much more interesting. We have a JDBC DB2 Adapter configured on an NT box using the same userid and this adapter fetches all the tables from the same database.