|
From: Colin B. <co...@ba...> - 2006-12-11 20:08:47
|
On Mon, Dec 11, 2006 at 04:16:32AM -0800, Ric wrote: > I am having a problem using Squirrel browsing a DB2 database running "DB2 v8.1.13.193", "s060801", "WR21371", and FixPak > "13". > > It was ok before I applied the fixpack. > > I have tried IBM's DB2JCC driver 2.7.58 and 2.10.27 (which came with fixpack 13) > > The symtoms I get when i connect to a database on a fixpack 13 DB2, I just see TABLE, PROCEDURE and UDT appear on the object tab in Squirrel, and nothing under any them. > > I dot believe the problem is priviledges, as this is the administrator account, and I am able to execute sql commands which work ok in the SQL tab ok. > > This is what I get in the log. > 6654 [Thread-3] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache - Could not get table types > com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805 Sounds similar to this problem with fixpack 10 http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0509zikopoulos/ You've probably missed a step when applying the fixpack. -- Colin Bell |
