Hi,
I just migrated from DB2 7.2, FP 13 on Windows 2000 to DB2 8.1, FP2 on XP.

When I try to get the table list using database metadata I am getting the following exception

com.ibm.db2.jcc.c.SqlException: The load module name for the stored procedure on the server is not found. Please contact your dba.

Code is as follows :

Class.forName("com.ibm.db2.jcc.DB2Driver");
Connection c = DriverManager.getConnection(...)
S.o.pln("Connection there");
DatabaseMEtaData d = c.getMetaData();
S.o.pln("DBMD there");
ResultSet rs = d.getTables(null,"PMA",null,new String[]{"TABLE"});

I am getting the connection and the DBMD but its causing exception at the ResultSet as above.
I have all the necessary drivers in the class path.

Any help will be greatly appreciated.

Thx
Karthik

Did you migrate both the server and the client?

Yes I did.
I figured out that the problem was in the stored procedure SQLTABLES and that it wasnt getting loaded properly.
However I do not know the cause or the solution.
Pl help.
Thx
Karthik